I'm trying to replicate an Invoice using Telerik Reporting. The detail section contains a table that lists each order's item. It holds around 15 items per page but I need it to hold 30.
Basically I want to turn this:
------------------------------------------------------------------------
# | Description | Qty | Unit Price | Price
------------------------------------------------------------------------
1 | XXXXXXXXXXXXX | 001 | 15.00 | 15.00
2 | YYYYYYYYYYY | 005 | 2.50 | 12.50
Into this:
------------------------------------------------------------------------
# | Desc. | Qty | U. Price | Price | # | Desc. | Qty | U. Price | Price
------------------------------------------------------------------------
1 | XXXXX | 001 | 15.00 | 15.00 | 3 | ZZZZZ | 002 | 15.00 | 30.00
2 | YYYY | 005 | 2.50 | 12.50 |
I think it can be done using a crosstab by I tried and couldn't do it. Any help is appreciated.