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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics