Click here to Skip to main content
11,488,877 members (78,158 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: C# Windows WPF MySQL , +
Hi all,


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?

Posted 27-Feb-13 19:34pm

1 solution

Rate this: bad
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.

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 489
1 OriginalGriff 328
2 Sascha Lefèvre 135
3 _Asif_ 125
4 _duDE_ 121
0 Sergey Alexandrovich Kryukov 9,308
1 OriginalGriff 8,375
2 Sascha Lefèvre 3,334
3 Maciej Los 2,996
4 Richard Deeming 2,370

Advertise | Privacy | Mobile
Web02 | 2.8.150520.1 | Last Updated 28 Feb 2013
Copyright © CodeProject, 1999-2015
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