Click here to Skip to main content
11,702,107 members (63,629 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 18: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 Maciej Los 420
1 Sergey Alexandrovich Kryukov 355
2 OriginalGriff 314
3 Mika Wendelius 119
4 CHill60 105
0 OriginalGriff 8,344
1 Sergey Alexandrovich Kryukov 7,507
2 CPallini 4,922
3 Maciej Los 4,371
4 Mika Wendelius 3,556

Advertise | Privacy | Mobile
Web03 | 2.8.150819.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