I want to create a parameter based off of DSol_FullName. Each time I select the data in this field I want the data in the matrix to change.
In this Matrix I have Prospect Status going across and then Rating Description going down and then a simple count of Constituent ID in the middle.
I want the count to change according to the parameter field I choose.
Thanks Kelly
SELECT DCons_ProspectStatus, DConRtng_RatingDescription, COUNT(DSol_ConstituentID) AS Expr1, DSol_ConstituentID, DSol_FullName
FROM DR_SolicitorRelations
GROUP BY DCons_ProspectStatus, DConRtng_RatingDescription, DSol_ConstituentID,
Open in new window
PMR1020-march-13.pdf