[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 303
  • Last Modified:

CR from datatable

I have a datatable which I create dynamically, this datatable don t have the same number of columns every time when i create it.
Now i should create a report from this datatable in CR. The datatable looks like this one:

VrstaAvta      11/02/2007      12/03/2007 ...
JednoVratni      2            4
DvoVratni      2            4
TroVratni      2            5

And CR should look like this:
            JednoVratni      DvoVratni      TroVratni
11/02/2007      2            2            2
12/03/2007      4            4            5
 
0
amaimedia
Asked:
amaimedia
1 Solution
 
Pratima PharandeCommented:
You can try wih creaing new datable by converting values rows to colums like , where dtold is your old datable  and then bind new dt to CR


dim dt as datatable
Dim dr as DataRow

               For Each dr In dtold.Rows

                dt.Columns.Add(dr.Item(0))
            Next
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now