Hi, we are using reportViewer + reportServices, in a single-page application.

We configured SQL server storage, and we set an expiration of 12 hours.

Problem is, when the user let its screen opened, and come back the day after, and he clics "next page", or change the parameters to generate a new report, we get the "410 Gone" error.

Yes, we can increase the timeout to 24 hours, but what about weekends?
Ok we can set it to 7 days... but we don't want to.

We try to catch that error in the "error" event of the viewer, but depending on the action we take, the error is not always the same, and we get wrong informations about the real cause of the error. When refreshing data, there's no informations about expiration of the instanceID.  We only get it when navigating on an existing report.

If I change the page, I get a "gone" error message.

If I change the parameters, I get something else.

When I look at fiddler, and I catch my "xhr" error at high level, I can trap these 410 errors. 

The question is:

Is it possible to start a new session from scratch when we detect that issue without restarting the application (F5)? 
We think about calling refreshReport every 3 hours, but it's not a gold solution...

I think that you should implement "keepAlive" process to keep the clientID always ready when the viewer is loaded on screen.

Also, after a few months, we see that the SQL database is full of outdated data, I did not find any official method to say to the storage "Delete all temp data older than 7 days". 

I created a stored procedure based on the "tr_string.values" data, but it's not the best.

(SELECT * FROM tr_String AS ts WHERE LEN(VALUE) = LEN('yyyy-MM-ddThh:mm:ss') AND VALUE < '2020-01-13T00:00:00')

From that query, I am able to destroy outdated ids from 4 tables. But, is there a better method?

Thank you

Hi

We are creating a SL application, where we are using Telerik Reporting for Reports. We are using ReportParemeter to send input to the Report. We are sending the ids of the selected criteria on UI and formatting it to an Xml format and sending it as Report Parameter string to the report. But when user selects large data on UI, i.e when the size of Report Parameter string is more, then its not able to call the report at all. We are not getting any error as well. But the report is blank. And even the breakpoint at the first line in the report also is not reaching. So, please let us know is there any max size criteria for ReportParameter string? or could it be any other issue? if user selects less number of criteria, its working very well.

Please let us know what would be the issue.

Thanks
Ravindra

Hi,

I am currently evaluating Telerik Reporting product.

Currently I have a WebApi project and a method which calls Reports Library. I have created a report with JsonDataSource with inline json. The method from Report library will use the report and create a PDF out of it. Everything works fine. Instead of inline json I would like to use the json passed from my webapi project.

Let me know how I can achieve it.

Thanks

Hi

When we want to export the report in silverlight , the excel item says export to excel 97-2003. Is it possible to exporting excel 2016 with Telerik reporting R3 2016 ?

I am using this to catch divide by zero errors and it's not working.  What am I doing wrong with this expression in the report?

 

=iif(Fields.Price2 <>0,(Fields.Price1 /Fields.Price2) * 1000,0)

Can I use the ConnectionStrings in appsettings.Development.json/appsettings.Production.json?

Everytime I try todo so, the report  gives me an exception, but if if move the same exact ConnectionString to appsettings.json file, the report runs.

Hello, I currently have the graphs attached in the first file ("graphs I have.png") and I need to get them as close as possible to the second file ("graphs I want.PNG").

My main issue is the columns not being aligned with the ticks (months).

Is there a way to achieve this?

 

It'd also be really helpful to know how to show the whole year even if I have no data for those months, but the first thing is my main priority right now.

Hi,

When we load two reports in parallel  then any one report always stuck in loading and only load once one of them finish the loading. I even implemented the MSSqlserver cache but still the loading behavior is same. It seems Telerik reporting rest api always process one report request at a time and put other report request in queue. Can we make reports to load parallel?   

Hello, I very new with telerik reporting. Currently I,m create a report for my WPF application. My problem is the data in the report not display after I add search filter for startdate and end date. Here I attach the picture how I do the filter

Hi Telerik,

When i press the print button on report viewer (we are not using HTML5 report viewer)

we began to recive the following error on chrome console.

And pdf print page is not opening. 

 

ERROR:

Resource interpreted as Document but transferred with MIME type application/pdf: "http://192.168.0.52/Telerik.ReportViewer.axd?instanceID=6bda0c2faa75444b8a9ded052f8bbaa3&optype=Print&format=PDF&pageIndex=0&rand=1569851505961"

Before one weeks ago everything was fine, print button was working correctly.

we use report viewer Version=11.1.17.614

 

Best Regards

Ünsal