Click here to Skip to main content
15,911,531 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
Hi Everyone,

I want to make a cross tab report in c#.
The table columns in cross- tab report must contain two or more columns.
<img src="http://i40.tinypic.com/27ytmib.jpg" border="0" alt="Image and video hosting by TinyPic">

And these columns Column 1, Column 2, Column 3 represents the device. And we have three devices here. Like Column 1 is a device1 and on 10-08-2013 it runs for 13 hours and consume 120 liter of diesel. And the Column2 and Column3 also have their running hours and consumption details.

And the Column1, Column2 ,.... are dynamic. Means they can increase or decrease.

But the problem is that I am not able to get the functionality in Crystal report that how I manage RUN and Consumption columns under single device column in Cross-Tab.
Because to generate crystal report I am using a xsd dataset. In which I have to defined the columns. But due to increasing and decreasing in Device Columns it is hard to change the dataset.

Hope it helps to understand the question.

Thank You.
Posted
Updated 20-Aug-13 23:43pm
v2
Comments
Maciej Los 16-Aug-13 6:13am    
Not clear... ;(
leonidasvijay 16-Aug-13 8:05am    
At what point you want to clarify. Is the image not visible to you or the question?
I tried my best to explain it.
Maciej Los 16-Aug-13 8:23am    
Both...
Try to explain it using words instead images. If it's possible, post example input data and expected output.

1 solution

 
Share this answer
 
Comments
leonidasvijay 21-Aug-13 6:47am    
Sorry this wont work. Because it only contains normal cross tab example. My question is how to get the two or more columns under one column.
Yesudasan Moses 21-Aug-13 6:50am    
you need to use some tricks... along with this...

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900