July 23, 2013 at 2:48 am
HI
Please assist. I have a table with PDF files. I would like to display these files in a report.
i have the following table:
Num Type FileSource
1 pdf 0x25044462D ...........
I would like to view the pdf file in a report.
I've tried the following:
1. Add table, replace textbox with rectangle and add image. Image source is from Database and MIME type is PNG. When I run the report I get the following error: "An error ocurred during client rendering. Parameter is not valid".
2. Tried to create a Hyperlink to open PDF - Textbox Properties, Action, Go to URL, Select URL = FileSource. The hyperlink does not work.
Please HELP!!! :w00t:
Thank you, Monique
July 23, 2013 at 3:41 am
You can try to convert the pdf to an image and add that one in your report:
Reporting Services 2008 – Embedding a PDF Document
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 23, 2013 at 3:44 am
HI, that is the exact example i was working with, could not get it to work.
Is there not an easier way?
Thanx for your reply!:-)
July 23, 2013 at 3:49 am
monique 88355 (7/23/2013)
HI, that is the exact example i was working with, could not get it to work.Is there not an easier way?
Thanx for your reply!:-)
What went wrong? Did you implement the CLR into SQL Server?
This solution talks about using javascript to open up a popup with the PDF file:
http://www.sqlservercentral.com/Forums/Topic970422-150-1.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 23, 2013 at 3:52 am
haha, that is the problem! I have no idea what you are talking about :hehe:
I already have the PDF stored in the db. Should this then be converted to image?
This is what I did:
Create an RS project and add a report. Replace the detail textbox with a rectangle followed by an Image control. The hierarchy should be Tablix \ Rectangle \ Image, use the Document Outline View (Ctrl + Alt + T) to check.
Set the image properties:
• Image source = Database
• Field = PDFPageImag
• MimeType = png
#DontKnowWhatImDoing :w00t:
July 23, 2013 at 3:57 am
That's not enough. You can't just tell the PDF that it is now an image. You can't tell an apple that it is now an orange and expect to behave it like that 😀
The article is fairly detailed, I can't explain it better myself.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 23, 2013 at 3:58 am
thank you!
February 19, 2014 at 11:53 pm
monique 88355 (7/23/2013)
HIPlease assist. I have a table with PDF files. I would like to
display these pdf files[/url] in a report.i have the following table:
Num Type FileSource
1 pdf 0x25044462D ...........
I would like to view the pdf file in a report.
I've tried the following:
1. Add table, replace textbox with rectangle and add image.
Image source[/url] is from Database and MIME type is PNG. When I run the report I get the following error: "An error ocurred during client rendering. Parameter is not valid".2. Tried to create a Hyperlink to open PDF - Textbox Properties, Action, Go to URL, Select URL = FileSource. The hyperlink does not work.
Please HELP!!! :w00t:
Thank you, Monique
What form are using to store the pdf files in the data base? If you store them as images, you can view this post:
http://forums.asp.net/t/1659152.aspx?How+to+create+a+flipcart+like+panel+for+showing+products+in+gridview
Besides, I think this post also offers a solution on displaying pdf in report.
http://www.sqlservercentral.com/Forums/Topic970422-150-1.aspx
Hope one of them can serve your purpose.:-)
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply