Telerik Forums
Reporting Forum
1 answer
96 views

In SSRS, I can give names to my expressions to help developers find what they're looking for. Instead of showing "Expr=blahblah," I can change the label to something like "GrandTotal" while working on the design.

I'm wondering if there's a similar option in the Telerik Visual Studio designer. We're thinking of moving 70 reports to Telerik, but if the design view only displays the expression and sometimes only partial context, like "[=Count(" for example, it could cause a big problem for development.

Thank you,
Evan

Dimitar
Telerik team
 answered on 20 Jun 2023
1 answer
162 views

Hi,
 I am working on a ASP.NET Core (.NET 6) web application with the main report UI using the HTML 5 viewer, working from the REST service controller.

We also require automated report exporting to run at scheduled times with predefined parameters (to be stored and emailed). SQL datasource(s) and engine settings will be the same as used in the reports controller.

Please can you advise on the best approach to process and output export files from the server-side application code.

It looks like I need to use the ReportProcessor class, but not sure how to make use of "engine" config...

 

Further application detail and problem encountered:

I have implemented the EF Core based report storage example and have a custom function assembly, used in most reports.

The IReportSourceResolver is provided along with the engine configuration - connections strings and custom function assembly reference - in a ReportServiceConfiguration instance for the ReportsController.


I believe that ReportProcessor does not somehow obtain the IReportServiceConfiguration the REST controller has injected.

There is no issue running code in a background job (eg. Quartz.NET):

  • loading a report instance with the IReportSourceResolver implementation
  • using code based on this example to set SQL datasource connection strings
  • using ReportProcessor.RenderReport().

This has worked fine for a little while, but the ReportProcessor seems to no longer find and load the custom assembly - though I'm sure it is output to the build location (and has had no recent changes).

Thanks.



1 answer
430 views

We have  reports designed in Telerik web report designer . Report will be displayed in HTML5 report viewer.  Report can be exported to excel. Issue is, while exporting, some cells in the excel are getting merged automatically.

Is there any way to prevent this?

Following is a sample report exported as excel from viewer. It has a header section and data populated in the detail section using table wizard. But in excel the marked cells seems like merged. Each table column need to fit in one column. Anything to do while designing reports?

Nikolay
Telerik team
 answered on 19 Jun 2023
1 answer
272 views

Hi,

I use the telerik reporting for our GIS platform.

I define two items:

  • on my GIS textarea(regular text) and editor(save HTML code) -  see in_editor.png file
  • on Telerik report designer I insert HTML text box and Texty box, culture=he   -  see in_Telerik Report Designer.png file

You can see results in result.png file.

I suggest culture=he does not work for HTML text box.

By the way, I see in the fields where I saved values I look

  • textarea  - "אאאאאאאאאאאאאא 100 בבבבבבבבבבבבב"
  • HTML  - "<p style="text-align:right;">אאאאאאאאאאאאאא 100 בבבבבבבבבבבבב</p>"

Pay attention, in HTML text box blanks disappeared.

Without numbers HTML text box works fine !!! See result_ok.png

I hope somebody helps me?

Thanks

Yuri

 

 

 

Dimitar
Telerik team
 answered on 16 Jun 2023
1 answer
171 views

I'm pretty new to Telerik Report Designer, and I could use some help. Let me also preface this by saying, I'm looking for a solution that doesn't require code, and only uses the tools available in Telerik itself (if such a solution even exists).

I'm working on a report to calculate the number of vacant beds in living spaces. To do so, I'm getting the difference between the total number of beds and the number of residents.

The problem is, the data for getting the number of beds and the data for getting the number of residents are in two different Data Sources... so, I can't use an expression to calculate the difference, as I can only use the Data Source that's bound to the report for expressions. I have been able to use tables to display both values, but the fact remains, I can't calculate the difference between them.

I know I can set one of the values as an invisible parameter, but the problem with that is, that value becomes fixed, and is the same for every living space in the report, when I need it to be different for each one.

Does anyone know of a solution to this? Again, one that doesn't require code.

Thanks in advance.

2 answers
832 views

i have website built with telerik tools when i deploy it in azure service it work fine , but when i built my own server with windows server 2019 all website work well except report viewer not showing reports. i use Fiddler jam to trace the problem but can't understand the output the following link https://jam.getfiddler.com/sessions/9f5a7b05-843b-4af5-98b5-c03114e3f700?t=587433717443c9c10eeb06fb6e2c60644c8065cecb4332d81c2e8853c619228b057b5a9f3b84f54a98b5c03114e3f700

the other ver which run in Azure service make deffiernt output in Fiddler jam : 

https://jam.getfiddler.com/sessions/16b8e346-d884-4a87-b9db-512619933502?t=6d25ac1629c9c2481948bea862f1f9bb4faeeae1bd0f881c8f0a5668b91373a046e3b81684d8874ab9db512619933502

i hope you can help me in this issue

khaled
Top achievements
Rank 1
Iron
 answered on 10 Jun 2023
1 answer
194 views

I just upgraded to version 2023 R1 (with much difficulty with versions of Newtonsoft.Json).  When I run a report that has a parameter to pick from a list of choices the selected choice does not remain highlighted. I am using the MVC report viewer. It worked in the previous installed version 2202 r2 (16.1.22.511).

When I tried to add a new MVC report viewer it refuses to create a new one because all of the Telerik report viewers are 2022 R2. It refuses because the targeted version does not match the installed version. I ran the Upgrade Wizard again with no change, it still has 2022 R2 items in the list (see picture)

  • Error: Incorrect version. The target project is using different Telerik Reporting version. Before adding this template the project should be upgraded with the Upgrade Wizard or you should choose item template for the correct Telerik Reporting version.

Then I removed all of the Telerik references, added the 2023 R1 references back in. Shut down Visual Studio and restarted. Try again to add a report viewer and it still says all of them are 2022 R2: Telerik Reporting, Telerik Reporting.OpenXmlRendering, Telerik Reporting.OpenXmlRendering.2.7.2, Telerik Reporting.Services.WebApi, and Telerik Reporting.Mvc.

This may be two problems instead of the one I thought I had.

Dimitar
Telerik team
 answered on 09 Jun 2023
3 answers
2.3K+ views

Hello,

I am using Telerik Report Designer HTML5. I had made some graphs and deployed it on one of my websites. It had been working fine for quite a few months now. However, today, our hosting provider restarted the server and when I opened my website, all of the graphs on it started giving the following error:

 

Error registering the viewer with the service.
An error has occurred.
Incorrect value (null) deserialized. Make sure you are using CacheStorage inside single-instance application deployment only.

 

I have not made any changes/modifications to the Reporting. The graphs also display on my local environment, but it doesn't work on the server. Attached screenshots show error messages that are being displayed.

I would be grateful for your assistance.

Logan Marshall
Top achievements
Rank 2
Iron
 answered on 08 Jun 2023
1 answer
699 views

Hi, I have a requirement where I need to view SSRS reports using Telerik Report Viewer. Is there any way I can achieve this? 

Here is the details of what I have so far-

1. I created a RDL report on my project and deployed it to the Server. I'm able to view that report on SSRS Report Server portal. 

2. Now I'm trying to view that report in my Blazor Webassembly application using Telerik Report Viewer. I've created a REST service for that but it is not reading reports from SSRS Reporting  Server.

 

Is there any way, I can achieve this ?

Dimitar
Telerik team
 answered on 05 Jun 2023
1 answer
419 views

I have an HTML Textbox in my report with the expression {HtmlDecode(Fields.RAW_HTML)} and it works in most cases EXCEPT

when the RAW_HTML field contains "&" in the literal string: ex) <span>Jack & Jill</span>

I have tried replacing "&" with "&amp;" on the SQL query, however i get the same error.

"An error ocurred while parsing EntityName"

Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?