Post reply

How to get value from dataset files to subreport

  • May 14, 2012 at 9:48 am

    #392254

    hi

    i have 1 subreport ,which has parameter getting value from main report filed.

    i m having expression error.

    in main report->subreport propertirs-> i am passing like this

    @param1 =(Fields!ID.Value, "Performance")

    i am removing sum((Fields!ID.Value, "Performance") to =(Fields!ID.Value, "Performance")

    getting error like ')' excepted.

  • May 15, 2012 at 5:15 am

    #1487610

    riya_dave (5/14/2012)

    hi

    i have 1 subreport ,which has parameter getting value from main report filed.

    i m having expression error.

    in main report->subreport propertirs-> i am passing like this

    @param1 =(Fields!ID.Value, "Performance")

    i am removing sum((Fields!ID.Value, "Performance") to =(Fields!ID.Value, "Performance")

    getting error like ')' excepted.

    Please look at the formula you have left after the SUM has been removed.

    =(Fields!ID.Value, "Performance")

    What do you think this is supposed to mean? If you have multiple rows from the result set then Fields!ID.value would return multiple values. This is obviously not right, so an aggregations function should be used such as sum, avg, min, max etc.

    If the Fields!ID.value returns a single row then

    =Fields!ID.Value

    Fitz

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

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