Multicolumn report, flow left to right

[Robert]

Hi there,

I know this message has been asked before but back in 2007 & 2009, but does the latest reporting release support a multicolumn reporting feature that has the ability to flow from left to right?

I want to to create a two column report where the items flow from left to right first then move to the next line.

I'm using the latest reporting version: Telerik_Reporting_Q1_2011_v5_0_11_316.

Thanks for your time,

Rob

[Robert]

If the above is not possible then do you think it would be possible to create two textbox columns in the detail area and have one column only display odd items and the other display even items?

Basically I have an SQL datasource that contains two items. For sake of argument assume they are named "Item" and "Quantity". Depending on the supplied parameter the size of my datasource can vary by quite a large number. Thus, I want two columns for each item so that the number of pages needed are reduced. Plus it looks a lot neater.

Item:         Qty:                 Item:         Qty:
Bike             1                  Bus            7
Scooter        2                  Lorry         12
Car              10                Boat            2
...                  ...                 ...              ...

Thanks,

Rob

[Robert]

Ok, I have a fairly easy work around for this problem. I will post my solution shortly (I need to go out right now).

Rob

[Robert]

So here is my description on how I got around displaying multiple columns from left to right when using an SQL datasource. My datasource downloads all data from the database and stores the result as a List (array).  For the record I use VB.net 3.5.

STEPS
1. Create 2 columns in a master report (or more if that is what you need)

2. Create two sub reports (one for the left column & one for the right column)

3. Make both sub reports download all of the data from the datasource and save it as a List (array)

4. Create a loop that removes all "Even" (multiples of 2) row counts from the List (array) for the left column Sub Report. And for the right column Sub Report write a loop that removes all "Odd" row counts from the List (array). I do this filtering in my Business Class objects and then pass the resulting filtered lists to the sub reports.

5. On the main report, place the "Even" sub report (the one that filtered out multiples of two row counts) in the first column and the "odd" (the one that filtered out non multiples of two row counts) sub report in the right column.

6. Run the main report and you should have two columns that look as if its displaying items from left to right.

I hope this helps.