cancel
Showing results for 
Search instead for 
Did you mean: 

How to apply two conditions in Suppress in Section Expert

Former Member
0 Kudos

Hi,

I need your help in applying to conditions in the Details section for the suppress in the Section Expert. My Report looks like:

Details A: {@SUM -DR}   {@SUM -CR}   {@SUM -Balance} {@TT-CLASS}

Details B: {Deal_No}   {Image_No}   {Amount}   {@Comments}  

Currently, I am applying a condition to suppress both Details A and Details B in the section expert:

{@TT-CLASS}="OB"


Now while running the report, I got some duplicated deals ex:


123   1   1000   Reversal

123   1   1000   Reversal

124   2   2000   Approved


So I applied a condition in the section expert for the details A and B which is:


({Deal_No} = next({Deal_No} ) and {Image_No} =next( {Image_No} ) )

or 

{@TT-CLASS}="OB"


And it is still giving me the duplicated deals when I am running the report. So can you please help.


Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Right click on field object-> format editor-> select common tab-> enable "the suppress if duplicate" option. Then it suppress the duplicate records.

Former Member
0 Kudos

Suppress if duplicate will not work because sometimes the deal no will be the same, however the amount will be different. Therefore I need to show the line in the report.

abhilash_kumar
Active Contributor
0 Kudos

Duplicates are usually caused by an incorrect Join.

What is the datasource of the report - tables/views, stored procedures, sql query?

If you're reporting against tables/views, see if checking the 'select distinct records' option under the 'Database' menu helps.

-Abhilash

Answers (0)