Solved

CR from datatable

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

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

810 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