Telerik Forums
Reporting Forum
1 answer
93 views

Hi there,

I have a master-detail report with a header with approximately 35 fields, 25 sub-reports (tables) in a detail section and a report footer. I've used a row above the Table for the sub-report header with the row below for column headings and the row on the bottom for the field data. Each sub has 1 or 2 Report Parameters that defines what is seen.

Recently when I edited some of the subs they started repeating based on the matching rows in the SQL Server 2008 R2 database which typically means that both the Report and the Table have their respected data source set to the same data source. But in this case there is only one data source set and that is on the Table itself. 

Has anybody seen this before? Any help would be appreciated.

Thanks,

Jack Willhoite

Gerry
Top achievements
Rank 1
 answered on 21 Oct 2016
2 answers
85 views

I have a requirement to create a report that lays out the data detail in a specific order (chronological). As part of this I need to surround groups of detail sections with headers and footers that describe a common feature. The following is an example of what I want:

Common feature 1 header
Detail 6:00
Detail 7:00
Common feature 1 footer
Common feature 2 header
Detail 8:00
Detail 9:00
Common feature 2 footer
Common feature 1 header
Detail 10:00
Detail 11:00
Common feature 1 footer

When I add a group for the common feature though, I get the following:

Common feature 1 header
Detail 6:00
Detail 7:00
Detail 10:00
Detail 11:00
Common feature 1 footer
Common feature 2 header
Detail 8:00
Detail 9:00
Common feature 2 footer

I must preserve the order of the detail sections and let the grouping headers and footers repeat if necessary. Is there a setting or something to allow for this?

 

Katia
Telerik team
 answered on 21 Oct 2016
9 answers
140 views

Hello,

When maintaining reports with extensive use of Object data source objects, it is difficult to navigate in the Datasouce explorer pane. The listing seems to have no sensible sorting order, or ways of re-ordering or grouping the objects. Using sub reports is not an option for me, as it will be very difficult to keep the Excel exportable format when parts of the layout is locked inside an individual component. 

Any thought on how this can be improved?

 

Best regards,

Magnus

Magnus
Top achievements
Rank 1
Iron
 answered on 21 Oct 2016
1 answer
55 views

Hello,

I have a scenario where in i am creating a table report using Telerik report designer R3 2016. The problem is Whether i select toggle mark initially expanded or not it always show the collapsed sign initially. In the previous versions it seemed okay and worked perfectly. Following attached is the trdx file and images for the reference.

Peter
Telerik team
 answered on 20 Oct 2016
8 answers
337 views

I am trying to use the HTML5 viewer with the following MVC code. 

@(Html.TelerikReporting().ReportViewer()

           .Id("reportViewer1")
           .ServiceUrl("/api/reports")
           .TemplateUrl("/TelerikReports/Html5/ReportViewer/templates/telerikReportViewerTemplate-9.1.15.731.html")
           .ReportSource(new TypeReportSource() { TypeName = "MyApp.TelerikReports.MonthlySales, MyApp.Reports" })            
           .ViewMode(ViewMode.Interactive)
           .ScaleMode(ScaleMode.Specific)
           .Scale(1.0)
           .PersistSession(false)
           .Deferred()
    )

 

I don't get any errors but the viewer renders as totally blank, no HTML is generated. What is most likely reason for this?

 

Craig
Top achievements
Rank 1
 answered on 19 Oct 2016
5 answers
159 views
After I upgraded to Telerik Reporting Q3, the Reportbook control is missing in my toolbox.  Help!
Katia
Telerik team
 answered on 19 Oct 2016
4 answers
247 views

Hello,

I use ReportViewer class and its method ShowPageSetupDialog for the page setup dialog.

When i set some values to out of range (e.g. margins)  in the dialog, then ReportViewer shows object reference error.

Can i prevent this situations, or catch the exception?

Regards,
Tomáš

 

Exception thrown: 'System.NullReferenceException' in Telerik.Reporting.dll

An error has occurred while rendering the report: System.NullReferenceException: Object reference not set to an instance of an object.
   at Telerik.Reporting.Paging.Table.CellAt(Int32 rowIndex, Int32 columnIndex)
   at Telerik.Reporting.Paging.Table.RenderCells(TableRegion region, RectangleRF clip, Double left, Double top, Double reservedLeft, Double reservedTop)
   at Telerik.Reporting.Paging.Table.AddChildrenToPage(RectangleRF clip)
   at Telerik.Reporting.Paging.PagingElementBase.AddToPageRecursive(RectangleRF parentClip, Double parentTop, Double parentLeft, Double parentReservedTop, Double parentReservedBottom, Double parentReservedLeft, Double parentReservedRight)
   at Telerik.Reporting.Paging.PagingElementBase.AddChildrenToPage(RectangleRF clip)
   at Telerik.Reporting.Paging.PagingElementBase.AddToPageRecursive(RectangleRF parentClip, Double parentTop, Double parentLeft, Double parentReservedTop, Double parentReservedBottom, Double parentReservedLeft, Double parentReservedRight)
   at Telerik.Reporting.Paging.PagingElementBase.AddChildrenToPage(RectangleRF clip)
   at Telerik.Reporting.Paging.Group.AddChildrenToPage(RectangleRF clip)
   at Telerik.Reporting.Paging.PagingElementBase.AddToPageRecursive(RectangleRF parentClip, Double parentTop, Double parentLeft, Double parentReservedTop, Double parentReservedBottom, Double parentReservedLeft, Double parentReservedRight)
   at Telerik.Reporting.Paging.PagingElementBase.AddChildrenToPage(RectangleRF clip)
   at Telerik.Reporting.Paging.Group.AddChildrenToPage(RectangleRF clip)
   at Telerik.Reporting.Paging.PagingElementBase.AddToPageRecursive(RectangleRF parentClip, Double parentTop, Double parentLeft, Double parentReservedTop, Double parentReservedBottom, Double parentReservedLeft, Double parentReservedRight)
   at Telerik.Reporting.Paging.PagingElementBase.AddChildrenToPage(RectangleRF clip)
   at Telerik.Reporting.Paging.Group.AddChildrenToPage(RectangleRF clip)
   at Telerik.Reporting.Paging.PagingElementBase.AddToPageRecursive(RectangleRF parentClip, Double parentTop, Double parentLeft, Double parentReservedTop, Double parentReservedBottom, Double parentReservedLeft, Double parentReservedRight)
   at Telerik.Reporting.Paging.PagingElementBase.AddChildrenToPage(RectangleRF clip)
   at Telerik.Reporting.Paging.PagingElementBase.AddToPageRecursive(RectangleRF parentClip, Double parentTop, Double parentLeft, Double parentReservedTop, Double parentReservedBottom, Double parentReservedLeft, Double parentReservedRight)
   at Telerik.Reporting.Paging.PageCompositionBase.CollectElementsAndDataForPage()
   at Telerik.Reporting.Paging.PageCompositionBase.OutputPage()
   at Telerik.Reporting.Paging.PageCompositionBase.CreatePages()
   at Telerik.Reporting.Paging.PagerBase.Telerik.Reporting.Paging.IPager.CreatePages(IPageHandler handler, Report report)
   at Telerik.Reporting.BaseRendering.RenderingExtensionBase.Render(Report report, Hashtable renderingContext, Hashtable deviceInfo, CreateStream createStreamCallback, EvaluateHeaderFooterExpressions evalHeaderFooterCallback)

Petr
Top achievements
Rank 1
 answered on 19 Oct 2016
1 answer
164 views
AVG

I have a report that shows the date, I want to take an average, but when using Avg (date) error
I have a report that shows the date, I want to take an average, but when using Avg (date) error
Peter
Telerik team
 answered on 19 Oct 2016
1 answer
1.0K+ views

I have a set of nested groups on my report that are for the most part working as needed.  Each group has a corresponding Header section which lists the appropriate info for the group, and the Detail section displays the appropriate info for the groups.  There is an unwanted behavior, however, with how often the outermost group header is displaying.  In general, my requirement is to display the data like:

Week 1 (Jan 1 - Jan 7) Group Header
Product Category 1 Group Header

Product 1 Detail
Product 2 Detail
Product Category 2 Group Header
Product 3 Detail
Product 4 Detail
Product Category 3 Group Header
Product 5 Detail
Product 6 Detail
Week 2 (Jan 8 - Jan 14) Group Header
Product Category 1 Group Header

Product 1 Detail
etc

The output I'm getting, however is:

Week 1 (Jan 1 - Jan 7) Group Header
Product Category 1 Group Header

Product 1 Detail
Product 2 Detail
Week 1 (Jan 1 - Jan 7) Group Header (UNWANTED LINE)
Product Category 2 Group Header

Product 3 Detail
Product 4 Detail
Week 1 (Jan 1 - Jan 7) Group Header (UNWANTED LINE)
Product Category 3 Group Header
Product 5 Detail
Product 6 Detail
Week 2 (Jan 8 - Jan 14) Group Header
Product Category 1 Group Header
Product 1 Detail
etc

Is there a way to control where/when the outermost group header appears?  I don't need this outermost group header to repeat every time the inner group header changes, only at the beginning of each of the outermost groups.  Is this something that has to be done programmatically, or is there a report setting that controls this?

Thanks!

Katia
Telerik team
 answered on 19 Oct 2016
3 answers
133 views

Hi -

 

We have a few telerik reports that are hosted in a silverlight web site. And I am trying to create a console app that would generate and save the reports in PDF formal. When I call "Render", I get the message, "The report can't be created". I am not sure what I would need to do different.

 

Please help.

 

Thanks, Shilpi

Stef
Telerik team
 answered on 18 Oct 2016
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?