IWR Drill through to an invoice image? 2

[wannabee2]

I need to provide drill through capabilities for the following:

1)Cube to IWR
2)IWR to invoice image..

I'm thinking that step 1 shouldn't be a problem but would like to know the pit falls (running Series 7 MR2) if any.

I'm also thinking that step 2 will require a call to a stored-procedure that receives say the invoice number from the IWR report as a parameter and goes out and fetches an invoice image.

Anybody do this before? Any suggestions would be appreciated. Thanks

 

[CanadianTechie]

The standard way of achieving this functionality, would be to store the filename of the graphic image (BMP unless you are running the new MR2 which I believe supports JPEG), and include a picture frame in your Impromptu report -- the source tab of the Picture Properies dialog box will allow you to select the "Load using file name in column" -- you will be able to populate the "prefix with path" field, if your db field doesn't contain the full path (my recommendation) and select from your catalog folders, the field name which contains the image name...and voila!!

Pedro Cardoso
A.K.A CanadianTechie

 

[griffindm]

Actually, a better way to do this would be with dynamic hyperlinks, probably using a PDF copy of the invoice. The standard method Pedro mentions is best used with smaller bitmap graphics such as a product illustration.

This can be done if you can create a database table of the relationships between the invoice number in the accounting database and the file names of the PDF files on a web server.

This would work in IWR. Haven't done it myself, but did investigate the possibility. Just create a link in the base IWR report using standard HTML syntax, as in:

 <a href=&quot;[URL unfurl="true"]http://webserver_name/filname.pdf&quot;>Get[/URL] Invoice Image</a>

Regards,

Dave Griffin





The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ20-2863 first!

http://www.decisionsupportgroup.com