Click here to Skip to main content
13,141,576 members (56,473 online)
Rate this:
Please Sign up or sign in to vote.
See more: , +
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
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web04 | 2.8.170915.1 | Last Updated 28 Feb 2013
Copyright © CodeProject, 1999-2017
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