"DataBand1 Then DataBand1Total" nested inGroupBandFooter

Stimulsoft Reports.WEB discussion
Post Reply
high_pio
Posts: 10
Joined: Tue Nov 22, 2016 2:40 am

"DataBand1 Then DataBand1Total" nested inGroupBandFooter

Post by high_pio »

How to "DataBand1 Then DataBand1Total" nested in GroupBandFooter?

In other words, how to complete "individuation total" ?

Detail:

GroupBandHeader_Master

DataBand_Master

GroupBandFooter_Master
{
DataBand_Detail_Addition (Relation: DataBand_Master.Column "EmpNo" equals this.Column "EmpNo" )

DataBand_Detail_Addition_Sum1 (i.e. Get Sum of DataBand_Detail_Addition that Column "type" is A)
DataBand_Detail_Addition_Sum2 (i.e. Get Sum of DataBand_Detail_Addition that Column "type" is not A )

DataBand_Detail_Deduction (Relation: DataBand_Master.Column "EmpNo" equals this.Column "EmpNo" )

DataBand_Detail_Deduction_Sum1 (i.e. Get Sum of DataBand_Detail_Deduction that Column "type" is A)
DataBand_Detail_Deduction_Sum2 (i.e. Get Sum of DataBand_Detail_Deduction that Column "type" is not A )

// Note Note Note
// Here insert following

DataBand_Detail_C_Sum1 (i.e. Get Sum of "DataBand_Detail_Deduction and DataBand_Detail_Addtion" that Column "T" is A)
DataBand_Detail_C_Sum2 (i.e. Get Sum of "DataBand_Detail_Deduction and DataBand_Detail_Addtion" that Column "T" is not A )

DataBand_Detail_Tax (Relation: DataBand_Master.Column "EmpNo" equals this.Column "EmpNo" )

DataBand_Detail_Tax_Sum1 (i.e. Get Sum of DataBand_Detail_Tax that Column "type" is A)
DataBand_Detail_Tax_Sum2 (i.e. Get Sum of DataBand_Detail_Tax that Column "type" is not A )

}
Last edited by high_pio on Wed Nov 23, 2016 4:36 am, edited 3 times in total.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: "DataBand1 Then DataBand1Total" nested inGroupBandFooter

Post by HighAley »

Hello.

Sorry, maybe we don't understand your question right.
Could you describe your question more detailed with samples?

Thank you.
high_pio
Posts: 10
Joined: Tue Nov 22, 2016 2:40 am

Re: "DataBand1 Then DataBand1Total" nested inGroupBandFooter

Post by high_pio »

HighAley wrote:Hello.

Sorry, maybe we don't understand your question right.
Could you describe your question more detailed with samples?

Thank you.

>>> i reWrite my question. could you help me ?
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: "DataBand1 Then DataBand1Total" nested inGroupBandFooter

Post by HighAley »

Hello.

Did you try to use the SumIf() function?
You could read more about this function at the Syntax of Aggregated Functions and Totals with Condition sections of the User Manual.

Thank you.
Post Reply