Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# Windows WPF MySQL , +
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 27-Feb-13 19:34pm

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

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.
  Permalink  

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



Advertise | Privacy | Mobile
Web03 | 2.8.141220.1 | Last Updated 28 Feb 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100