August 6, 2013 at 6:33 pm
Hi all,
I'm thinking how to fulfill customer request to pull from db all info related to given Sample_ID (which could include picx, docs, scans ) and give him ability to print it !!!!
I can to pull this info to the table and try to provide hyperlinks to those scans, for it's the only way I can think of, no idea what env I'll need to achieve it.
I know that in ssrs design view I can :
-Insert Text box
- select Property
- select action
- select go URL and configure it, and it's work after viewing report.
I can do this in tablix cell, and probably to add some dinamics into URL name (like rownum)???
Or probably it can done with some already availabe features, the same way like I can do link/clik for xml in column???
Not sure can I can all this configuration programatically inside my sp.
I'm trying it right now. Probably I can configure it to some generic URL, then select .pdf from binary, upload it somewhere in the server and insert that link into wanted column on the SSRS report. I even can hard code URL in field property and if document exist upload it into that URL, it will be different for each cell.
Do you think it's doable ? or reasonable -). I'm on SQL 2008 and we can run SSRS server too.
Appreciate you input and critics
Best
mario
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply