how to show one record per one page
I am using reporting services to build a report to show customer's balance statements. I need each page only show one customer and related transactions and balance etc.
Now it shows several customers' balance in one page, how can i change it to show only one record per one page, and also one customer per one page when print it out.
how can i achieve that?
cheers
September 27th, 2007 7:01am
place all your controls in a list control
in the properties for the list control
group by customer
check the "page brake before" option
Free Windows Admin Tool Kit Click here and download it now
September 27th, 2007 8:11am
Hi Sir Please expand a bit more, I have been using SRSS for a while but has never attempted something like this, my reports are basic drag and drop stuff with single record paramaters, now I need to try and understand how to do the above. I am not a programmer
so I need more info than a normal guy would. Please help Using SQL Sever 2008 R2
December 23rd, 2010 8:10am