Show report by passing dynamic parameter

[Jayesh]

Hi All,

I am trying to Show Detail of a multiple Orders by, passing their order number . I have to manually select the  order number to display their details(which is coming from by passing ordernumber in store procedure).

I want to pass parameter dynamically in report parameter.

Please suggest!


Thanks in advance
Jayesh

[Dimitar]

Hello Jayesh and Tursunkhuja,

Based on the description, I think that the Invoice Report Demo | Telerik Reporting fits your requirements(although, this example shows only 1 selected order). The report from this demo is also shipped with the installation of the product and can be found at the following path:

C:\Program Files (x86)\Progress\Telerik Reporting <Release>\Report Designer\Examples

You may use this report as a reference when creating your or you may try the help of the Invoice Report Wizard at a Glance - Telerik Reporting.

Once the report is created, you may pass a value to the report from the Blazor application through the Blazor Report Viewer's ReportSource property, for example:

<button onclick="@RefreshViewer">Refresh with new parameter value</button>

<ReportViewer ServiceUrl="/api/reports"
    @ref=rv1
    @bind-ReportSource="@ReportSource"
    @bind-ScaleMode="@ScaleMode"
    @bind-ViewMode="@ViewMode"
    @bind-ParametersAreaVisible="@ParametersAreaVisible"
    @bind-DocumentMapVisible="@DocumentMapVisible"
    @bind-Scale="@Scale"
    PageMode="@PageMode.ContinuousScroll"
    EnableSendEmail="true"
    ServiceType="@ReportViewerServiceType.REST"
    Height="800px"
    Width="100%">
</ReportViewer>

@code {
    ...
    public ReportSourceOptions ReportSource { get; set; } = new ReportSourceOptions(
        "Report1.trdp", 
        new Dictionary<string, object>
    {});

    void RefreshViewer()
    {
        ReportSource = new ReportSourceOptions() {  Report = ReportSource.Report, Parameters = new Dictionary<string, object>() { { "parameter", "value" } } };
    }

Hope this helps, please let me know if you have further questions.

Regards,
Dimitar
Progress Telerik

[Tursunkhuja]

Hi Jayesh,

Do you have sample report?

 

Thanks,