Show only once
I HAVE A REPORT WITH PUBLICATION, DATE, ACCOUNT. Multiple accounts have same publications so i don't want to see them repeating in each row. Only if there is a change in publication i want to see the publication name in my report. Basically when ever there
is a change i publication name i want to see the name.svk
June 13th, 2011 2:27pm
Hi Varun,
For this you could try setting the hide duplicates propoerty or try using the Previous function in the expression box.
HTH,
RamRam
Free Windows Admin Tool Kit Click here and download it now
June 13th, 2011 2:31pm
Hi varunsvk,
According to your description, you would like to hide the repeating publication
name in each row unless the publication name is changed, right?
If in this case, I suggest you using Visibility properties of the textbox and Previous function to reach your goal, please refer to the following steps:
1. Right-click the textbox which filled with publication name, and then select Text Box Properties.
2. Select Visibility tab, and select “Show or hide based on an expression” option.
3. Click “fx” button, and then type in the following expression:
=Iif(Previous(Fields! publication.Value)=Fields! publication.Value, true, false)
4. Click OK to apply these settings.
After complete these steps, you will find that the repeating name could hide unless the publication name is changed.
Let me know if you have any question,
Thanks,
Eileen
June 15th, 2011 1:34am