sql server reporting services: hi all,
iam working in sql reporting services having 1 stored proc.I hav 3 different tables and in the 4th table ,i want to add sum of two tables and subtract the value of 3 from sum of 2. i treid in this way...
""""first(fields!Previous_Commitment.Value, "table1")+ " " + first (fields!Commitment.Value,"table2") - " " -first(fields!Commitment.Value,"table3") """"

but getting errors ...

"""InvalidAggregateScope] The Value expression for the textbox ‘textbox32’ has a scope parameter that is not valid for an aggregate function.
The datasource is only one for report.Iam not getting wht is the problem..
Please If any Could help me.. Really apprecieates...Thanks.


From http://www.developmentnow.com/g/115_2006_5_0_0_0/sql-server-reporting-services.htm

Posted via DevelopmentNow.com Groups