ACTIVEREPORTS PARAMETERIZED JSON QUERY CODE
See sample code in the Add Parameters topic. In this case, the report's ShowParameterUI property must be set to False.
ACTIVEREPORTS PARAMETERIZED JSON QUERY WINDOWS
To collect parameter values from a Windows form or a Web form, use code to collect the values into variables, and then pass them into the report's ReportStart event. The subreport's SQL query must contain the parameter syntax with the Name value set to the name of the field that is common to both reports.The subreport's ShowParameterUI property must be set to False.The SQL queries for both reports must contain the same field.In order to collect parameters from a main report to pass into a subreport, all of the following must be in place: However, if the report object's ShowParameterUI property is set to False, the user prompt does not display for any parameters regardless of its PromptUser setting. Tip: Within the same report, you can prompt users for some parameters and not for others by setting the PromptUser property to True on some and False on others. In this case, the parameter with the "param:" prefix in the SQL query is updated with values of the corresponding parameter in the Report Explorer. For example, "select * from customers where customername = ''".
Specifying the "param:" prefix for a parameter in the SQL query relates this parameter to the one in the Report Explorer. Values of a parameter added to the Report Explorer can be applied to a parameter in the SQL query - you should just specify the "param:" prefix for a parameter in the SQL query. When the user enters the requested values and clicks the OK button, the report displays using the specified values. When there are parameters in the collection and the ShowParameterUI property is True, the user prompt automatically displays when the report is run.
On the report object, the ShowParameterUI property must be set to True.The PromptUser property for at least one parameter is set to True.At least one parameter exists in the Parameters collection of the report.In order to prompt the user for parameter values, all of the following must be in place: You can add parameters to the code behind the report, in the ReportStart event.You can add parameters to the Report Explorer.You can enter syntax like the following into your SQL query:.There are also several ways in which you can set up parameters for a report: You can collect parameter values from a control in a Web form or a Windows form.You can get parameter values from the main report and pass them into a subreport.You can prompt the user for parameter values.There are several ways in which you can collect values for parameters: You can use the ActiveReports Parameters collection to pass values directly into a textbox or a chart on a report, or to choose what subset of data from your data source to display in a particular instance of a report, or to pass values from a main report into a subreport.
0 kommentar(er)
