March 17, 2008 at 4:00 pm
There is probably an easy answer to this, but I'm just too tired... :doze:
How do I make a long report appear all in one page in the browser.
I want to be able to scroll through the whole report without changing pages.
I don't seem to find a way to do this, but it could be I need more coffee... 😛
Anyone know how to do this?
thx!
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
March 17, 2008 at 6:56 pm
I don't know if there's a setting in the report designer but you could change the behavior by specifying additional parameters in the URL.
For example if there's a report named "Report Project1\Report3" then this would display Report3 as HTML on one page.
http://localhost/ReportServer?\Report+Project1\Report3&rc:Command=Render&rs:Format=HTML3.2&rc:LinkTarget=_self
Reference:
Edit: added reference.
March 17, 2008 at 7:18 pm
Thank you, that's good to know.
However, I'm looking for some setting within report designer in VS, if at all available.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
March 18, 2008 at 5:34 am
However, I'm looking for some setting within report designer in VS, if at all available.
I kind of thought you might be looking for a way to change in VS but the URL is the only way I know of.
My understanding is that Report Designer generates the RDL file and that the rendering is a function of the Reporting Server. So if the RDL file could supply a rendering method it would seem the Report Server could use that. But after skimming over the Report Definition Language specification there does not appear to be a way to supply a rendering method in the RDL.
According to this post a member of the Reporting Services team confirms changing the default rendering behavior is not possible either.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1464828&SiteID=1
March 18, 2008 at 7:41 am
Todd,
Thanks so much for clarifying and for the valuable input!
There are other rendering-type capabilities in VS Report Designer, such as repeating header/footer, page breaks etc. I thought being able to set the actual browser page size would be among those settings.
It is certainly a good thing to include in future SSRS releases, although I'm not sure what would be involved there.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
March 19, 2008 at 2:04 am
There is a way to do it in SSRS:
1. On the layout tab, click the properties icon
2. choose report from the drop down list
3. expand the section interactive size
4. set the height to 0
Done !!
March 19, 2008 at 6:07 am
Thanks for the steps Mark. Would not have known that property existed otherwise.
March 19, 2008 at 9:01 am
Mark Kenyon (3/19/2008)
There is a way to do it in SSRS:1. On the layout tab, click the properties icon
2. choose report from the drop down list
3. expand the section interactive size
4. set the height to 0
Done !!
Thank you Mark! I will give that a spin!
Cheers,
Marios
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
March 20, 2008 at 6:10 am
A great tip, thanks!
However, I find it interesting, now that I am aware of this property, that it doesn't seem to work if you explicitly set the height value. For example, I have a report that I run in landscape mode, so I set the width to 11in, the height to 8.5in, but when I render the report it doesn't seem to make a difference. It still comes out to some random value for the height and ignores what I put in the property.
I'll have to research this a bit more.
March 20, 2008 at 9:05 am
chris (3/20/2008)
A great tip, thanks!However, I find it interesting, now that I am aware of this property, that it doesn't seem to work if you explicitly set the height value. For example, I have a report that I run in landscape mode, so I set the width to 11in, the height to 8.5in, but when I render the report it doesn't seem to make a difference. It still comes out to some random value for the height and ignores what I put in the property.
I'll have to research this a bit more.
It could be a bug.
Anything that does not make sense to me in SQL Server, I categorize as a bug! 😀
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
March 20, 2008 at 3:45 pm
If you design the report (rdl) and want to display long report a single page, open the report in visual studio, choose layout design, find InteractiveSize in Report properties window, by default you should have 8.5in, 11in, change all to 0.0in. Deploy the report to target server, and view it online.
The down side is performance, it will take longer time to render report and display on client side.
Hope that help
March 21, 2008 at 5:54 am
Do you have page breaks set anywhere within the report?
March 21, 2008 at 1:00 pm
The page break will work when render in PDF.
March 25, 2008 at 11:01 am
chris (3/20/2008)
A great tip, thanks!However, I find it interesting, now that I am aware of this property, that it doesn't seem to work if you explicitly set the height value. For example, I have a report that I run in landscape mode, so I set the width to 11in, the height to 8.5in, but when I render the report it doesn't seem to make a difference. It still comes out to some random value for the height and ignores what I put in the property.
I'll have to research this a bit more.
I am also having trouble with this. The reverse of the original post. I have a report that may be around 100 pages. Interactive height: 8.5, width: 11. Looks good in the viewer and PDF, but the last page of the viewer (usually only 3 pages) takes forever to load and contains the bulk of the report. I do not have any defined page breaks because I have enough trouble getting around all the grouping page breaks. Could this be something I am doing wrong with the report viewer control?
November 28, 2008 at 12:49 pm
Yeah, I thinks a bit goofy how they have this property laid out. If you right click up in the top left square (where the parameters are) and go to the report properties, then layout, this is a completely different property than if you just left click on that same square, and then go to the properties view window (the one you can pin or unpin). Seems they could have added PageSize and InteractivePageSize to the same window in the pop-out box.
Viewing 15 posts - 1 through 15 (of 19 total)
You must be logged in to reply to this topic. Login to reply