Creating reports and dashboards | Stimulsoft community forum

Hi,

I have my report layout Grouped by InvoiceNo and NewPage is set for each InvoiceNo. I have two Datasources one with 'InvoiceDetails' and the other is 'InvGroup' which is 'Data from other Data source' grouped by InvoiceNo then Type to have the sum of Amount displayed in footer.
So the Layout should be like

-------------------------------------------------------
AddressLine1, Invoice No:1 (Group Header - grouped by InvoiceNo)
AddressLine2,
AddressLine3

Type Amount
------------------------------------------------------
A 100 (Databand1 - source InvoiceDetails)
B 150
A 25
-------------------------------------------------------
Sum of A 125 (Databand2 - source InvGroup)
Sum of B 150
--------------------------------------------------------
Invoice Total: 275 (Group Footer1)
--------------------------------------------------------
Invoice Date:1/1/2009 Amount in words: Two Seven Five (Group Footer2 - should be at bottom of the page)



To introduce the Sum of (Type), I created a 'Data from other Data source' and used that as the source for Databand(2).

The issues I am facing.
1. After including Databand 2, Group footer 1 & 2 are not appearing
2. When two invoices are selected for reporting, Databand 2 is appearing for the second Invoice only and not for the first.


Can someone guide me how to achieve this using the Bands available?

Hi StimulSaro,

Please create a DataRelation between InvoiceDetails and the 'Data from other Data Source'. Then set the DataBand as a master and the 'Data from other Data Source' as the detail and place the bands as follows:

GroupHeader
DataBand1
GroupFooter
DataBand2

Thank you.

Hi Edward,

I tried this approach, but setting Master data for InvGroup makes the group details getting printed for each Invoice Detail line. i.e.

A 100
Sum of A 125
Sum of B 150

B 150
Sum of A 125
Sum of B 150

A 25
Sum of A 125
Sum of B 150

And also it is including Summary of Other Invoice Numbers, i.e. the summary details is the same for all Invoice numbers.

Any clue what's wrong with this approach.

Thank you.

Hi StimulSaro,

In this case please place the DataBand2 inside of the container. Container can be placed on the GroupFooter. This will work in EngineV2. CanBreak must be set in true for the Container and for the GroupFooter.

Thank you.

Hi Edward,

I tried this and I could see only one summary detail and others are missing.

i.e.

InvoiceNo.1

A 100
B 150
A 25

Sum of A 100

Total 275



InvoiceNo.2

B 125
C 75
A 50

Sum of A 100

Total 250


Some of B is missing for InvoiceNo.1 and For InvoiceNo.2 also it shows the same value of InvoiceNo.1
Can you identify what is wrong now?

Thank you.

Hi, StimulSaro.

Then please do as follows:

DataBand0
GroupHeader
DataBand1
GroupFooter
DataBand2

The relation scheme here is Master-Detail-Detail. DataSource for the DataBand0 must be generated based on 'Data From Other Data Source'. This will be a main master Data Source for other two DataSources (InvDetails and InvGroup).

'Data From Other Data Source' must be created based on InvoiceDetails data source and contain just list of invoices (one line per invoice) or you just can add another regular SQL based DataSource for this.

Height of the DataBand0 can be set in zero.

Thank you.