January 13, 2007 at 9:18 pm
I have some reports that have a large number of columns and a large number of rows.
Is there a way to do a freeze pane like in Excel in Sql Server Reporting or
how can I have the report output 10 or 20 rows at a time and when the user hits the enter or clicks a button, it'll show the next 20 rows?
Please, please help. Any suggestions.
Thank you.
January 15, 2007 at 1:03 am
Don't know how to freeze pane but yoou can count and show only 10 or 20 rows in that case report will show you one page with 10 or whatever number . By clicking next page tab you can see next lines.
RowNumber() is the function. it will work on group option....
let me know if you need more help on this.....
January 15, 2007 at 2:21 am
There are table properties at the bottom of the General tab for keeping the header visible and a similar thing for matrix controls.
The best way to deal with large numbers of rows is of course to group them and provide a document map which allows users to dip in at the most interesting group.
If there's no grouping, but just a very long list of rows, you have to ask who's really going to take the time to look at it row by row?
For columns which need to appear on every page, there's a 'fixed header' property.
January 15, 2007 at 9:28 am
Thanks very much Vandy.
I would like further help if you don't mind.
Should I put the Rowcount() function in the detail group of the table (actually, for a table that seems like the obvious place, but I just want to confirm)?
On a couple of reports I'm using matrices, again, how do I count the lines in the matrices. ( I know this may seem elementary, but I don't know.)
Thanks again for your help.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply