Toad World® Forums

How to embed Image in Toad Data Report

I want to use Toad Data Reports to publish nice looking reports. When I change the Toad image for my company Logo it does not embed the image and others do not see the logo. I used the option "Mail friendly HTML" but that did not correct the issue.

Is there an option in the Toad Data Report designer to embed the image?

Hmmm... not seeing a way to embed logos/images in the report template, although I thought that this happened by default. I wonder if the next best thing, then, is to house the image on a shared drive location, via the ImageURL field? e.g. in the Settings attributes for your image, as in snap below.

image

I can try that. But I fear network contention. There will be hundreds of reports produced and many users.
Also, what happens if you make a ToadData Report using the Toad image and send to a person who does not have TDP installed? Is the image still there. I think it is. So why are these reports different.

Can you send the report as a PDF rather than HTML? When you do HTML it has to reference the picture file and so it either needs to be either (1) what you send them or (2) on an accessible network drive or web folder

Only html can be embedded in an email. All other forms of report, (pdf, rtf, xlsx, etc) have to be attachments and that is one more click to get to the report. (My wrist honestly wouldn't put up with it) :joy:

But I think I solved the issue. I changed the location of the image to C:\Program Data\Quest Software and had the TIC admin copy the image to that directory on the TIC server. So the file is there when the report is made. This seems to work. It appears that this image is a dependent file at run time but does get embedded if the file can be found on the TIC Server.

I found another irritating bug while doing this. I have about 30 reports at this point and needed to edit all of the tdr files. So I thought I would use the TIC "Edit Script" option. When you do this it saves a copy of the script to C:\Users\xxPeronal.NameXXX\AppData\Roaming\Quest Software\Toad Data Point 5.3\Automation Publishing. If you the edit the report it also is saved to similar location. But the path to the tdr IN the automation script is still the old path. So the change you made in tdr during edit mode did not pick up the change.

To get around this I had to "get a copy" of the script. Save to my normal working location. Edit the file and save to normal working location. And then republish and overwrite the script on TIC.

Another note: The path I work out of has to be a public path such as C:\Program Data\Quest Software. If not other Analysts cannot edit or get a copy of the automation script. It this case it errors out because the path cannot be created. Originally I was using a subdirectory of MyDocuements.

That's a lot of work arounds but I'm up and running.

1 Like