Row visibility experssion
In reporting services 2008 R2, I have rows grouped on Name. This can be drilleddown to reveal further information, one including sales amount, on another row. So, two rows for all the information. There are instances where a Name has sold more than once in a day, therefore, the sales amount will be on multiple rows. IF the Name occurs 5 times (meaning the person has sold 5 times), I'd like to add another row with Sum(sales_amount). The total should be hidden by default and will only reveal when there is more than one sales. Please, can anyone help me on this? thanks!
February 17th, 2011 8:22am

Hi, Based on your description, I created a report based on the following dataset: Name SalesAmount AAA 1 AAA 2 BBB 5 The report looks like: Since currently you can drilldown to reveal sales amount, please refer to the steps below to add the total row. 1. Add a group footer of the Name group. 2. In one cell of the group footer row, specify the expression like =Sum(Fields!SalesAmount.Value) for displaying the sales total. 3. Select the cell of sales total, set the Hidden property to the expression like =(Count(Fields!SalesAmount.Value)<2) 4. In the grouping pane, click on the small triangle and select "Advanced Mode" to show static members. Select the (Static) item which corresponding the group footer row, set the Hidden property to True, and also set the ToggleItem property. If anything is unclear, please feel free to ask. Thanks, Tony Chain Tony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
February 25th, 2011 3:46am

Perfect! But in the model you created, the person named BBB should only be 5. Eight is the running total, I believe. This worked for me anyway. One question though, I could not find the "Advanced Mode to show static members". I'd assume it's at the bottom where it says Row Groups | Column Groups. In the Row Groups, I have two items -- Name (parent), and Sales (details). Nothing on column group. The small triangle > Group properties > Add group, Add total, delete group, & group properties* -->> Advanced.. ... where it only says "Set additional group properties: Recursive parent:__________[fx] ; Document map:__________[fx] Thank you!
February 25th, 2011 12:25pm

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

Other recent topics Other recent topics