How to repeat first column and break after 3 column
Hi ,
i had a table report in which i have a column group on product . now its coming like following. where p1 to p11 is all the product used by customer and
in below rows i have customer name, product balance, turnover, start date and etc. all different attributes of product. i have about 30 attributes
issue is if customer is using 1 to 5 products then its fine to print and view is also fine. but if customer have 50 product then i have a long wide report . i have a scroll bar at end.
is it possible where i can have first column (attributes ) repeat on every page and i have page break if product is more the 5.then even i can print that.
Product
P1
P2
P3
P4
P5
P6
P7
P8
P9
P10
P11
Customer number
CustomerFullName
CustomerTypeName
Balance
turnover
End date
Start date
TotalLimit
TotalUsed
TotalAvailable
TotalLimit_exp_date
......
....
July 26th, 2012 5:11am
Following image for more details.
Free Windows Admin Tool Kit Click here and download it now
July 26th, 2012 5:18am
Hey Mujahid,
The below link provides a step by step approach to what you are looking at doing:
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/32f28407-e1ca-457e-92fd-d292e32dde4e/
HTH.
Cheers,
IceQBPlease mark correct answers :)
July 26th, 2012 5:23am