Click here to Skip to main content
15,867,686 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hello.
I have a SQL DB (Phone Sim Cards Sales)
and need to print a sale receipt report that contains the sold Sim Card Serial Numbers but i need to put a 100 numbers per a page (25 rows and 4 columns) so the first cell of the second column continues data from the end cell of the first column and so on.

when i try the Tablix tool it fills all the 4 columns with the same values (repeating them vertically)

please help
thanks
Posted
Comments
Maciej Los 17-Aug-15 8:14am    
I'm sure you want to display data in 4 columns instead of spliting them.
https://www.mssqltips.com/sqlservertip/3493/display-a-fixed-number-of-rows-per-page-for-an-ssrs-report/
islamka2055 17-Aug-15 8:42am    
well thanx for the answer but the problem (wich i didnt mention) is that my project is on vb.net form application and the report is (RDLC) report not SSRS
if there is any way to help i will be so appreciated

1 solution

 
Share this answer
 
v2
Comments
islamka2055 17-Aug-15 8:42am    
well thanx for the answer but the problem (wich i didnt mention) is that my project is on vb.net form application and the report is (RDLC) report not SSRS
if there is any way to help i will be so appreciated
Maciej Los 17-Aug-15 8:55am    
See updated answer.
islamka2055 17-Aug-15 9:42am    
Thanx i tried it with RDLC and worked fine too
Maciej Los 17-Aug-15 10:12am    
You're very welcome!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900