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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-11-10 : 07:30:36
|
| Zafar writes "Hi, I trying to create report using Reporting Services.My data set is returning a list of 4 customers. I want to generate four reports (One for Each Customer) in Letter Format titled to each Customer. Can anybody tell me how do we format records in Letter Format generating seperate letter for each record.Thanks" |
|
|
jhermiz
3564 Posts |
Posted - 2005-11-10 : 19:13:38
|
quote:
Originally posted by AskSQLTeam
Zafar writes "Hi, I trying to create report using Reporting Services.My data set is returning a list of 4 customers. I want to generate four reports (One for Each Customer) in Letter Format titled to each Customer. Can anybody tell me how do we format records in Letter Format generating seperate letter for each record.Thanks"
SELECT CUSTOMERNAME FROM CUSTOMERS GROUP BY CUSTOMERNAMEThen create a report with a CUSTOMERNAME GROUPPING, and PAGE BREAK AFTER each group.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
 |
|
|
|
|
|
Reports in Letter format