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 |
|
bkana
Starting Member
18 Posts |
 Posted - 2006-12-21 : 10:29:13
|
| I'm fairly new to RS and have a problem. I have a query that pulls information on people, courses they have taken, their score and so on. I have a date parameter setup so I can run it by year. Everything works ok on the query side, I get all the information I need on all the people and the courses they have taken. However, when I run the report, I do not get a separate page for each person and their relative information. The first page shows the first name and the rest of the 700 pages list all the courses and other information, with no break. How do I render the report so that I can get a separate page(s) for each person and their specific info? I know this a broad statement but I can provide more detail if need bethx,Bill |
|
|
kdnichols
Posting Yak Master
232 Posts |
Posted - 2006-12-21 : 11:22:44
|
| Hello bkana,You need to go into the field and right click on that group and choose Edit Group.At least in SSRS 2000 there is a check box for Page Break at End.I think that will do it for you!Hope this helps.Kurt |
 |
|
|
bkana
Starting Member
18 Posts |
Posted - 2006-12-21 : 11:37:49
|
| Thank you Kurt, I'll give it a try. |
|
|
|
kdnichols
Posting Yak Master
232 Posts |
Posted - 2006-12-21 : 11:43:10
|
| Hello Bill,I also forgot to tell you it will be on the General Tab which should be showing anyway when you right click and click edit group.Let me know if it works for ya!Kurt |
|
|
|
bkana
Starting Member
18 Posts |
Posted - 2006-12-21 : 12:02:41
|
| Kurt,I found it and it worked ok, but I found some information on lists and list controls that seem to be working as well. Thanks for the speedy response, I'm on a deadline to have this done by tomorrow evening!Thx again,Bill |
|
|
|
kdnichols
Posting Yak Master
232 Posts |
Posted - 2006-12-21 : 12:57:24
|
| Hello Bill,Glad it worked.Merry Christmas!Kurt |
|
|
|
bkana
Starting Member
18 Posts |
Posted - 2006-12-22 : 15:43:02
|
| Hey Kurt you still there, have another question for you?Merry X-mas to you too! |
|
|
|
|
|
|
|
|
Need separate pages for each person..help