Identity Manager

How to read a parameter value in Sub reports

Hi,

I have a custom report. It will get user input From and Todate to generate the report with in that dates. I used a parameters to get the date.

In the summery Page, i can able to refer the Parameter ( DateFrom and DateTo). If i refer the parameter variable in the sub reports ( Pending Attestation , Completed Attestation) , it return the default date value. It does not get the data entered by the user when generating the report. lt looks like the it is not the global value which can be used in sub reports.

I want to show the From and To data user entered in the Parameter when generating the Report in Sub Reports.

How can i achieve this. Can some one help me on this?

  • I tried to access the parameters in the SubReport using the standard notation {DateFrom} or {DateTo} and it worked in my tests.

    The parameters should appear in the report dictionary in the variables section.

    You may need to describe your problem in more detail if this is still not working in your environment. It is always good to know the version you are using for example.

    HtH
  • Hi Markus,

    I used same notation also but it return the default value which we provided in the parameter sections. if i remove the default date, i get database default date. The version I am using is Q1IM 6.1.3. Pease find the screenshot.

     

    Report - Parameters

     

    Summery Report shows correct date entered by user.

     

    Sub Report with default date. Not the actual date entered by user.

  • I've built a sample in 6.1.3 and it's working as it should be.

    I've attached my sample report as transport so that you can compare what I might have done differently.

    I've tested the parameter query function using a subscribable report based on the sample report I've created.

    Hth

    6165.Transport_MSSQL_Sample Report für Parameters in Sub Reports.zip

  • Hi Markus,

    I have tested your report. In the parameter i found difference, your are using query. I am using fix. i changed that to query. But still not working.

    My report opens the new page when user click "Pending attestation" in the summery page. Your report shows sub report in the same page.

  • In your sample, the select value for the parameter DateFrom is displayed on the sub report.

    Just the parameter DateTo is displaying the default value because you haven't specified a value. Again the parameter is displayed the same on the main and the sub report what is different to your original problem description.

    Next question would be, how you open the report. I assume you create a custom form to do that. It would be helpful if you post the configuration XML for that report form.