SSRS- How to remove pages and have continuous report

Question

SSRS- How to remove pages and have continuous report

Jeremy...

Ten Centuries

Points: 1299
More actions
January 18, 2012 at 9:53 am

#391343

Hey Guys. I'm new to the forum and wasn't able to find this issue anywhere so here we go.
My reports often have a couple hundred lines of data, nothing huge. When displaying the report, I have to keep clicking the next page button. Is there any way to display the entire report without having to continuously use the page forward/backward buttons? I know that if the report is too big, this could bog down the server, but the size of these reports should be fine. thanks for your help!
Jeremy

Viewing 15 posts - 1 through 15 (of 16 total)

You must be logged in to reply to this topic. Login to reply

patrickmcginnis59 SSCertifiable Points: 6483 More actions · Answer 1

Jeremy... (1/18/2012)
Hey Guys. I'm new to the forum and wasn't able to find this issue anywhere so here we go.
My reports often have a couple hundred lines of data, nothing huge. When displaying the report, I have to keep clicking the next page button. Is there any way to display the entire report without having to continuously use the page forward/backward buttons? I know that if the report is too big, this could bog down the server, but the size of these reports should be fine. thanks for your help!
Jeremy

If you're using report builder, maybe you could just make the height attribute of the "interactivesize" property bigger?

Jeremy... Ten Centuries Points: 1299 More actions · Answer 2

Thanks for the help. I'm actually using the BI Studio to create reports. Also, the size of the report constantly changes so the height of the report would need to change with the data.

Geoff A SSChampion Points: 11511 More actions · Answer 3

you can't. by default the page size is 8.5 x 11 and the report will fit onto that (or many pages) if needed.

you can of course, change the size to something larger and experiment, but you cannot say create a dynamically sized page size based on report size.

to change the page size to something longer, go to Report Properties, Page Setup. Change the Page Height property to something larger than 11.

Jeremy... Ten Centuries Points: 1299 More actions · Answer 4

Are you referring to maybe when the report has been exported to excel or PDF?

I've seen it done in the past where when viewing the report in Internet Explorer (sql server report manager), and it has not yet been exported, you can scroll without the need to click the next page button.

Jeremy... Ten Centuries Points: 1299 More actions · Answer 5

Geoff A (1/18/2012)
you can't. by default the page size is 8.5 x 11 and the report will fit onto that (or many pages) if needed.
you can of course, change the size to something larger and experiment, but you cannot say create a dynamically sized page size based on report size.
to change the page size to something longer, go to Report Properties, Page Setup. Change the Page Height property to something larger than 11.

Are you referring to maybe when the report has been exported to excel or PDF?

I've seen it done in the past where when viewing the report in Internet Explorer (sql server report manager), and it has not yet been exported, you can scroll without the need to click the next page button.

Geoff A SSChampion Points: 11511 More actions · Answer 6

http://technet.microsoft.com/en-us/library/dd255278.aspx">

http://technet.microsoft.com/en-us/library/dd255278.aspx

patrickmcginnis59 SSCertifiable Points: 6483 More actions · Answer 7

Geoff A (1/18/2012)
http://technet.microsoft.com/en-us/library/dd255278.aspx">
http://technet.microsoft.com/en-us/library/dd255278.aspx

http://technet.microsoft.com/en-us/library/dd255278.aspx

for some reason the reply I'm quoting to has the link as:

http://www.sqlservercentral.com/Forums/%3Cbr%3Ehttp://technet.microsoft.com/en-us/library/dd255278.aspx%3Cbr%3E

Jared SSC Guru Points: 61793 More actions · Answer 8

Select "Report" in the properties box, go to InteractiveSize and change Height to 0.

Jared
CE - Microsoft

Jeremy... Ten Centuries Points: 1299 More actions · Answer 9

SQLKnowItAll (1/18/2012)
Select "Report" in the properties box, go to InteractiveSize and change Height to 0.

Is this in the BI studio? I'm not seeing "report" in the properties box. thanks.

Jared SSC Guru Points: 61793 More actions · Answer 10

Jeremy... (1/18/2012)
SQLKnowItAll (1/18/2012)
Select "Report" in the properties box, go to InteractiveSize and change Height to 0.
Is this in the BI studio? I'm not seeing "report" in the properties box. thanks.

Yes, the selected item box right below "Properties" label on the window. Its where you can select the item that you want to see the properties of.

Jared
CE - Microsoft

patrickmcginnis59 SSCertifiable Points: 6483 More actions · Answer 11

Jeremy... (1/18/2012)
SQLKnowItAll (1/18/2012)
Select "Report" in the properties box, go to InteractiveSize and change Height to 0.
Is this in the BI studio? I'm not seeing "report" in the properties box. thanks.

I have visual studio 2008 that lets me do report projects. If I click on a report background, it brings up properties that has the page dimensions listed on it. If I click the "design" tab, I can then go just under the properties box, click the down arrow next to the current property and get a list of all the properties.

It seems to be a bit unintuitive however, almost like you have to set focus to the report background first with your mouse before the properties box will allow selecting other stuff.

Jeremy... Ten Centuries Points: 1299 More actions · Answer 12

SQLKnowItAll (1/18/2012)
Jeremy... (1/18/2012)
SQLKnowItAll (1/18/2012)
Select "Report" in the properties box, go to InteractiveSize and change Height to 0.
Is this in the BI studio? I'm not seeing "report" in the properties box. thanks.
Yes, the selected item box right below "Properties" label on the window. Its where you can select the item that you want to see the properties of.

Thank you!!! it worked. been trying to figure that out for over a month. found this forum and got the answer in less than a day. Thank you all.

Jared SSC Guru Points: 61793 More actions · Answer 13

Jeremy... (1/18/2012)
SQLKnowItAll (1/18/2012)
Jeremy... (1/18/2012)
SQLKnowItAll (1/18/2012)
Select "Report" in the properties box, go to InteractiveSize and change Height to 0.
Is this in the BI studio? I'm not seeing "report" in the properties box. thanks.
Yes, the selected item box right below "Properties" label on the window. Its where you can select the item that you want to see the properties of.
Thank you!!! it worked. been trying to figure that out for over a month. found this forum and got the answer in less than a day. Thank you all.

My pleasure 🙂

Jared
CE - Microsoft

dpsql SSChasing Mays Points: 653 More actions · Answer 14

Hi Jared,

This seems to work but when I have a report that is quick long it does not show all the data. Is there a way of getting around this where it will show the entire report?

I have reports that are very long and some that are very short. Setting the height to 0 works perfectly for my short reports but need to see my longer reports on one page without any data being cutoff.

Any ideas?

DP