Avatar of Newie_reporting_services
Newie_reporting_services

asked on 

Create Parameter in Microsoft Visual Studio

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
Microsoft SQL Server 2005

Avatar of undefined
Last Comment
8080_Diver

8/22/2022 - Mon