Creating reports and dashboards | Stimulsoft community forum

Posted: **Tue Jun 10, 2008 9:06 am**

Sorry if i'm repeating part of a previuos post, but the datasource base is about the same, the problem is different.

I need to design a report that contains an "offering" and a "offering confirmation" with this structure (to obtain indentation on forum i use the code tag):

Code: Select all

Offering header
    Name of installation
        Works to do (detail)
        TOTAL money amount of Works to do
    Name of installation
        Works to do (detail)
        TOTAL money amount of Works to do
    Name of installation
        ...
    TOTAL MONEY OF AMOUNTS OF WORKS TO DO FOR THIS OFFERING
Offering feet

---> New page

Offering confirmation header
   "We confirm the order for the following installations:"
   Name of installation 1
   Name of installation 2
   ...
   TOTAL MONEY OF AMOUNTS OF WORKS TO DO FOR THIS OFFERING
Offering confirmation feet

I have a flat datasource whose records contain all offerings data (no datarelation). The table structure is:
Offering number
Installation name
Work id
Total amount of works for the installation

The number of records is given by the number of works.

DataSource example:
Say we have three installations, two in one offering and one in another.
Say that for each installation we have two works.
In this case the datasource is made of 6 rows (one for each work); example (fields are in the sequence stated above):

(Offering 001)
Record 1: 001 Installation1 Work01 500
Record 2: 001 Installation1 Work02 500

Record 3: 001 Installation2 Work03 130
Record 4: 001 Installation2 Work04 130

(Offering 002)
Record 5: 002 Installation3 Work05 250
Record 6: 002 Installation3 Work06 250

The final report result should look like:

Code: Select all

Offering number: 001
    Installation1
        Works Id:
           Work01
           Work02
        Total amount of Works: 500
    Installation2
        Works Id:
           Work03
           Work04
        Total amount of Works: 130
Total offering number 001: 630

--- New Page (Confirmation for offering 001)

Confirmation for offering number: 001
    "We confirm the order for the following installations:"
    Installation1
    Installation2
Total confirmation for offering number 001: 630

--- New Page (and new offering)

Offering number: 002
    Installation3
        Works Id:
           Work05
           Work06
        Total amount of Works: 250
Total offering number 002: 250

--- New Page (Confirmation for offering 002)

Confirmation for offering number: 002
    "We confirm the order for the following installations:"
    Installation3
Total confirmation for offering number 002: 250

Anyone can help with some design hint?

I have the limitation that the data source cannot be changed and i cannot write any code in report.

Thank you.

Posted: **Mon Jun 23, 2008 3:30 am**

Hello Fabio,

Please try following:
1. Create new datasource based on other datasource. This datasource must be master for Offering and Offering confirmation tables.
2. Place on page: DataBand for new master datasource. HierarchicalBand for Offering table. DataBand for Offering confirmation. First DataBand must be
master to next databand's.
3. Header of Offering confirmation must have StartNewPage = true (or NewPageBefore in EngineV2).

Thank you.

Creating reports and dashboards | Stimulsoft community forum

Report with two pages

Report with two pages

Report with two pages