Using parameters with reporting

2 Answers 164 Views
Report Parameters
Eric
Top achievements
Rank 1
Iron
Iron
Iron
Eric asked on 01 Jun 2022, 09:22 AM | edited on 01 Jun 2022, 09:22 AM

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

 

2 Answers, 1 is accepted

Sort by
0
Todor
Telerik team
answered on 06 Jun 2022, 07:27 AM

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:

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

Fetching the data from a SQL database:

Blazor Report Viewer:

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

Regards,
Todor
Progress Telerik

Brand new Telerik Reporting course in Virtual Classroom - the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products. Check it out at https://learn.telerik.com/.
0
Eric
Top achievements
Rank 1
Iron
Iron
Iron
answered on 07 Jun 2022, 06:39 AM

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
Telerik team
commented on 07 Jun 2022, 03:33 PM

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.

Tags
Report Parameters
Asked by
Eric
Top achievements
Rank 1
Iron
Iron
Iron
Answers by
Todor
Telerik team
Eric
Top achievements
Rank 1
Iron
Iron
Iron
Share this question
or