How can I get the value of my textbox in reporting services to include a sum expression?
Posted on 2009-04-03
I have the following in one of my text boxes on my value:
= "Total Number of Incidents in Service Alliance queue: "&" "&Sum(Fields!TotalIncidents.Value, "IncidentsInSAQueue")
IncidentsInSAQueue is the name of my dataset:
select count(sequence) from _SMDBA_._TELMASTE_
where [date open] > '01-oct-08'
and _SMDBA_._TELMASTE_.subject = 1381
and _group_ in (1011, 1004)
and status = 'O'
When I try to run I get this error:
C:\Reports\Astea\Astea\Service_Alliance_Incident_Report.rdl A value expression used for the report parameter '=count(sequence)' includes an aggregate function. Aggregate functions cannot be used in report parameter expressions.
Can someone please show me how this should be entered into the textbox?