Employee Photo on BAQ?

[aarong (Aaron Gulley)]

Is it possible? I want to display the employees photo on the BAQ and effectively turn it into a dashboard.

At the moment, I’m pulling EmpBasic.PhotoID and EmpBasic.PhotoFile but PhotoFile is blank and PhotoID just displays the ID of the Employee (ID I gave the photo)

Help

[ckrusen (Calvin Krusen)]

There was a post a few weeks back about putting images in forms. Search for that.

edit

Well, it was for sending images to reports, but there’s a lot of overlap that might be helpful

Is there a way to print a Part Image on a SSRS Report

Is there a way to print a part Image on an SSRS Report. Would like to show pictures of parts on quotes and sales orders. I would guess that I could keep duplicates of the part pictures on the SSRS server and have the server reference the part images. However, that means keeping the Epicor DB and the SSRS Website in Sync. Has anyone looked at this before? It seems like it would be a common request. Thanks, DaveO

[aarong (Aaron Gulley)]

Yeah I’ll take a look but can it be done in a BAQ?

[ckrusen (Calvin Krusen)]

There’s no data type of “picture” that a BAQ could could contain, so it really be done as a customization on the dashboard. The BAQ will just give you the info the customization needs to fetch the picture.

[ckrusen (Calvin Krusen)]

Here’s an even better link (complete with video-how-to)

Display a part image in a customization - Example Video

Here’s an example video of displaying a part image in a dashboard customization. The same idea can be applied to any screen or image type. [Epicor Customization to Display a Part Image] And of course the code: public class Script { // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added Module Level Variables' Comments! ** // Begin Wizard Added Module Level Variables ** private EpiDataView edvV_PartImage_1View; // End Wizard Added Module Level Variables ** /…

[aarong (Aaron Gulley)]

Hi Calvin,

Are you able to take a look at this? I can’t seem to stop Indirect_Description from duplicating. If I put it in a XML CAST the BAQ designer just freaks out.

Any ideas?

TEAGLE-LiveSupervisors.baq (71.7 KB)

[ckrusen (Calvin Krusen)]

Unfortunately I’m not very confident in how the FOR XML PATH thing works.

But on the one BAQ I have that uses it, my Subquery Criteria has many more rows - with some relating to tables in other subqueries.

Maybe your subQueries 3,4 & 5 need extra criteria in the SubQuery Criteria, including references to fields in the other subq’s tables…

[Banderson (Brandon Anderson)]

The For XML Path simply takes the whole result from the sub query and jams it into a single field formatted with XML. Then you bring it up a level by using a single sub select, then do some string manipulation to remove the XML formatting junk.

[aarong (Aaron Gulley)]

Hi Banderson,

How would I display Indirect.Description? On this BAQ without the BAQ having a melt down.

[Banderson (Brandon Anderson)]

I don’t really know. I don’t have anything in that table in my DB. Can you give me a better description of what’s happening then “Melt down” or “Freaks out”. Do you get a message that says what’s going on? Is it timing out? Something?

So I popped open your query, and you can’t just join on company. You’re going to get duplicates… (# of laborHeadReqs X # of IndirectRecords)