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 |
|
LLatinsky
Starting Member
38 Posts |
 Posted - 2007-11-14 : 09:54:31
|
| We have a report that needs to list all person(s) appointments for a given period of time. The stored procedure the report is using is very straight forward and it returns a dataset of all appointments ordered by person and start date. The tricky part is to list 1 appointment with details on the top of each page and all other appointments but the one that's on top displayed on the bottom. So that, if there are ten appointments total in a given period of time for a person, page 1 will have appointment 1 on the top and appointments 2 to 10 on the bottom. Page 2 will have appointment 2 on the top and appointments 1, 3 to 10 on the bottom, and so on, for all people that have appointments in a given time period. The developers working on this report say there is nothing that can be done in reporting services and tell me it all should be constructed in a stored procedure by looping through appoinments and writing all combinations to a temporary table and then doing a select from it. I can hardly believe that there is no mechanism of supressing rows in reporting services. Is there any way to do it besides changing the stored procedure? Thank you |
|
|
|
|
|
Display data in a report