Adding an Image stops SSRS uploading to Report Style

Epicor ERP 10
1

Here is an odd one.

I am making a custom report style for ApCheck (Payment Remittance Advice) and am trying to add our Company Logo as I do with most forms, however it will not upload the zip if I make it Database, only if I do one embedded.
image
Maybe I am being thick but I have done this many times with other reports, I would then normally go into the Report Style and select the logo I want.

I have removed boxes the original form had inside the header but that made no difference.

Anyone got any ideas whatā€™s up here?

1 Like
2

Are you manually importing the company logo? If yes! I would suggest against this and use the ReportImages table.

Create a new dataset in the report and lookup the ReportImages

Example

SELECT * ---I pull particular columns..---
FROM ReportImages_" + Parameters!TableGuid.Value + "

Columns:

Logo
LogoMimeType

You can use the report style logo store. This would avoid any logoā€™s being uploaded into the report.

2 Likes
3

No we have various images uploaded in Epicor and we select them from the Report Style ā€œImage Listā€ but I cannot do this for this report because as soon as I try to ā€œinsert imageā€ as ā€œDatabaseā€ into the SSRS header then save and zip, it will not upload to the Report Style with the error I pasted above.

However, if I change to an ā€œembeddedā€ image and select one from disk, it works fine (but that is not what I want).

Here is what I would like:

image
image

4

Show me your dataset query?

The image source type should be: Database

and try hard coding a mimetype: image/jpeg

5

I follow this method and itā€™s worked but Iā€™ve never tried it on AP check. Dynamic url logos in reports won't render all of the sudden - #77 by BenWheeldon

Perhaps share your RDL file and I can try it on my Pilot system.

6

Hopefully this will yield a clue:
APRemit.rdl (323.6 KB)

7

Only specific report work with the company logo

Here is KB0050698 that explains it.

This has been like it since they first implemented this back in 10.2.600 (donā€™t quote me on the version )ā€¦ I wish they had extended it to other reports.

With that said, if your report isnā€™t in the list and it isnā€™t then you are stuck with either embedding the image directly into the RDL or creating a folder on the report server, storing the images there and then linking to the picture object on the RDL to the location of the fileā€¦

If you need any more details then let me know and I will do up an SOP

EDIT Might not be tonight

2 Likes
8

I think @Hally is right, here is the error I get in Classic UI

image

9

I have not met a report yet that the steps i list in Dynamic url logos in reports wonā€™t render all of the sudden - #77 by BenWheeldon hasnt worked on. The functionality is there in the background for every report. Epicor just havenā€™t added the dataset and image component into every SSRS RDL.

This seems irrelevant and more in the way you are uploading as this is referencing the ChkPrint report which is the other one in this report style.

You havent added the dataset required for this to run. Therefore it is failing because you are referencing a dataset that doesnt exist.
image

4 Likes
10

What the??? All this timeā€¦Thanks, Iā€™ll have to revisit. I previously had been messing with report images, but somehow never been able to get that to workā€¦ and sometimes lifeā€™s too short to undo past indiscretionsā€¦ I think in some of the reports I had been working on the ReportImages dataset was not there.

1 Like
11

So yeah the dataset is not there in 99% of the reports. However if you add it yourself mimicking one that does have it then it will work.

As I mentioned in that post as well, you can expand to add more images too.

2 Likes
12

a bald man wearing a red sweater with a star trek logo on his chest

Seems that the KB needs a bit of an update.

I think @utaylor comment after your post sums it up pretty well thanks @BenWheeldon

I must admit I am shocked that all this time since they added the functionality they have not just gradually added the dataset to the rdls.

1 Like
13

I was revisiting this a moment ago. The steps are very specificā€¦ I was wondering why I was not seeing the reportimages table in the database. It seems that it is either specifically selecting the company in the report definition and then clicking retrieve, or itā€™s the act of adding the image object with the formula and uploading the RDL again makes all the differenceā€¦ On reflection I think it is the formerā€¦ as my SOAck was not showing the report images until I selected the company and added clicked on retrieve, although that prior to this I did have an imageā€¦ Time for a bit of a write for posterity me thinksā€¦

1 Like
14

Thanks for the help everyone but especially Aaron and Ben - now I have been able to fix it by as directed, adding the Dataset ReportImages and the two required fields.

I think I have said this before but every day is a learning day, and this forum and itā€™s people are such a valuable resource!

1 Like
15

Thanks Aaron, I didnā€™t quite get what you were suggesting when I read it at first but I understand now.

16

For posterity, Iā€™ve created a little document that will help future people (and me).

Feel free to sanity check it.

Adding Logos to Epicor Reports

Perhaps it might be a useful one to stick in experts corner :slight_smile: Not saying Iā€™m an expert, but it may make it easier to find in future.

3 Likes
17

Although I can now select an image in the Report Style and I can upload the SSRS I now get a failure when I try and print preview it.
Here is a piece of the error:

ā€œā€¦An error has occurred during report processing. ā€”> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset ā€˜ReportImagesā€™. ā€”> System.InvalidOperationException: ExecuteReader: CommandText property has not been initializedā€¦ā€

Fixed, I compared with a working report and found the missing expression (which your pdf shows).

1 Like
18

I helped someone Yeah!
a cartoon character says " hooray i 'm useful " while holding a can of food

3 Likes
19

ā€¦ and on a Friday!

1 Like
20

Yes still Fridayā€¦ but nearly not.

1 Like