Hello

My team is currently investigating using Telerik Report Designer, both the web version and the standalone for reports planning.  Right now I'm trying to get the report designer to work with stored procedures and it's not working at all.

First, I cannot get a query to run with an EXEC command, and secondly, the drop down that's supposed to have all the stored procedures on the database won't populate.

The connection string is good, I can make basic select queries work. But I cannot get stored procedures to work.

If I do "EXEC [schema].[storedprocedurename]" as a query, I get "Could Not Find stoed procedure 'schema/storedprocedurename'" though it is a valid stored procedure that I can run in SQL server no problem.  

So I can neither access stored procedures from the drop down, or work around this by writing it in a query.  I have this problem with both the standalone and the web designer.  We're not doing anything weird in our database either, it's a basic SQL Server database with stored procedures stored in the Programmability/Stored Procedures folder.

Am I doing something wrong?  Is there some configuration that needs to be set on my database for the report designer to recognize the stored procedures?

Thank you

Jonathan Kuhl

I have a textbox containing a string built from a datasource value.

How to use the text of this box in a watermark ?

I tried without success things like :

Hi Telerik, 

I am having a problem using a multi-value parameter and i m using Standalone Report Designer. I am using a web service data source (2-step API) to show the table according to the ClientID as a parameter.

My requirement: 
Use the multi-value parameter as a ClientID and show the separate table for each selected ClientID on one page or separate pages.
Suppose: 
There are 1-6 ClientIDs, and each ClientID has different data.

For the ClientID 1 
Name       Address    phone   Email
abc            asddad      2123       asdas@abc.com
sdf            asdad          548        sada@abc.com

For the ClientID 2 

Name       Address    phone   Email
qwwe         qwe          222      qww@qwwq.com
zxxc            zxc            5768        vcv@zxc.com

So, if I select ClientID 1 in the filter, then it should show the table data according to ClientID 1, and when I select 2 ClientIDs, i.e., 1 and 2, 
Then the report should show the two tables just like above. But what I faced was 
I am getting all the data in one table like this:
Name       Address    phone   Email
abc            asddad      2123       asdas@abc.com
sdf            asdad          548        sada@abc.com
qwwe         qwe          222      qww@qwwq.com
zxxc            zxc            5768        vcv@zxc.com

 -- I have used grouping as Fields.ClientId and Multi-value for ClientID 
 -- Placed the table inside GroupHeaderSection 

Also tried another setup, but I am still getting data in one table; I need a separate table for the selected ClietID in on one page/separate page.
And when I try to use JsonDataSource, my requirement works, but in Web Service Data Source it doesn't work. Why?

-- Is there any way to fulfill the requirement?

Hi,

We are using Telerik Reporting Rest service project in our server-side and as a report viewer we use HTML5 report viewer.  There is server project (console app) which run the Telerik Reporting service. We defined CancelKeyPress (Ctrl+C) to close the console app. If we press Ctrl+C it will close successfully. Before closing if we make a request to http://localhost:5000/api/reports/formats using postman or browser then it will  NOT close (See picture Server app after request.PNG). So, it says "Application is shutting down..." and it stays opened.

How to fix this issue?

You can use the attached demo project (ReportingServiceDemo.zip) to reproduce this issue. Startup project should be ServerConsole project which use CSharp.Net5.ReportingRestServiceCorsDemo project.

Thank you.

Hi,

I'm facing the following error message when I try to generate reports in the docx format: "DOCX rendering format is not available"

I've added the Telerik.Reporting.OpenXmlRendering nuget package and added the following section in the appsettings.json file of the application using the library: 

"telerikReporting": {
  "extensions": [
    {
      "name": "DOCX",
      "type": "Telerik.Reporting.OpenXmlRendering.Wordprocessing.WordprocessingReport, Telerik.Reporting.OpenXmlRendering, Version=2.7.2, Culture=neutral, PublicKeyToken=neutral"
    }
  ]

Finally, here's the code used: 

...

renderResult = reportProcessor.RenderReport("DOCX", reportSource, deviceInfo);

What am I missing ?

Thank you for the assistance

I am using Visual Studio 2022 and the standalone Report Designer.  I am receiving the following error on a TRDP file:

An error has occurred while processing HtmlTextBox 'htmlTextBox1'
An error occurred while parsing EntityName. Line 1, position 21.


The formula for htmlTextBox1 is     = Format("Old: {0}<br />New: {1}", Fields.oldValue, Fields.newValue)

This formula has been working for months and still works for most data but we periodically have this happen.  I suspect that the error is happening with data for Fields.oldValue.   Is it possible that a null value could cause this?  What are my options?

Thank you,

As the default CSV export contains unwanted text, I'm trying to have a cleaner CSV export through HTML5 Report Viewer by using CSV device settings. However, the option NoStaticText won't apply to the CSV export correctly. The Textbox and its data under pageHeaderSection still shows in the CSV as columns

https://docs.telerik.com/reporting/knowledge-base/configuring-the-csv-rendering-extension

How do I prevent those Textbox/label and value from the reportHeaderSection from showing in the CSV export?

Thanks.

We are considering usage of Telerik Reporting. But I have some question unclear of me.

What kind of file format does Telerik Reporting use for exporting?

We have planed the next features for our services:

• Design pre-defined report templates
  
• Generate a report from pre-defined report template and SQL like source by an user request
• Export report by the user in XLSX, CSV, DOCX, PDF formats
  

Telerik Reporting (responsible for Feature-complete embedded reporting solution that enables you to create, style, view and export rich, interactive and reusable reports in your web or desktop application. Now with support for: .NET Core, Blazor, ASP.NET MVC, ASP.NET Ajax, Angular, React, WPF, WinForms. ) looks as an optimal option. But, I have found on the pricing page that Telerik Document Processing (responsible for NET libraries for creation and manipulation of most commonly used file formats (XLSX, CSV, DOCX, PDF, HTML, RTF, TXT, ZIP) without relying on third-party software, such as Microsoft Office or Adobe Reader. )

I can't understand from the descriptions which export format used in Telerik Reporting plan?

We have to implement Reporting functionality.
This functionality requires next features from the list/Features:

• design number of reports
  
• generate per-designed reports by user requests with appropriate data
  
• download reports (word, excel, CVS, pdf)
  

We don't need preview, live design or anything like this.
I am looking in the price options:

On the first view it is enough Telerik Reporting (Feature-complete embedded reporting solution that enables you to create and export reports).

But, I have noticed that this plan doesn't include Telerik Document Processing (NET libraries for creation and manipulation of most commonly used file formats (XLSX, CSV, DOCX, PDF, HTML, RTF, TXT, ZIP) without relying on third-party software, such as Microsoft Office or Adobe Reader. ).

I can't find a type of exports for Telerik Reporting  and can't understand - do we need for Telerik Document Processing for our functionality and how to include it?