How is suppress GroupTotal depended on data?

Stimulsoft Reports.NET discussion
Post Reply
MARIMUTHU K
Posts: 101
Joined: Wed Jul 26, 2006 8:03 am
Location: CHENNAI-TN, INDIA

How is suppress GroupTotal depended on data?

Post by MARIMUTHU K »

Hi hi hi

We are using StiReport 1.6.1
desingned Total and Grand Total based on Data.

E.g

Name Account No. Payout Mechanism Transaction Amount
Advantage Fund
NA / NA NA E/Cheque Payment 21 536,905.92
Group Total 21 , 905.92
Grand Total 26 1,116,338.0

I want suppress Group Total depended on Table Data.

If (Sum(table1.Data)==table1.Data)
e.Value="";
else

e.Value=Sum(table1.Data);

Where is palced? or other way.

I have given to HighlightCondition, but Sum(data) is not allowed .

How do to?

Please provide Solution.


Thanks of Advance.


Regards,
Marimuthu K
Edward
Posts: 2913
Joined: Fri Jun 09, 2006 4:02 am

How is suppress GroupTotal depended on data?

Post by Edward »

KMarimuthu wrote:Hi hi hi

We are using StiReport 1.6.1
desingned Total and Grand Total based on Data.

E.g

Name Account No. Payout Mechanism Transaction Amount
Advantage Fund
NA / NA NA E/Cheque Payment 21 536,905.92
Group Total 21 , 905.92
Grand Total 26 1,116,338.0

I want suppress Group Total depended on Table Data.

If (Sum(table1.Data)==table1.Data)
e.Value="";
else

e.Value=Sum(table1.Data);

Where is palced? or other way.

I have given to HighlightCondition, but Sum(data) is not allowed .

How do to?

Please provide Solution.


Thanks of Advance.


Regards,
You may use ternary operation. Please see http://forum.stimulsoft.com/Default.aspx?g=posts&t=6 for details.
Thank you.
MARIMUTHU K
Posts: 101
Joined: Wed Jul 26, 2006 8:03 am
Location: CHENNAI-TN, INDIA

How is suppress GroupTotal depended on data?

Post by MARIMUTHU K »

Yes,

The correct way is using ternery operator.

{Table1.CNT==Sum(Table1.CNT)?"":Sum(Table1.CNT).ToString()}

This way is correct But I want Suppress with Merge.




Thanks .



Regards,
Marimuthu K
Edward
Posts: 2913
Joined: Fri Jun 09, 2006 4:02 am

How is suppress GroupTotal depended on data?

Post by Edward »

KMarimuthu wrote:Yes,

The correct way is using ternery operator.

{Table1.CNT==Sum(Table1.CNT)?"":Sum(Table1.CNT).ToString()}

This way is correct But I want Suppress with Merge.




Thanks .



Regards,
Yes we have this property. It is called ProcessingDuplicates. It allows to hide duplicated rows of data. Please see flash tutorial: http://www.stimulsoft.com/livedemos/Rep ... cates.html
Post Reply