September 13, 2017 at 12:21 am
I have a SSRS report with multiple pages, I want to print only specific pages / or say selected pages..
1) for example I want to print up to page 5 in 50 page
2) for example I want to print up to page 3-4 and 5-7 pages alone in 50 page
but in real it prints the whole report instead of that single page.
Are there any ways to achieve this any settings are there i am using SQL server 2012 ?
September 13, 2017 at 2:00 am
Export the report to a file type (i.e. xlsx, pdf, etc). Open the file and then Print in there, in the pages options, define your print page requires. For example 1, 3, 5-9, 27, 30, 40-50 would print the page 1, 3, pages 5 though to 9 (5, 6, 7, 8, 9), pages 27 & 30 and finally pages 40 through to 50 (40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50).
I'd never recommend printing directly from the SSRS web portal. Those printouts aren't great.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 13, 2017 at 4:54 am
The above solution is work around , but i cant ask client to print as such right ?
September 13, 2017 at 6:04 am
yuvipoy - Wednesday, September 13, 2017 4:54 AMThe above solution is work around , but i cant ask client to print as such right ?
Why not? If they only want specific pages, then they need to specify they only want certain ones. Otherwise, you'll need to create a separate report, which only includes the pages they are interested in, and they use that one. Just remember, any changes need to be replicated on both reports.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 13, 2017 at 6:31 am
Thom A - Wednesday, September 13, 2017 6:04 AMWhy not? If they only want specific pages, then they need to specify they only want certain ones. Otherwise, you'll need to create a separate report, which only includes the pages they are interested in, and they use that one. Just remember, any changes need to be replicated on both reports.
How can this be achieved here ?
I am not a C# or .net export
"Render method in Reporting Services web service with Device Information "
https://msdn.microsoft.com/en-us/library/reportexecution2005.reportexecutionservice.render(v=SQL.105).aspx
how can this be implemented?
September 13, 2017 at 7:45 am
yuvipoy - Wednesday, September 13, 2017 6:31 AMThom A - Wednesday, September 13, 2017 6:04 AMWhy not? If they only want specific pages, then they need to specify they only want certain ones. Otherwise, you'll need to create a separate report, which only includes the pages they are interested in, and they use that one. Just remember, any changes need to be replicated on both reports.How can this be achieved here ?
I am not a C# or .net export
"Render method in Reporting Services web service with Device Information "
https://msdn.microsoft.com/en-us/library/reportexecution2005.reportexecutionservice.render(v=SQL.105).aspx
how can this be implemented?
I'm not sure what you're asking. Are you asking how to create a different report that shows the same data but only some of the report? (that's the part of my post you underlined). You'd have to recreate your report the same way you did before, but only include the parts your client wants.
The page you've linked to shows you how to use the code, you'd have to put this into some kind of (web) application. In the example, the report render is saved to disk as a .mht file.
Personally, I still think the problem is with the user, not the report (as we refer to it in the office: "PICNIC (Problem In Chair, Not In Computer)". If someone wants all the data, but the ability to click print and only get some, then they probably only really need some of it. Otherwise, if they do want it all, but only want some on record, then asking them to save off what they want is not a difficult task for them. Much like when you have a Word Document open, but you don't care about printing specific pages. you don't complain to the source to remove those pages, but you still "want" them, you print out the pages you want. It is not a hardship.
P.s. The link you gave is for SQL Server 2005, is that the version you're running? I would suggest upgrading at some point, as 2005's support ended in April last year.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply