Multiple tables in a single report [message #258061] |
Fri, 12 October 2007 09:33  |
Eclipse User |
|
|
|
Originally posted by: rupeshkp.gmail.com
How do we create a report using birt designer so that one gets following
capability:
1. Lets say we have a report to show customer orders by order status
(pending, completed, etc)
2. Against each order status, report should create a table and then list
down all the associated orders for that status.
If we had a single table to show these details, GROUPING by order status
would have addressed the requirement.
Query
-----
How do we design the report in designer so that per order status it
creates a new table.
|
|
|
Re: Multiple tables in a single report [message #258179 is a reply to message #258061] |
Fri, 12 October 2007 15:26  |
Eclipse User |
|
|
|
Hi Rupesh,
YOu could achieving this report by nesting a table within another table
report item and sharing the same dataset between the too.
Steps below
- Create a table report item and bind it to the "orders" dataset, group by
key="orderstatus"
- Now merge the details cells
- Add a nested table report item into the detail area
- Drag and drop the data items you want to show in the table detail area.
Let me know it it works
--Rima
"Rupesh Porwal" <rupeshkp@gmail.com> wrote in message
news:91b6799bf9efcec5bd4e49d1ed9d0158$1@www.eclipse.org...
> How do we create a report using birt designer so that one gets following
> capability:
>
> 1. Lets say we have a report to show customer orders by order status
> (pending, completed, etc)
> 2. Against each order status, report should create a table and then list
> down all the associated orders for that status.
>
> If we had a single table to show these details, GROUPING by order status
> would have addressed the requirement.
>
> Query
> -----
> How do we design the report in designer so that per order status it
> creates a new table.
>
|
|
|
Powered by
FUDForum. Page generated in 0.03471 seconds