December 14, 2010 at 12:28 pm
I have a report that I modified by adding two fields to the output of a stored procedure. The stored procedure runs fine and I can view the two new fields in the dataset. However, when I preovew the report I get the errors that are shown in the attached file. I don't relly know what is wrong or where to begin to look for the problem.
Any ideas would be appreciated.
Thanks.
Ralph
December 14, 2010 at 12:32 pm
It looks to me like you have a grouping/scope issue. You probably have groups on your report, and you are trying to put a detail field, rather than a sum or other aggregate, into the group rather than into the detail
December 14, 2010 at 12:44 pm
That sounds about right. The two fields I added were into a group header, but they were details. Should I use some other value in the expression, like first(data.FieldName)?
December 14, 2010 at 1:15 pm
First ought to work, but it will only return the first value in the data set for each group, so you may not like the results.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply