Telerik Forums
Reporting Forum
1 answer
403 views

Hello,
I am having some trouble with regards to a string in htmlTextBox. The string includes a combination of both English and Arabic substrings. In my database I have a separate column for storing English and separate column for storing Arabic. I am retrieving both columns as a single value using the following query
ItemDescriptionEN + '<br/>' + ItemDescriptionAR as [ItemDescription]
Most of the time it works fine, but sometimes, when the [ItemDescription] has numeric digits, it displays the value just fine during the Preview in report viewer, but disturbs the arrangement of RTL letters when exporting to PDF or directly printing from printer.

Kindly find the attached pictures:

1- Preview.PNG: (Shows everything is fine.)

2- After Export or print.PNG. (Disturbs the string when exported as PDF or if sent direct to printer for printing)

 

Kindly recommend any alternate report control to handle the '<br/>' in the description, or provide a solution to this problem.

Thanks

 

Neli
Telerik team
 answered on 27 Jan 2020
3 answers
257 views
Hi,

I'm using on the server side the REST service. The report is using an object data source. I have created a business object OrderReadService

    [DataObject]
    public class OrderReadService
    {      
        [DataObjectMethod(DataObjectMethodType.Select)]
        public IEnumerable<Order> Get()
        {
                ....          
        }
    }

This works so far fine. But I need to inject this object with some dependecies. Something like:

    [DataObject]
    public class OrderReadService
    {      
public OrderReadService(IRepository repo, IUserProvider userProvider)
{
...
}

        [DataObjectMethod(DataObjectMethodType.Select)]
        public IEnumerable<Order> Get()
        {
            ....          
        }
    }


Is there any place where I can override the business object initialization ?

The server side looks like this http://www.telerik.com/help/reporting/telerik-reporting-rest-implementing-http-service.html

Neli
Telerik team
 answered on 24 Jan 2020
5 answers
626 views
Hello,

I'm developing a WPF application (C#) and I'd like to know how to edit a Telerik report. I mean, how can I allow the final user to edit non calculated fields? I'd like him to change change any data from the report and then I'd like the report to refresh the calculated fields.

Could you please help me with this?

Thanks.
Katia
Telerik team
 answered on 24 Jan 2020
1 answer
425 views

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

Todor
Telerik team
 answered on 23 Jan 2020
9 answers
744 views
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
Neli
Telerik team
 answered on 22 Jan 2020
3 answers
2.3K+ views

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

Neli
Telerik team
 answered on 21 Jan 2020
5 answers
371 views

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 ?

Neli
Telerik team
 answered on 21 Jan 2020
14 answers
1.6K+ views
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) 
Rod
Top achievements
Rank 1
 answered on 20 Jan 2020
1 answer
473 views

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.

Todor
Telerik team
 answered on 20 Jan 2020
1 answer
94 views

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.

Todor
Telerik team
 answered on 20 Jan 2020
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?