Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

CR from datatable

Posted on 2007-11-27
1
283 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

856 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