Im getting the "single-row subquery returns more than one row" error when using a stored procedure  as a datasource.

This is the beginning of the procedure that I am calling from the report:

create or replace PROCEDURE get_idoc_report (
    pStart_Date IN DATE,
    pEnd_Date IN DATE,
    pPrepMethod IN VARCHAR2,
    pAnalyticalMethod IN VARCHAR2,
    pInstru IN VARCHAR2,
    pMatrix IN VARCHAR2,
    pPrepAnalyst IN VARCHAR2,
    pAnalyticalAnalyst IN VARCHAR2,
    pWO IN NUMBER,
    pWO_ID IN VARCHAR2,
    pAR IN VARCHAR2,
    p_cursor OUT SYS_REFCURSOR
)
IS 
BEGIN
    OPEN p_cursor FOR
        select distinct 
            to_char(sysdate, 'MM/DD/YYYY') as Current_Date,
            to_char(pStart_Date, 'MM/DD/YYYY') as WO_Start, ......

I have run the procedure in SQL Developer using a record to get data from the cursor, and it returns the expected number of data rows. I have used the same query as a Text select datasource query in Telerik and it worked. Any idea why I am getting the "single-row subquery returns more than one row" ? I am thinking Telerik Standalone is not able to access the rows returned from the sys_refcursor output. Any help is appreciated. I have attached the procedure text and a screenshot of the datasource setup.

Using Telerik Report Designer Version 17.1.23.606 and Oracle Database 19C.

Hello Together,

i use Blazor Wasm. I created a Reporting with a TextBox

And i put a TextBox in the Blazor Client. My goal is, to put a text in the textbox and the text in the reporting will be change. but how can i do it?

Thanks for your support

This is my client Code:

@page "/druck"

<PageTitle>Report Viewer</PageTitle>

<TelerikTextBox @bind-Value="@Bezeichnung"></TelerikTextBox>

<ReportViewer ServiceType="@ReportViewerServiceType.REST"
              ServiceUrl="/api/Reports"
              @bind-ReportSource="@ReportSource"
              @bind-ScaleMode="@ScaleMode"
              @bind-ViewMode="@ViewMode"
              @bind-ParametersAreaVisible="@ParametersAreaVisible"
              @bind-DocumentMapVisible="@DocumentMapVisible"
              @bind-Scale="@Scale">
</ReportViewer>

@code {
    public ScaleMode ScaleMode { get; set; } = ScaleMode.Specific;
    public ViewMode ViewMode { get; set; } = ViewMode.Interactive;
    public bool ParametersAreaVisible { get; set; }
    public bool DocumentMapVisible { get; set; }
    public double Scale { get; set; } = 1.0;
    public string Bezeichnung { get; set; } = string.Empty;

    public ReportSourceOptions ReportSource { get; set; } = new ReportSourceOptions("Report1.trdp",
        new Dictionary<string, object>
        {
            // Add parameters if applicable
        });
}

Controller Reporting Code:

using System.Net.Mail;
using System.Net;

using LIMeS.Shared;
using LIMeS.Shared.Utils;
using Microsoft.AspNetCore.Authorization;
using Microsoft.AspNetCore.Mvc;

using Telerik.Reporting.Services;
using Telerik.Reporting.Services.AspNetCore;

/// <summary>
/// The LIMeS.Server.Controllers namespace contains all the controllers for the Action Management Server.
/// </summary>
/// 
namespace LIMeS.Server.Controllers
{
    /// <summary>
    /// The main controller for managing action types.
    /// </summary>
    [ApiController]
    [Route("api/[controller]")]
    public class ReportsController : ReportsControllerBase
    {
        public ReportsController(IReportServiceConfiguration reportServiceConfiguration)
            : base(reportServiceConfiguration)
        {
        }

        protected override HttpStatusCode SendMailMessage(MailMessage mailMessage)
        {
            throw new System.NotImplementedException("This method should be implemented in order to send mail messages");
        }
    }
}

We have updated our enterprise SPA application to the latest Angular 20. 

Does Native Angular Report Viewer - Kendo UI for Angular support the latest Angular 20?

I have a table that is grouped by the field CellWCCode. The SQL Query is returning multiple rows (one each for the child item in the BOM), so for example, I might get 5 lines per CellCode. The field StdLabCost returns the one item for each grouped item, but now I want to total the StdLabCost for all of the CellWCCode. I have not figured out how to Sum all of the distinct values.

I attached sample data and the report. 

Hi,

I have a ReportViewer on my XAML page:

<tr:ReportViewer x:Name="LevelAccuracyReportViewer"
                 ReportSource="{Binding LevelAccuracyReportSource}" 
                 Margin="520,360,20,20">
</tr:ReportViewer>

It works ok the first time the page is displayed, but if I update the Source a 2nd time:

LevelAccuracyReportSource = new InstanceReportSource
{
    ReportDocument = levelAccuracyReportDefinition
};

I get an "Object Reference not set to instance error", but then it works.
If I update the source again, I get the error message twice, then it works.

Each update causes an additional message to be displayed

I'm using the 2025 Q2 release of Telerik Reporting

We want to add a ReportParameter that is visible to the user (We know how to make them visible, we do that with boolean type parameters so the users can hide or show items on reports), that is INTEGER based that will control the number of records are showing in a "LIST" control on our report.   For example, we have a detailed Report with USER information; then in the report, we have a list that displays the USER's access over time. This could be one record or as many as a thousand records.  We would like is this parameter to control the number of records shown in that list control.

Now, I have been able to create the INTEGER Report Parameter and make it visible; however, what I have not figured out is the following:

1. How do you make the control for the parameter a spin editor, if possible?
2. How do you limit the parameter's value (Low/High)?
3. How do you apply that parameter's value to the number of records displayed in the "LIST" control?

TIA

Hi team, what is the way to use the reporting feature in my net core mvc application using jetbrains ride?

Regards.

Hello Telerik Team,

We are currently working with Telerik Report Server and leveraging shared data sources that use SQL parameters (e.g., @StartDate, @CustomerID) mapped from report parameters.

While the shared data source model is helpful for reusability, we are facing the following challenges and have some enhancement inquiries:

❗Current Issue: Parameter Name Coupling

When reusing a shared data source in multiple reports:

• The SQL parameters (e.g., @CustomerID) require exactly matching report parameter names in every report.

• This limits flexibility — as we cannot remap SQL params like @CustomerID to a differently named report parameter like CustomerFilter within the report context.

🔍 Our Use Case & Requirements

We would like to explore one or more of the following options:

✅ Option 1: Manual Mapping Support Per Report

Allow a report designer to map differently named report parameters to the SQL parameters of a shared data source without requiring parameter renaming across all reports.

✅ Option 2: Override Shared Data Source in Report Context

Enable overriding SQL parameter bindings for shared data sources within a report, without modifying the shared data source globally.

This would be similar to inline data sources — but using shared DS assets with local overrides or duplicating it.

✅ Option 3: Make Shared Resources Read-Only

We would like to allow usage of shared data sources across teams without allowing edits:

• Is it possible to make shared resources (like data sources and reports) usable but not editable by most users?

• Ideally, only admins or asset managers should be able to modify shared resources, while consumers can use them as-is (e.g., bind, preview, clone).