Solved

CR from datatable

Posted on 2007-11-27
1
276 Views
Last Modified: 2010-04-23
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
Comment
Question by:amaimedia
1 Comment
 
LVL 39

Accepted Solution

by:
Pratima Pharande earned 500 total points
ID: 20357074
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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
This video discusses moving either the default database or any database to a new volume.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now