Telerik Forums
Reporting Forum
1 answer
82 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
384 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
200 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
327 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)

Jirka
Top achievements
Rank 1
 answered on 19 Oct 2016
1 answer
203 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.1K+ 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
172 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
2 answers
393 views

Good Morning,

 

Apologies if this has been asked before but I had difficulty finding a solution.

I have a report parameter who's datasource (I'm using object data source) is dependent on three parameters above it (Location, Date & Line Number). Once these have been selected, it generates the available values for my job parameter but I would like the first index of the available values to be automatically selected.

 

Currently it states 'Please input a valid value' but the display shows the first displayMember from the available values (Picture attached). On a side note, I also can't select the first value from the list straight away, I need to get to the second value and go back to the first to get it to register.

Any help would be appreciated.

Many thanks,

Andrew

Andrew
Top achievements
Rank 1
Iron
 answered on 18 Oct 2016
3 answers
217 views

Hi All,
   At present l'm trying to achieve a couple of things as a mini proof of concept for a project, one l can do, the other alludes me. Reports to be created by the standalone designer, which are then dropped into a directory, where any application that needs them can change any connection strings and then load them into their respective viewers, but with all reports having no hard coded strings.

1. Create a report using the Standalone designer, then before rendering the report in a viewer have any / all SqlDatasources connection strings changed dynamically - OK (l can do this)

2. Don't have any strings in the report hard coded i.e textboxes for displaying titles, column headers etc.

I can do this by accessing the report in code, finding the appropriate item and settings its value before the report is rendered, however l would like to do this a bit more generically / the other way round; is there a way to set an item / collection on the report and then use an expression inside the standalone designer to bind say a textbox value to the an item in the collection (so it gets set at runtime), bearing in mind that the item may not have a datasource property for example a textbox that displays the name of a report on a page header.

What l would really like to do, assuming l could set a collection of say reportText objects on the report (that have a LabelText property) would be to use some sort of expression in the designer (using c# as an example)
textBoxTitle.Value = reportTextCollection.Where( item => item.controlID == "textBoxTitle").FirstOrDefault?.LabelText ?? "Default title value"
Or
textBoxTitle.Value = MyCustomExpressionAssembly.SetLabelText(controlID, reportTextCollection) // return see above

Any thoughts help appreciated, Thank you
Paul


Katia
Telerik team
 answered on 18 Oct 2016
1 answer
141 views

Hi,

 

I've put a table onto Telerik report containing more than 130 columns. When I export it as XLS and open it in Excel 2013 I get the message "Office has detected a problem with this file" and Excel starts in protected view.

When reducing the columns to max 130 the issue dosn't occur.

Is there any known problem regarding the columns count when exporting to Excel?

 

Best regards,

Rayko

Stef
Telerik team
 answered on 17 Oct 2016
Top users last month
Chester
Top achievements
Rank 1
Iron
Simon
Top achievements
Rank 1
Iron
Douglas
Top achievements
Rank 2
Iron
Iron
SUNIL
Top achievements
Rank 3
Iron
Iron
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?