Telerik Forums
Reporting Forum
1 answer
2.8K+ views

Hello,

I have several panels in a report.  Each panel is stacked on the other.  When the underlying field value in one of the panels =IsNullOrEmpty(Fields.mspecifications), I want the entire panel to go away for that report and the other panels to move up and take the place of the panel that has no data.

How do I make this happen? 

In My Crystal Report, I simply check the "Suppress Blank Section" checkbox.

Thanks,

TFISHER

Patrick | Technical Support Engineer, Senior
Telerik team
 answered on 27 Jan 2020
1 answer
410 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
264 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
660 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
444 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
778 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.4K+ 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
379 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.7K+ 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
484 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
Top users last month
Ambisoft
Top achievements
Rank 2
Iron
Pascal
Top achievements
Rank 2
Iron
Matthew
Top achievements
Rank 1
Sergii
Top achievements
Rank 1
Andrey
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?