Post reply

Error message in reporting services

  • January 3, 2008 at 8:26 am

    #185246

    i get this error in the preview mode

    "Report item can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope"

    When i try to do a PREVIEW ... but the store procedure works in the Data view and in SQL Query Analyser , so i know it got to do somthing in the LAYOUT and PREVIEW.

    Please help me, i tried to look up the error but was of no help.

    Thanks in advance.

    SR

  • January 3, 2008 at 11:53 am

    #764511

    Its Ok .. i found the soultion .. i had Alias in the stored procedure and i had not pointed them to the right place. For ex:

    Select Fname AS (First Name),Lname AS (Last Name) From Person

    I was pointing to Fname in the Table in the LAYOUT (design mode) Instead of FirstName.

    Name the Textbox in the table in design mode the same as the alias ie

    =Fields!FirstName.Value - this works

    Thank you

    SR

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply