Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 300
  • 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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