Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Parameter for one cell Expand / Collapse
Author
Message
Posted Thursday, May 1, 2014 8:59 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 28, 2014 10:54 AM
Points: 26, Visits: 57
I have created a drilldown report. Is there a way to create a parameter based on an indicator value for one particular cell? The value in this cell is also a value in other cells but this particular cell is for a particular group and I want to be able to filter through this group by what their indicator value is in that cell. Please let me know if this can be done and how. Thanks
Post #1566740
Posted Thursday, May 1, 2014 9:03 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Sunday, October 12, 2014 4:00 PM
Points: 341, Visits: 751
Wow! That's confusing. Can you post some sample data and expected results?
Post #1566744
Posted Thursday, May 1, 2014 9:17 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 28, 2014 10:54 AM
Points: 26, Visits: 57
There are three levels to this drilldown report. Level 1 will open up to several groups in level 2. Each group in Level 2 will open up to individual items. These individual items have indicators for yes/no/null. Level 2 has indicators on these groups based on which indicator of each group was the most important. For example, if a group has an x indicator on one of its items, then a x will appear for that group. Level one is the same. If an x appears on any of its groups, then there will be an x at the level. The report is just breaking it down further and further. I want to filter only the indicators at level 1, but since the indicators at every level use the same value, I'm not sure if it is possible to filter it out this way.
Post #1566750
Posted Thursday, May 1, 2014 11:40 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 28, 2014 10:54 AM
Points: 26, Visits: 57
I just realized I need to use the indicator value at third Level as my parameter. My indicator has a very long IIF expression to determine the value. How can I use this to make the parameter?
Post #1566809
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse