I have a datasource that returns data similar to:

MemberId,
MemberName,
PurchaseItem,
PurchaseDate,
PurchaseAmount

Naturally, the MemberId is going to be repeated in the results, once for every purchase.  That's expected because I'm grouping by MemberId in the report.

But when setting up the query using the Configure SQL DataSource wizard, if I execute the query on the "Preview Data Source Results" step of the wizard I get the error "Column MemberId is constrained to be unique. Value '25' is already present'".

Why is this even being checked?  There's nothing wrong with a value appearing on more than one row. I'm not inserting to the actual table where the constraint would certainly apply. I'm just selecting data.

Is there a setting I'm missing?  If I just ignore the error and don't show any preview, the report itself works fine. It seems to be a bug in the preview.

I'm using MySql as the database.

Hi,

Is there a way to determine the subreport name where the pageheader is being renedered?

I need to make items (textboxes) on the pageheader invisible depending on the subreport it is being rendered on.  Is this possible?

Please contact me at mrogers@saberindustries.com

Thank you for your help

Mark Rogers

Is it possible to control the sorting direction of the table via report parameter?

I want to pass Asc or Desc value as Report Parameter and sort the table rows.

Please advice.

Thanks

BV

Hi,

How can I pass Column names via Report Parameters to Filter the records in a table?

The report has 5 columns. I need to filter the table based on a Column. This column needs to be passed to the report dynamically from a screen.

I can pass the filter value via the Report parameter and successfully filter a Column. But my requirement is the Column (Field) that will be used is not known prior and needs to be passed into the report via Report Parameter. The column names are dynamic.

I am using Expression in Filters, but am not able to make this happen.

Please advice.

Thanks,
Balaji. V

Hi,

We use web report designer to modify some reports. Mainly we use Standalone report designer to create report.

In our case, we don't need Menu>New menu. Is it possible to somehow disable or hide New menu?

Thank you,  

We're building an Azure Web App using an Azure SQL Server database.  It will incorporate Telerik Reporting.  We have no plans to use Report Server at this time.  The target framework is .NET Core 3.1.

Currently, we're building reports using the standalone desktop report designer, with SQL data source connections.  The intention is to integrate these as another project in the solution at a later date.

Is this the best way to proceed?    Are we better off using the EntityDataSource component? 

More to the point, what are the architectural decision criteria and best practice patters for this kind of development?  Where might I find them documented?

For example, we could set up a data access layer as a separate project in the solution, and then it could be built as an external assembly to make it available for designing reports.  This would have the great benefit of decoupling the database from the solution and providing a single common interface to the data for all projects (and indeed, any future other solutions).

But it is clearly more work.  What are the criteria to choose the approach to use?

Should we even be using the standalone report designer?  Should we be using the Visual Studio Report Designer instead?  I do understand that we currently can't use this, but I also understand that .NET Core 3.1 support is coming real soon now.  (Roughly when, please?)

When should we use the HTML5 Report Viewer and when should we use the HTML5 ASP.NET MVC Report Viewer?  What are the advantages and disadvantages of both?

Again, what is the best pattern, the recommended approach?  And using what criteria?

I realise I'm asking a set of very open-ended architectural questions; I'm hoping that you might provide some general guidance here as it would certainly be extremely useful for us right now, and quite likely for a lot of other folk in the future.

Best wishes, Donna Kelly

Hi, in my Angular 13 Projet I add the ReportViewer. Work well with the "online" Telerik REST service like with the CLI provided demo.

But on my .Net Core Rest service I got a 404 not found on :

https://localhost:44379/reports/clients/e99adeb6a60/parameters

If I use the clientId received by the viewer and try the same POST in Postman, I got no error and the response got Parameters [] (I test with Barcodes report that do not have anay parameters.

Why the viewer got a 404 Not found in the network tab?

In the viewer the error is:

Unable to get report parameters.
Report 'Barcodes%20Report.trbp' cannot be resolved.

EDIT:

Testing directly in the CLI Telerik Demo and I got the same error. Using the Telerik Demo and online REST Telerik service:

<tr-viewer #viewer1 
    [containerStyle]="viewerContainerStyle"
    [serviceUrl]="'https://demos.telerik.com/reporting/api/reports/'"
    [reportSource]="{
        report: 'Barcodes Report.trbp',
        parameters: {}
    }"
    [viewMode]="'INTERACTIVE'"
    [scaleMode]="'SPECIFIC'"
    [scale]="1.0"
    [ready]="ready"
    [viewerToolTipOpening]="viewerToolTipOpening"
    [enableAccessibility]="false">
</tr-viewer>

Error loading the report viewer's templates. (templateUrl = 'domain-name/api/reports/resources/templates/telerikReportViewerTemplate-15.2.21.915.html/').

Facing this issue , application is in angular and .net 

Hi

I have an old license 2017 telerik reporting can i use it with Blazor ?

Regards

I have attached the screenshot of the code and error after upgrading to the new report version "Reporting_R3_2021_SP1_15_2_21_1110"

I am not sure if there is a new syntax that need to be changed with .Net6.0 and the new version of Telerik report?

Thanks