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

Goodmorning i have a site developed in .NET 5 that renderize some .trdp report, i compile that report using a stored procedure in my database, actually i pass it my connectionstringstring using the file appsetting.json of my website, but i need to dinamically pass the connectionstring to my SQL DataSource item in my report (maybe using a report parameter?), how can i do that?

i leave you some screen for better explanation.

This is the SQLDataSoruce of my report

this is the appsetting.json file of my website

this is how i pass parameters from a webPage to the report

let me nknow if i was clear or if it possible do what i ask.

Best regards

I don't understand the issue please guide some one here is pdf link please check it

https://drive.google.com/file/d/1XHSSO4x8yQop2z2V8tpzoJl02zK-LMd6/view?usp=sharing

I have names. I want to set unique name as:  (name + ', ' + name + ', ' + ....) for text box value. This sql query work in my machine, but not work in telerik report designer, error message: 

The variable name '@myParameter' has already been declared. Variable names must be unique within a query batch or stored procedure.

DECLARE @myParameter VARCHAR(max)

SELECT @myParameter = COALESCE(@myParameter + ',', '') + g.[Name]
FROM [dbo].[NotificationEX] AS n
LEFT JOIN [dbo].[NotificationEXPurchaseMetods] AS m ON m.[ID] = n.[PurchaseMetod]
LEFT JOIN [dbo].[NotificationEXPurchaseMetodGroup] AS g ON g.[ID] = m.[Group]
WHERE [Placer] = 76875 AND [Status] IN (4, 14) AND [PublishedDate] >= GETDATE() - 365
GROUP BY g.[Name]

SELECT @myParameter 

This not help for my script: https://docs.telerik.com/reporting/knowledge-base/how-to-use-local-variables-in-a-sql-query-used-by-the-sqldatasource-component

Hi,

Web Service Data Source has parameters as you can see from the picture below. We can define design-time value for the parameters. The design-time values help us during designing our report (for example, we can see selected properties from standalone & web report designer). In our case, we also need to modify some report programmatically, we need to create new web service data source or update existed one. 

  The question is how to set design-time value for a parameter of web service data source programmatically? 

Hi,

We have upgraded our Telerik reporting version to 15.1.21.616 and we are using the Upgrade Wizard to update all the telerik assemblies in the project. When we called /api/reports/formats, below error occurs:

"ExceptionMessage": "Multiple actions were found that match the request:  Formats on type WebApi.Controllers.ReportsController GetClientsSessionTimeoutSeconds on type WebApi.Controllers.ReportsController", "ExceptionType": "System.InvalidOperationException",
"StackTrace": "   at System.Web.Http.Controllers.ApiControllerActionSelector.ActionSelectorCacheItem.SelectAction(HttpControllerContext controllerContext)\r\n   at System.Web.Http.Controllers.ApiControllerActionSelector.SelectAction(HttpControllerContext controllerContext)\r\n   at System.Web.Http.ApiController.ExecuteAsync(HttpControllerContext controllerContext, CancellationToken cancellationToken)\r\n   at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__15.MoveNext()"

Once we downgrade back to 15.0.21.224, the error gone.

Please help. Thank you.