#Activereports parameterized json query generator
#Activereports parameterized json query code

In the New ASP.NET Project dialog, select Empty template and click OK.

In the New Project dialog that appears, select ASP.NET Web Application and in the Name field, rename the file as WebService.From the File menu, go to Add, and then select New Project.The web service added to the project authenticates access to the JSON data. Var rptPath = new definition = new (rptPath) ĭ += OnLocateDataSource Private void Form1_Load(object sender, EventArgs e) Var dataSourceName = args.DataSourceName Private void OnLocateDataSource(object sender, args) The handler of that returns appropriate data for a report.

#Activereports parameterized json query code

In Form1.cs, paste the following code after InitializeComponent method to load data in the report and display the report in the viewer.Double-click the title bar of the Form1 to create an event-handling method for the Form1_Load event.Set the viewer's Dock property to Fill to show the complete Viewer control on the Form1 and set the viewer's Name property to reportPreview.From the Visual Studio toolbox, drag the Viewer control onto the Form1.This automatically adds static label in the table header row. Hover over TextBox7 to reveal the field selection adorner, click it to display a list of available fields, and select the Address field.Hover over TextBo圆 to reveal the field selection adorner, click it to display a list of available fields, and select the ContactName field.This automatically adds a static label in the table header row. Hover over TextBox5 to reveal the field selection adorner, click it to display a list of available fields, and select the CompanyName field.Right-click any row handle to the left of the table and click Table Footer to remove the table footer row.From the Report Explorer, drag the Table data region onto the design area and go to the Properties window to set the properties as follows.From the Report Explorer, drag the Id field onto the design surface of the report and go to the Properties window to set the properties as follows.Your dataset and queried fields appear as nodes in the Report Explorer. On the Query page, click Edit with JSON Query Designer button and choose the JSONPath upto to obtain the following query in the Query text box: $.Customers.In the DataSet Dialog that appears, select the General page and enter the name of the dataset as Customers.In the Report Explorer, right-click the data source node and select the Add Data Set option or select Data Set from the Add button.Click OK to save the data source connection.

#Activereports parameterized json query generator

Note: The schema shown above has been generated for customers.json data, using the JSON schema generator available at.