Click here to Skip to main content
15,888,527 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
Hi all,

RDLC or CRYSTAL REPORT

How I can Generate Dynamic Column at run time in these Reports

>> here, I a have a DataTable table with 5 Column and some no of rows.
I need to display all this column in my report..

the no of column may change during Runtime. sometimes it may 4 or some time it may 6 etc..

Ie , DataTable column count not fixed during my “Select Query execution” it may change.
Im using MySql as back end.

How I can Display this in my Report?

Thanks
Posted

1 solution

For a start you are asking for an answer in 2 completely different products, each requiring an example or tutorial to answer. First you need to pick a reporting tool SSRS or CR (don't pick CR as it is crap), then work through some tutorials and then ask specific question when you get stuck.

When you use a matrix it will detect the number of columns and display them as required. Your trick is in constructing the query to service the report correctly.
 
Share this answer
 

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