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?
In reply to Markus Weiss-Ehlers:
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.
In reply to Enayathulla Sadhakathulla:
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.
6165.Transport_MSSQL_Sample Report für Parameters in Sub Reports.zip
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.
Date in Overview Page is reflecting the date provided in the From text.
Once i click Approved in the overview page. Another Page opens with All the approved users. Date is not correct.
I have attached mrt file for your reference.ADP_Attestation_New.txt
Thanks for the MRT file. But what I still need is the answer to the question about 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. I still think that the reason for that behavior is related to the way you open the report.
I looked at the report definition file you send me and you used drill-down of the report engine to open the sub-report defined on different pages in the same report using event code.
For drill-downs the report engine allows you to define additional drill-down parameters. You have to give them a name and define an expression.
In you case create parameters for datefrom and dateuntil and set the expression to the value of the dictionary variables DateFrom and DateUntil.
Your event code for defining the parameters should similar to the following (new lines highlighted, just one sample use case):
You can reference the DrillDownParameters in the sub-report using this["<Name>"]. In my sample this would be this["DateFromSub"].
Assuming I am understanding the samples found using Google correctly, you should be able to access the DrillDownParameters by something like the following: