Groups | Blog | Home
all groups > sql server reporting services > august 2007 >

sql server reporting services : Summarize First Values



Mark
8/21/2007 8:52:01 AM
I am trying make a sum(first(Field.Value)) but reporting services generated
the following error "Aggregate functions cannot be nested inside other
EMartinez
8/21/2007 7:17:32 PM
[quoted text, click to view]


You may want to handle this in the dataset (stored procedure/query)
that is sourcing the report. You will have a little more flexibility
there. Another alternative is to achieve the 'first' part in the
stored procedure/query that is sourcing the report and then handle the
summing as normal in the report. Sorry that I could not be of greater
assistance.

Regards,

Enrique Martinez
Sr. Software Consultant
AddThis Social Bookmark Button