Hello All,
I am facing some difficulties in suppressing the duplicated columns.
My report looks like:
Group Header #1: Deal_NO
Details: Deal_No, Amount, Type, Related_Deal, Rate
Group Footer #1: Deal_NO
and the data is:
123
123, 1000, SELL, 144, 0.33
123, 1000, SELL, 165, 0.44
123, 1000, SELL, 167, 0.76
What I want is to display the first line only which is : 123, 1000, SELL, 144, 0.33
I placed for all the columns in the properties -> suppress -> formula which is {Deals.Deal_No} <> NEXT ({Deals.Deal_No})
and I tried to replace the amount with a formula @Amount
if {Deals.Deal_No} <> NEXT ({Deals.Deal_No}) Then Amount else 0, but it showed me the second line 123, 1000, SELL, 165, 0.44
and the amount 1000 was suppressed. So, can you please help in showing the first line only
Thanks
I am facing some difficulties in suppressing the duplicated columns.
My report looks like:
Group Header #1: Deal_NO
Details: Deal_No, Amount, Type, Related_Deal, Rate
Group Footer #1: Deal_NO
and the data is:
123
123, 1000, SELL, 144, 0.33
123, 1000, SELL, 165, 0.44
123, 1000, SELL, 167, 0.76
What I want is to display the first line only which is : 123, 1000, SELL, 144, 0.33
I placed for all the columns in the properties -> suppress -> formula which is {Deals.Deal_No} <> NEXT ({Deals.Deal_No})
and I tried to replace the amount with a formula @Amount
if {Deals.Deal_No} <> NEXT ({Deals.Deal_No}) Then Amount else 0, but it showed me the second line 123, 1000, SELL, 165, 0.44
and the amount 1000 was suppressed. So, can you please help in showing the first line only
Thanks