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 |
|
run4ever
Starting Member
3 Posts |
 Posted - 2009-10-12 : 03:45:31
|
| Hi, i have one report in which i use a Matrix table , and i need to see (in the standard Html view) all the records in a single page , without a pagination ,then. This is valid , i repeat, for the standard Html view , not for the export issue!Is it possible to do that? Thanks a lot!!!! |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-12 : 08:16:32
|
| Yes, just change you interactive page size to be some rediculously huge number that you would never ever approach. Like 8 1/2 width by 1000 HeightJohn |
 |
|
|
run4ever
Starting Member
3 Posts |
Posted - 2009-10-12 : 09:48:59
|
quote:
Originally posted by JCirocco
Yes, just change you interactive page size to be some rediculously huge number that you would never ever approach. Like 8 1/2 width by 1000 HeightJohn
hi John, i have modified the interactive page size with a huge number , but the problem is not solved!Once i deploy the report on my intranet , SSRS render 8 pages (like the first time) !!! Another important things is that I have no Page Breaks into the report !thanks a lot ! |
|
|
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
Posted - 2009-10-12 : 10:06:48
|
Yea i found that out awhile back but it doesnt work with all lengths if something is longer than 150 or something it cuts it down to another page which is annoying.But then again, should really be showing that much info on a report, just cut up the report into subreports which are triggered off by the parent report. That also solves performance issues :Pquote:
Originally posted by JCirocco
Yes, just change you interactive page size to be some rediculously huge number that you would never ever approach. Like 8 1/2 width by 1000 HeightJohn
|
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-12 : 10:25:49
|
| I didn't know about the 150 or so limit...How many rows are in the sample that goes out to 8 pages?John |
|
|
|
run4ever
Starting Member
3 Posts |
Posted - 2009-10-12 : 11:29:55
|
quote:
Originally posted by JCirocco
I didn't know about the 150 or so limit...How many rows are in the sample that goes out to 8 pages?John
the number of rows for the 1st page is 206. |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-12 : 13:27:38
|
| 99in. length should cover that plus it is under the 150 limitation. Give that a try under interactive size.John |
|
|
|
|
|
|
|
|
show all records of a Matrix in one page