Using parameters with reporting

[Eric]

Hi

I'm new to Telerik reporting so may have some silly questions :-)

What do i want?

In a Blazor application a Wizard runs for selecting and filling in Parameters for a specific report.

These parameters are send to the restserver as Json.

These parameters influence the dataset behind the report, so the "WHERE" clause of the sql.

Then i need to show the report with the updated sql

Should not be any problem i think

I also wants to show some of the parameters  on the report like the selected start/end dates from the wizard. 

is that possible without haveing these as fields of the sql output?

Thanks for answering

 

[Todor]

Hi Eric,

If I understood correctly, you would like to pass values for your SQL queries from the Blazor Report Viewer. I confirm this is possible out of the box. Here are the links you may find useful to achieve the purpose:

Related to the Report Parameters:

• Report Parameters Overview
• How to Add Report Parameters

Note that you may use the Report Parameter values all over the report, in any Expression.

Fetching the data from a SQL database:

• SqlDataSource Component Overview
• Using Parameters with the SqlDataSource component

Blazor Report Viewer:

• How to Use Blazor Report Viewer
• How to Create a Custom Parameter Editor

The last link relates to passing values selected in custom editors that are outside the report viewer to the latter.

Regards,
Todor
Progress Telerik

[Eric]

Hi

 

>>If I understood correctly, you would like to pass values for your SQL queries from the Blazor Report Viewer. 

No , not FROM the Blazor Report Viewer, the viewer will not show any report params

We have our own wizard we use to let the user define the parameters

Eric

[Todor]

Hello Eric,

You may test the approach from the KB article Dynamically Selecting and Filtering Reports in Blazor Projects. Briefly, you need to select the values and set them to the reportSource of the viewer with code.

You may find useful also the blog post Dynamically Selecting and Filtering Reports with Blazor and the Telerik ReportViewer Control.