Post reply

SQL Server Reporting - Automatically passing parameters to a subreport from a status query

  • August 16, 2011 at 5:11 pm

    #255787

    Hi All,

    Can anyone please help me with this issue as I am not able to automatically pass parameters

    to a subreport based on a status query.

    The report only works for the first parameter value.

    My status query is:

    SELECT ClusterID

    FROM CLUSTER

    WHERE (ClusterCheckStatus = 'N')

    Based on this query we have multiple clusters with 'N' status, but the subreport is displaying only the first cluster.

    I am currently running SQL Server 2008 Express edition but plan to deploy the report to SQL Server 2008 Std Edition.

    Cheers,

    JMatts

  • August 22, 2011 at 10:26 am

    #1371545

    In action if u configure ur sub report parameter with ur main report parameter, then it will take the first value, so configure ur sub report parameter with ur main report dataset column, so it will take the real value, try this...

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

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