on 04-07-2015 2:05 PM
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
Hi,
Right click on field object-> format editor-> select common tab-> enable "the suppress if duplicate" option. Then it suppress the duplicate records.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.