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 |
|
rwlopez
Yak Posting Veteran
80 Posts |
 Posted - 2007-04-24 : 14:54:52
|
| I am trying to create a report where there will be three separate reports. For example first there will be a salesperson summary page, then a detail page, then a page with some graphs. What I want to happen when I run the report is for the report to display the summary, detail, and graph page for the first salesperson and the repeat for the second salesperson. I have been trying to do this with sub reports but I have not had much luck getting the reports to exhibit this behavior. Has anyone tried to do this before? |
|
|
jhermiz
3564 Posts |
Posted - 2007-04-24 : 15:12:25
|
| GROUP BY SALESPERSON works!You can set a page break per salesperson as well.The graph is simply another object on the report.Very simple.Programmers HowTo's -- [url]http://jhermiz.googlepages.com[/url] |
 |
|
|
|
|
|
Sub Reports