locked
Unable to change parameter values in Subreport RRS feed

  • Question

  • Hi

    I have a one parent report and one subreport.Subreport contains parameter values (ex: year )when i am executing subreport alone it is working fine with out any issues i can able to change parameter values and get data based on parameters. But if i am try to access same subreport from Parent report by passing default parameters the sub report produces results based on the parameter i have passed through main report. Once subreport is executed if i want to see the data for previous year  i am unable change parameter selction values.The report is stick with Parent report parameters.

    How can i change parameter selection in subreport? Please suggest me how to resolve


    Regards Rajesh

    Thursday, June 20, 2013 1:06 PM

Answers

All replies

  • Hi Daruvura,

    What do you mean by unable change parameter selction values? Fristly, in your scenario, the report was called drill-through report, not a subreport.

    When add parameter to execute the drill-through report, the parameter tab is hidden by default. Because you add parameters to run report B, so when you click the link in ReportA, then it will use those parameters to run ReportB. We cannot change the parameters value before ReportB was run, so the parameter tab is hidden. This is make sence. We can click the arrow in the top of the report to show the parameter tab and change the parameter value.

    If you have any questions, please feel free to ask.

    Regards,


    Charlie Liao
    TechNet Community Support

    Friday, June 21, 2013 6:48 AM
  • 

    Hi Charlie,

    Many thanks for your reply

    Yes i can see the parameter values in Report B however i am unable to change  parameter values from drop down.

    i have selected 2009 instead of 2008 in Report B parameter screen but parameter screen values are going back to 2008.

    Please advice me.

    


    Regards Rajesh

    Friday, June 21, 2013 8:21 PM
  • 

    Hi Charlie,

    Many thanks for your reply

    Yes i can see the parameter values in Report B however i am unable to change  parameter values from drop down.

    i have selected 2009 instead of 2008 in Report B parameter screen but parameter screen values are going back to 2008.

    Please advice me.

    


    Regards Rajesh

    Rajesh

    You can find a resolution to this problem here: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/b3313046-4f89-435a-a229-6cf40fd6111e/change-parameters-in-the-second-report

    • Proposed as answer by Ian Saunder Friday, July 5, 2013 9:06 AM
    • Marked as answer by daruvura Thursday, July 11, 2013 4:14 PM
    Friday, July 5, 2013 9:06 AM