Telerik Forums
Reporting Forum
1 answer
293 views

Hello,

I have created a report in Telerik Report designer R3 2016, here i have used table and sub-report within table, for which 2 SQL queries are used in report which is taking 100 seconds to load in SQL server, but the telerik report is getting displayed in 20-25 minutes.

please help me to come out of this.

Stef
Telerik team
 answered on 09 Mar 2017
3 answers
224 views

Hi,

I could not find a pointer on how to migrate to ReportSource.Parameters for Parameters with predefined values. In my WinForms application I use ReportParameter.AvailableValues. I found that Report.Parameters class has AvailableValues but not ReportSource.Parameters. Somehow I can't make the connection between the parameters defined in the report source and the definition of parameters during processing.

Is there an example for migrating existing code that uses IReportDocument.Parameters with AvailableValues.

Regards

Erwin

Stef
Telerik team
 answered on 09 Mar 2017
3 answers
173 views

Hallo,

i have a problem with using multiple Checkboxes in the ReportParamters. No matter which checkbox im clicking, only the state of the first Checkboxes is changing. In the HTML Code, the Checkboxes all have the same ID.

Stef
Telerik team
 answered on 09 Mar 2017
3 answers
673 views

Hello,

in our web application we use the HTML5 report viewer and we created a report (.NET type report in C#) with a list. For every list item we display an image based on the value of an status field of that list item.
For that we have four picture boxes that have the exact same location. With conditional formating we change the visibility based on the status field.
We have three questions about that:

1) Another possibility is to design only one picture box and change the background based on the status field. But if we do so we don“t have the sizing property so we need to use an image that is small enough to fit our needs.
But when we use a small image it gets blurred when zooming in. Is it possible to get it done like that (with only one picture box) with a bigger image and sizing it?

2) The above-mentioned images are displayed on the second page of the report. When the first report page gets rendered it only loads the content and images of the first page. 
If we go to page 2 it starts downloading the other images so the images appear after a delay. 
Is it possible to change it in a way that the images get loaded immediately after the first page finished rendering respectively after the report has finished loading 
and before we navigate to the second page? So in the time the user is viewing the first page the content of the other pages is already getting loaded in the background. 

3) Some of our images on page 2 are loaded "immediately" and some appear delayed one after another. We checked the network tab in Chrome console.
It says that some of them have a big "Waiting (TTFB)" time. It looks like this waiting time increases by about 500ms for every image that has this waiting time. See figure (green bar is "Waiting (TTFB)", blue is "Content Download").
Can you tell us where this waiting time could come from?

Thank you in advance!

Katia
Telerik team
 answered on 09 Mar 2017
3 answers
290 views

Since migration to 11.0.17.222 I have had problems linking master/child type reports.  I have several reports which consist of a "master" report with one or more "child" reports in it.  

The "child" reports exist in the "group footer" sections for respective groups found on the master report.  Prior to the 11.0.17.222 migration using a report parameter of "= ReportItem.DataObject.Fund" resulted in a parameter "Fund" being made available for consumption by the "child" report.  As of the 11.0.17.222 migration this is passed into the "needs data source" event (of the child report) as null 100% of the time.

As a work around for the problem, I have re-written my "needs datasource" events to use the "ProcessingElement" value and access the bound data element from the ".DataObject.RawData".  This seems to be working although I suspect it is probably a "non-supported" means of resolving this apparent bug.

 

A sample of what I am doing is as follows:

 

var rowData = qd.DataObject.RawData as BudgetDataLibrary.SumRevenueByFundData;
                        if ((rowData != null) &&
                            (string.IsNullOrWhiteSpace(rowData.Fund) == false))
                        {
                            parentFund = rowData.Fund;
                        }

 

 

Stef
Telerik team
 answered on 09 Mar 2017
3 answers
800 views
Is it possiable to use web api(json) as data source of the HTML5 Report Viewer?
Stef
Telerik team
 answered on 09 Mar 2017
2 answers
207 views

Hello,

 

I have a table in the detail section of a subreport, so it should recurr for each element in the bound datasource (in this case objectives).  SO there shoudl be one talb eper objective. The report was working fine and then stopped after upgrading to the most recent version.  I'm wondering if there is a recommended way to do what I am doing...  See capture.png

Essentially for each objective, I want to display the result in a table, because the text of each attribute is long and the table will expand appropriately to display the item.  The Goal number in green displays correctly, however the attributes such as Area of desired change are blank..

I've tried setting the textboxes in the table directly on the itemdatabound event of the detail section (see commented text below) and this does work but if there are three objectives it sets all three instances of the table textboxes rather than the current detail section (and table) only. I've also tried the NeedDataSource of the table...  what is the best way to go about this?

private void TelerikRptTreatmentPlanSub_NeedDataSource(object sender, EventArgs e)
{
    (sender as Telerik.Reporting.Processing.Report).DataSource = ObjectiveService.GetForTreatmentPlan(this.Parameter1);
}
 
private void detail_ItemDataBinding(object sender, EventArgs e)
{
    Telerik.Reporting.Processing.DetailSection section = (sender as Telerik.Reporting.Processing.DetailSection);
    object _iD = section.DataObject["ID"];
    tblObjective.DataSource = ObjectiveService.GetByID(Int32.Parse(_iD.ToString()));
 
    //txtGoal1AreaOfDesiredChange.Value = _objective.ObjectiveAreaofDesiredChange;
    //txtGoal1TimeFrame.Value = _objective.TimeFrameandModality;
    //txtGoal1Objective.Value = _objective.Description;
    //txtGoal1BaseLines.Value = _objective.Baselines;
    //txtGoal1MeasuredBy.Value = _objective.MeasuredBy;
    //txtGoal1Interventions.Value = _objective.Interventions;
}

 

 

Jonathan
Top achievements
Rank 1
 answered on 08 Mar 2017
1 answer
560 views

We have created a simple function in C# external assembly which returns string and doesn't accept any parameter. We have configured it in Standalone Report Designer config and function is available under "misc" section. We have used the same on a text box using fully qualified name (assembly.class.function).

But on report preview, text box is blank. We are able to attach the process in VS and debug point is loaded which means, assembly is loaded in attached process but it never hits the break point. Using Iif function we found that function call on report returns null but it seems that it never calls the C# implementation.

Are we missing anything here?

Stef
Telerik team
 answered on 08 Mar 2017
1 answer
83 views

I Have a method in webapi, which is used to get the data and it is having IHttpActionResult as return type, now how can i display the data in Telerik ReportViewer

 

Thanks in Advance

Nasko
Telerik team
 answered on 08 Mar 2017
2 answers
881 views
We cannot determine how to calculate date differences in Expressions (usage example: highlight a row if the Current Date is 7+ days past the Due Date). There appear to be very limited date manipulation functions that can be used in Expressions.
Cecilia
Top achievements
Rank 1
 answered on 07 Mar 2017
Top users last month
Rob
Top achievements
Rank 3
Bronze
Iron
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?