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.

How can I get the row count from a table that is in the detail, but show that total in a textbox in the footer?

The datasource on the table in the detail doesn't seem to be accessible from anywhere but the table. 

The datasource on the report itself is different, containing some common items for display, but no data.

I've seen solutions that talk about adding a list or table to the header, but that doesn't seem to be allowed. The report designer does not allow that.  "It is not allowed to add Table to pageHeaderSection1" 

Is there a solution for this? Some way to make a report function that can be called from an expression? Or something like a field in the detail that is identified such that its value can be accessed in the footer?

Thanks

HI All,

We have 2 web servers , 2 app  in our prod environment. Suddenly after server reboot activity, on one of the server we are facing issue "Error registering the viewer with service". When request hit to one of the server then only user see error. We are using File Storage for the implementation. I suspect some settings or configurations might have changed in one server. What all things can we check for this ? Trace log show below error in affected server:
"Make sure you are using CacheStorage inside single-instance application deployment only."

I am Using telerik.reporting.cache.stackexchangeredis.2 15.0.21.224 to implement redisStorage. But it is not digitally signed. How can i get the digitally signed version of this package

How do I remove the expanders on this chart that I've circled?