Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
harlingtonthewizard
Constraint Violating Yak Guru
352 Posts |
 Posted - 2009-02-02 : 03:21:47
|
| I have two simular reports and when run in Visual Studio 2005 one returns the report as a single very long page where the other pages it into many pages. What parameter/setting determines this behaviour? |
|
|
AvanthaSiriwardana
Yak Posting Veteran
78 Posts |
Posted - 2009-02-02 : 04:52:37
|
| Go to crystal report and then click on the left hand side panel(where you have page header and report header etc) and then click on 'Section expert'Avantha SiriwardanaBeware of bugs in the above code; I have only proved it correct, not tried it. (Donald Knuth) |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-02 : 09:06:09
|
quote:
Originally posted by harlingtonthewizard
I have two simular reports and when run in Visual Studio 2005 one returns the report as a single very long page where the other pages it into many pages. What parameter/setting determines this behaviour?
there's a property called interactive height for report. Set it to 0 for getting entire report in same page |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-02 : 09:06:47
|
quote:
Originally posted by AvanthaSiriwardana
Go to crystal report and then click on the left hand side panel(where you have page header and report header etc) and then click on 'Section expert'Avantha SiriwardanaBeware of bugs in the above code; I have only proved it correct, not tried it. (Donald Knuth)
This is sql server reporting services forum not crystal reports  |
|
|
|
harlingtonthewizard
Constraint Violating Yak Guru
352 Posts |
Posted - 2009-02-02 : 18:36:47
|
| Sorry I cannot find interactive height only interactive size and both reports are set to 21cm x 29.7cm an A4 landscape page? Basically I still cannot see the difference between the two report settings. I am sure there is a setting somewhere I am missing:) Can you please help me fing the setting.Thanks |
|
|
|
harlingtonthewizard
Constraint Violating Yak Guru
352 Posts |
Posted - 2009-02-03 : 00:11:53
|
| From post above, I have Interactive Heigth under Interactive Size however as stated both reports are set to the same size but one renders in VS2005 as one long page while the other as many pages? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-03 : 10:02:07
|
| have you set property insert page break after... for any of your containers? table,matrix...? |
|
|
|
harlingtonthewizard
Constraint Violating Yak Guru
352 Posts |
Posted - 2009-02-03 : 19:52:37
|
| All tables on both reports do not have any page breaks set. The report that pages has two tables and the report that has one long page has one table. All tables on both reports have repeat header rows and header should remain visible when scrolling set on. |
|
|
|
|
|
|
Report as single vs many pages