Telerik Forums
Reporting Forum
1 answer
245 views
Hi,
How do I merge at run time , the columns of a row ?
See image attached table.

Greetings,
Victor
Stef
Telerik team
 answered on 27 Dec 2016
1 answer
127 views

I'm having an issue with my table not covering multiple pages in the exported PDF.

The table is in a Detail Section, within a panel. The panel with the table is the only item in the Detail Section.

The table, panel, and Detail Section are all set to KeepTogether False.

I import this .trdp file into a .cs file in my solution, build the object, and export it to a pdf.

When the table is too big for the page, it still creates a new page on the pdf.

 

Thoughts?

Stef
Telerik team
 answered on 27 Dec 2016
4 answers
941 views

HI

I am implementing the report using Telerik Reporting R3 2016

But I met a serious problem while running Report Viewer : 

Error registering the viewer with the service.
An error has occurred.
object reference not set to an instance of an object。

introduce steps:

Existing ReportLibrary - Report1 (DataSource - DataTable) : 

  Telerik Report Library R3 2016

  Report1.cs

    private void Report1_NeedDataSource(object sender, EventArgs e)
    {

      var objectDataSource = new Telerik.Reporting.ObjectDataSource();
      objectDataSource.DataSource = DataTable1;
   
      this.DataSource = objectDataSource; 

    }
 
  *How to: Bind to a DataTable
  http://docs.telerik.com/reporting/object-data-source-how-to-bind-to-data-table

Visual Studio 2015 Enterprise

1.Add > New Project > (.NET Framework 4.6.1) Telerik C# ASP.NET MVC Application

  Standard 2016.2.504.545(Dev)

2.Add Existing Report Libary and add project reference

3.Manage NuGet Packages

  Install Microsoft.Net.Http

  Install Microsoft.AspNet.WebApi

4.Add > New Item > Telerik MVC Report Viewer View R3 2016
 
  Configure reporting engine

    Rest service

    Create new REST service

    Existing report definition
      Type report definition create in Visual Studio
 
  After template the 'Telerik Reporting REST WebAPI Service' successfully configured.

    Controllers\ReportsController.cs

    ReportViewer\js\telerikReportViewer-10.2.16.1025.min.js

 

    and more...

5.Move \ReportViewerView1.cshtml into Home\ReportViewerView1.cshtml


6.Add \Home\ReportViewerView1 Action : 

    public class HomeController : Controller
    {

        public ActionResult ReportViewerView1()
        {
            ViewBag.Message = "ReportViewerView1.";

            return View();
        }

7.Run http://localhost:21797/home/ReportViewerView1 shown :

  Error registering the viewer with the service.
  An error has occurred.
  Object reference not set to an instance of an object.

  (see picture)  

*Works http://localhost:21797/api/reports/formats

[{"name":"PDF","localizedName":"Acrobat (PDF) file"},{"name":"CSV","localizedName":"CSV (comma delimited)"},{"name":"XLS","localizedName":"Excel 97-2003"},{"name":"RTF","localizedName":"Rich Text Format"},{"name":"IMAGE","localizedName":"TIFF file"},{"name":"MHTML","localizedName":"Web Archive"},{"name":"XPS","localizedName":"XPS Document"}]

 
*NOT Works http://localhost:21797/api/reports/client
 

Another problem is, In Visual Studio, the report design/preview are works 
but I need press the 'Refresh' toolbar button to enforce the report show the data 
(the data not displayed automatically while enter preview tab)

Is there have a complete/workable sample project - ASP.NET MVC5 + Report(DataTable)/Report Viewer/Exports.
 
Best regards

Chris

 


Stef
Telerik team
 answered on 26 Dec 2016
1 answer
917 views
how can i apply if statement in side html text box to format a word from the value in a different color based on certain condition
Stef
Telerik team
 answered on 26 Dec 2016
5 answers
1.0K+ views
I have a expression in telerik reporting 2010 : ReportItem.Parent.Parent.DataObject.MyFields that I asign it as the datasource of a table in detail section of a subreport. It works fine in 2010 q2 . But in 2016 r3 I canot see any thing for the subreport. I know the problem is in the above expression . What is the equivalent of this expression in telerik reporting of 2016 r3 ? (In some parts I have until 5 .Parent)
Chris
Top achievements
Rank 1
Veteran
Iron
Iron
 answered on 26 Dec 2016
6 answers
359 views

Hey

I'm generating charts based on the output from SQL, I have the SQL set to sort the output in a certain order, but when the Report Designer is displaying the chart, It's sorting the legend alphabetically.  I must have my legend in the format:

Good
Fair
Poor

Which is exactly how my SQL is outputting the data.  I've even added an addition ORDER BY statement in the SQL statement INSIDE the designer and it's not working.  

Apparently you can you can fix this with the expression editor, so please provide me the syntax / code to do this, I must have the legends in this format. 

To quote the documentation in your own system:

"Items are ordered in the legend according to the order that they are processed by the processing engine. You can change the order by changing the Graph.SeriesGroups SortingsExpression or Direction."

How is the chart processing the data in the wrong order, being I delivering to the system in  the exact order it should be processing it.

Thanks
Andrew





Stef
Telerik team
 answered on 23 Dec 2016
10 answers
385 views
I did not set max or min value for Y axis, so by default it should auto scale. For some charts, the max major tick does not show up. Could you please help?

I did specify the step scale for X axis, so that it is expected that the max date does not show up.

Stef
Telerik team
 answered on 23 Dec 2016
4 answers
1.0K+ views

I'm programmatically laying out a report design, and it contains some expensive (slow) operations.  I noticed that the resolver's Resolve method is called twice each time I want to view the report (image of call stack attached).  I found another post here http://www.telerik.com/forums/how-do-i-get-a-ireportdocument-from-a-trdx-file#L8MMUbxn_UKgCTtHVjcNjA that mentions that Resolve will be called every time the report service requires a new report definition instance.  I'm trying to improve the performance of my report generation, and not having to generate my entire layout twice would help.  Is this working as designed?  Or do you have any suggestions to prevent generating the layout twice?

Thanks!

Stef
Telerik team
 answered on 23 Dec 2016
7 answers
114 views

When I update to Reporting R3 2016, fields or text on most of my reports disappears. Before I spend a few hours trying to track the issue down, does anyone have any idea what has changed that would cause the text to disappear?

This kind of issue has been a problem with Telerik over the years. I don't understand how you can release a new version of a development library that breaks developers existing code. Now that you are owned by Progress, is there a plan to make your products more reliable?

 

 

Stef
Telerik team
 answered on 23 Dec 2016
5 answers
626 views
I have a crosstab tab that sums up the amount sold during a month. This works very well. I want to average the monthly sum but only using month that have a non-zero amount sold.

For example:

Product      May   Jun   Jul   Avg
123             10      9        8      9
124             15     -        10   12.5
125               6     10      12     9.333
126               -        -         7     7

So product 124 is divided by 2 instead of 3 and product 123 divided by 1.

I have looked at the forums and used google but I cannot figure out how to do this. Any help would be greatly appreciated.

ROD>
May Zin
Top achievements
Rank 1
 answered on 23 Dec 2016
Top users last month
Jay
Top achievements
Rank 3
Bronze
Iron
Iron
yw
Top achievements
Rank 2
Iron
Iron
Stefan
Top achievements
Rank 2
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?