Exporting a table with images to PDF

#1

Hello,


Im needing to export a table that contains photos. I need to export it including the rendered photos. If I export it to excel it would only show the url of the images. The table also has a lot of information and we also have many filters at the top of the dashboard.

I cant seem to include these in a Resport or Scorecard.

Are there any alternatives or configurations I can apply to the dashboard ?

Thanks.

#2

Section 3 in the article on Adding a data image should be exactly what you are looking for. If you are still having issues with setting it up, please contact Support so they can help you troubleshoot it.


If you are still interested in exporting the table though, there are multiple ways to convert URLs to images on the Excel side. You can automate the process by creating a plug-in that uses the Dundas BI Export Completed event to execute your code/macro.



#3

Thank you for yout reply


Yes I can populate the table easily with data but not export them. I can only seem to export as excel as the pdf id only a screenshot and nothe the whole scrolable table.

I think th plug-in might be the way to go.
Can you give me any more insight into doing that. Will have a look around on the web to see what there is aswell.


Any help will be much appreciated.


Thank you ,

Alex

#4

Section 3 in that article is for populating a scorecard rather than a table. Exporting the scorecard as PDF will give you the full result.


We have an example that creates an extension using the Export Completed event and add a password to the exported file. This should a good starting point for your needs as well.

#5

Sorry another quick question as we are trying a workaround. How would we wait for the Photos to render before ecporting in a report?. It seems to not render all photos in the pdf. I now there is a Before exporting option but unsure of what to do there.

#6

Unfortunately I cannot seem to reproduce your situation.

I made sure the Support team is aware of this difficulty. They will work with you to reproduce it and find a suitable solution.

#7

I’m having the same issue.

I don’t know if you are using a 3rd party tool to host the images, but in my case the images were all Dropbox URLs. The official response is that it’s not supported since it’s a 3rd party.

However, a brute force solution could be to just delay the export until the images are finished. Since the # of records returned based on filters can be drastically different, this probably won’t work 100% of the time.

//Tells the report to wait until everything is done.
e.isAsync=true;
window.setTimeout(function(){e.deferred.resolve();},1000); //wait 1000 ms = 1s
1 Like