Hi, I am working to produce a cross-tab report that would display customized data from a two dimesional array structure.

The idea is that report is essentially a graphical representation of the 2-dimesional array created during run-time. It's easy to create an array structure with 8 Rows x 12 Columns, but I am not sure how to create a cross tab report with a table that has 8 Rows x 12 Columns.


           JAN   FEB   ....   DEC

Total 1   1      1             2000
Total 2  120   7             600
'' ''
Total 8   3      5              213

I believe once I figure out how to place a table on report, then I will be better equip to assign the array data onto the table....

Anyone that has previously thought up a solution to my problem please feel free to guide me through this... I tried google the topic but  haven't found anything good.





Edited by RealQMan - 22 Aug 2007 at 12:08pm

Yes, exactly. I will have an array which report base on.

Before report is generated, my c# application will run some calculation and store the results into the array. It would be better if I can somehow create a dataset that I can bind during design-time, and all i really need to do is dump the data at run-time and allow the report to display the cross-tab for me. But how do i create a database table that models array data????? I would create the array at run-time unless someone can explain the reason not to.

I am more familiar with .net syntax than CR syntax.. so my answer would be to pass it to CR as a datasource. What would be the clean way of doing it..???

I will spend more time trying out your suggestion. It's unfortunate there's not a large number of articles, and tutorials that I can use to save the trouble of asking someone who knows. I'll let u know if I am stuck on anything else.

wish me luck

I was able to get the report up running due to your suggestion. It's nearly perfect except that the report is broken up vertically into two sections.
                     
                      Section 1                                    Section 2
             Jan   Feb  Mar  Apr  ...  Aug  |     Sep    Oct    .. Dec    Total
Row A     1    2      3      4          8      |        9        10        12       78  
Total        1     2     3     4          8       |        9        10        12      78


My guess is that the columns are broken up b/c of limited spaces on a printed page. So, the first section is printed on page 1 and second section is printed on page 2.

Where inside the code would I can force all columns to completely print on one page?