May 24, 2012 at 8:52 am
Hi,
I've got a report with 3 levels of data - Detail / Property level / City level. I have a parameter which determines how much data is expanded - 3 Options Expand All / Expand Groups / Expand None - So first option shows
London
1 Some Street
Detail
Detail
1 Some Street Total
2 Some Street
Detail
Detail
2 Some Street Total
London Total
2nd Option shows
London
1 Some Street
1 Some Street Total
2 Some Street
2 Some Street Total
London Total
3rd Option shows
London
London Total
So I have set visibility on Detail group to an expression based on the parameter and set it to toggle from Property
I have then set expression on property group again based on parameter and set toggle on City
All works fine if I select All expanded - expand / Collapse works perfectly
If I select Expand Groups / Expand None - Initially it looks fine and I can drill on city into property, but the drill down form property to details doesn't show any info.
HELP - Am I missing something stupid here ?
Andy
May 24, 2012 at 8:53 am
Sorry added this to 2005 by mistake - it's a 2008 query
May 24, 2012 at 9:20 am
As the OP pointed out, this is a duplicate thread. Please direct all replies here. http://www.sqlservercentral.com/Forums/Topic1305928-1633-1.aspx
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply