How to hide same value using Visual Studio 2010 ?

(0) Share

Report

Posted on by Ardhi A Rahman

Hello, how to hide same value using VS ?

from:

to:

*have same invoice but Jumlah Barang value only need on the first one

thanks in advance guys

All responses (12)

Answers (3)

Suggested answer

Ardhi A Rahman 50 on at

Like (0)

Report
RE: How to hide same value using Visual Studio 2010 ?

[quote user="Ardhi Aulia Rahman"
Sergei Minozhenko said:
Hi Ardhi,

Just replace in your expression True with "" and False with Fields!JumlahBarang.Value.

ok its clear thanks:

but how to counter this case if there are just one and one line but different invoice ?

before:

after:

what should i add on my IIF ?
[/quote
OKEH I FIXED IT THE CASE WITH THIS :

=IIF((Fields!NoBuktiPIB.Value = Previous(Fields!NoBuktiPIB.Value)), "", Fields!JumlahBarang.Value)

cause i have same invoice, but when i need another invoice with Jumlah Barang 1 and 1 but the invoice is different so i change the code.

Thanks guys
Verified answer

Blue Wang on at

Like (0)

Report

RE: How to hide same value using Visual Studio 2010 ?

Hi Ardhi,

You can try to write code in report properties, add your judgment conditions, and then pass code.YourFunctionName.
Ardhi A Rahman 50 on at

Like (0)

Report

RE: How to hide same value using Visual Studio 2010 ?

[quote user="Blue Wang"]
Hi Ardhi,

=IIF((Fields!JumlahBarang.value = Previous(Fields!JumlahBarang.value)),"",Fields!JumlahBarang.value)
[/quote]
thanks for reply, its already clear. but i have another case to counter on comments
Ardhi A Rahman 50 on at

Like (0)

Report

RE: How to hide same value using Visual Studio 2010 ?

[quote user="Sergei Minozhenko"]
Hi Ardhi,

Just replace in your expression True with "" and False with Fields!JumlahBarang.Value.
[/quote]
ok its clear thanks:

but how to counter this case if there are just one and one line but different invoice ?

before:

after:

what should i add on my IIF ?
Verified answer

Blue Wang on at

Like (0)

Report

RE: How to hide same value using Visual Studio 2010 ?

Hi Ardhi,

=IIF((Fields!JumlahBarang.value = Previous(Fields!JumlahBarang.value)),"",Fields!JumlahBarang.value)
Verified answer

Sergei Minozhenko 23,089 on at

Like (0)

Report

RE: How to hide same value using Visual Studio 2010 ?

Hi Ardhi,

Just replace in your expression True with "" and False with Fields!JumlahBarang.Value.
Ardhi A Rahman 50 on at

Like (0)

Report

RE: How to hide same value using Visual Studio 2010 ?

[quote user="Sergei Minozhenko"]
Hi Ardhi,

Could you, please, share your expression? You need to combine IIF statement where you compare current value and Previous and if it's the same return empty string, if not, return the current value.
[/quote]
if i doing like this:

it will become like this:

how to returning those value ?
Ardhi A Rahman 50 on at

Like (0)

Report

RE: How to hide same value using Visual Studio 2010 ?

[quote user="Mahmoud Hakim"]
you can modify the design and group by your field

but you will create a level for group and details.

group value 1

details-----------

group value 2

details--------
[/quote]
thanks mahmoud for reply,

how can i get these explanation / descriptions per point
Suggested answer

Sergei Minozhenko 23,089 on at

Like (0)

Report

RE: How to hide same value using Visual Studio 2010 ?

Hi Ardhi,

Could you, please, share your expression? You need to combine IIF statement where you compare current value and Previous and if it's the same return empty string, if not, return the current value.
Ardhi A Rahman 50 on at

Like (0)

Report

RE: How to hide same value using Visual Studio 2010 ?

[quote user="Sergei Minozhenko"]
Hi Ardhi,

Have you tried to use "Previous" function?

docs.microsoft.com/.../report-builder-functions-previous-function
[/quote]
thanks Sergei for reply,

thanks for the solution but it doesnt meet what i want