nulad
asked on
SSRS 2008 Multi-Value Parameters
I am trying to create a SSRS 2008 report with multi-value parameters.
• One multi-value parameter is “PROJECT” (drop down list sourced from a query). This parameter is for the user to view people who have participated in one or more of the selected projects (i.e. project A, B, and C).
• Another multi-value parameter is “PROJECT_NOT” (drop down list sourced from the same query). This parameter is for the user to view people who have participated in the above stated project(s) (i.e. A, B, and C), but have not participated in one or more of the selected “PROJECT_NOT” project(s) (i.e. D or F).
(GPD.PROJECT_ID IN (@PROJECT))
AND (PPL.PERSON_ID NOT IN (SELECT GPD001.PERSON_ID
FROM GPDDETAIL GPD001
WHERE GPD001.PERSON_ID = PPL.PERSON_ID
AND GPD001.PROJECT_ID IN (@PROJECT_NOT)))
My question is how to make this one report work both ways:
• The user wants to view people who have participated in project A, B, and C, but have not participated in project D or F.
OR
• The user only wants to view people who have participated in project A, B, and C, but is not concerned with any projects they have not participated in.
• One multi-value parameter is “PROJECT” (drop down list sourced from a query). This parameter is for the user to view people who have participated in one or more of the selected projects (i.e. project A, B, and C).
• Another multi-value parameter is “PROJECT_NOT” (drop down list sourced from the same query). This parameter is for the user to view people who have participated in the above stated project(s) (i.e. A, B, and C), but have not participated in one or more of the selected “PROJECT_NOT” project(s) (i.e. D or F).
(GPD.PROJECT_ID IN (@PROJECT))
AND (PPL.PERSON_ID NOT IN (SELECT GPD001.PERSON_ID
FROM GPDDETAIL GPD001
WHERE GPD001.PERSON_ID = PPL.PERSON_ID
AND GPD001.PROJECT_ID IN (@PROJECT_NOT)))
My question is how to make this one report work both ways:
• The user wants to view people who have participated in project A, B, and C, but have not participated in project D or F.
OR
• The user only wants to view people who have participated in project A, B, and C, but is not concerned with any projects they have not participated in.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Example: like if the parameters for the second parmeter are null coming back from the report then, just give me the info on the first pamameter to show the the dataset for the report.