VB.NET - Crystal Reports:Dynamic columns - Asked By kibika on 29-Mar-13 01:55 PM

what I want to to do is:

 1) create a datatable wit the column name as Column1, Column2, Column3.... till max columns you expect can come
 2) same number of parameters as Col1, Col2 Col3..... till max columns you expect can come
 3) in code behind I fill the columns name into parameters Col1, Col2 Col3.....
   and build my table with the data and the columns name in the table as  Column1, Column2, Column3....
 4) the next and final step is, arranging data into my report
   a) place the parameters in the header section which consists the column names
   b) and place the columns into the details section

  hence the columns which containing data should be displayed automatically and dynamic

What I am missing is the code behind to fill the columns name into parameters Col1, Col2 Col3..... from the Access 2003 database.

I am using VB.net 2005.