Skip to main content



      Home
Home » Archived » BIRT » Multiple tables in a single report
Multiple tables in a single report [message #258061] Fri, 12 October 2007 09:33 Go to next message
Eclipse UserFriend
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 Go to previous message
Eclipse UserFriend
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.
>
Previous Topic:Problems rendering documents with IDocArchiveReader/Writer impl
Next Topic:does birt support crystal report setting formula ?
Goto Forum:
  


Current Time: Wed May 14 07:27:15 EDT 2025

Powered by FUDForum. Page generated in 0.45050 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top