Telerik Forums
Reporting Forum
1 answer
186 views

Hi,

I was creating a new report which having sub-report.

After final update for telerik report 9.2.15.1126 (Capture_3).

But i couldn't find the tool sub-report in toolbox on designer page (Capture_2).

And later i have noticed that the report designed before the update when i was using telerik report version Q3 of 2012, 

now showing the error on opening that page as shown in attached file below (Capture_1).

Does telerik removed the sub report option from the designer or any other tool is there same as sub report.

 

With Regards,

Mohammed Rafsanjany

Stef
Telerik team
 answered on 17 Dec 2015
1 answer
182 views

Hi,

 I have a requirement for a graph report that is grouped by a property and therefore shows a graph per each group.

 The desired look is for the legend to be at the top of the report and not to be repeated for each graph (number of series 'is'/'can be made to be constant' through each group). Also each graph is to have the same size.

From fiddling around I can think of 2 ways of doing this by hooking up to the ItemDataBinnding or ItemDataBound events:

- Show the legend for the first graph only and somehow make the graph (plot area) height the same as the other graphs.

- Add a dummy group of data that will become the first graph, show the legend only on this one and hide the plot area.

 

It appears that if I set the Visible property of the plot area to false at runtime the plot area is still visible. Also trying to set the plot area height to 0 does not work. Any suggestions?

 

Stef
Telerik team
 answered on 17 Dec 2015
1 answer
69 views
I'm using Silverlight and the MVVM pattern with my current project. I have a listbox where the currently selected item is bound to a single telerik report viewer control. When the user selects an item in the listbox, the selected item changes and triggers the report to be displayed in the report viewer control. This all works as expected. My issue is that when the user goes back to a previously selected report, the report viewer sends a new report request to the server rather than trying to retrieve the cached report. I did a little bit of digging and found the DataContext of the telerik report viewer is a ReportViewerModel that has a CurrentSessionID property. On a new report request the CurrentSessionID is set to null. I'd like to store the CurrentSessionID after a report is rendered. That way if a user goes back to a report that's already been run, I can set the CurrentSessionID. Unfortunately, the CurrentSessionID property is a private property and I can't set it's value. Is it possible to make CurrentSessionID a public property? How can I accomplish this?
 
 
 
 
 
Stef
Telerik team
 answered on 17 Dec 2015
1 answer
123 views

Hi mates,

I have a report with a dataset with some textboxes and a table. There are two dataset, one of the report (dsReport) and another different one of the table (dsTable). This table has two columns, the first one is a subinform and the other one show a value of dsTable. A field of dsReport is used like a paremeter in dsTable with the expression ReportItem.DataObject.id.ToString(). The value of the field that is showed in the second column is showed successfully but if I try to show this same value in the subreport using it like a parameter of the subreport, the value is not showed.

I think it's difficult to explain it so, please, if you need any trdx file, let me know it.

 Thanks a lot in advance.

Cheers.

David Ortega

davortsan
Top achievements
Rank 1
 answered on 17 Dec 2015
1 answer
81 views
which is better to use for caching when using REST Report service
file storage or sql database ??
Stef
Telerik team
 answered on 16 Dec 2015
3 answers
1.0K+ views

Hello, 

I am having a dynamic code based report which generates sales value for certain items. My items are grouped under categories. After each category i am showing a "TOTAL" row to show total value for all items under each category. Thats working fine... Where i am stuck is, i need to show the TOTAL row as BOLD (Font Style). Issue is, the TOTAL row which is added after each category is coming from the Stored Procedure itself. So how can i access Data Value of the CELL in my Report table(Layout) and check if value inside my CELL is "TOTAL" and i make that row as BOLD (Font Style)

I tried the Conditional formatting option that i found on this link http://www.telerik.com/forums/changing-fonts-and-colors-on-a-quot-dynamic-quot-table-based-on-value but this code is in VB and i am working on C#. 

If you can please provide a c# alternative to this it would be greatful

 

Thanks in advance.

Stef
Telerik team
 answered on 14 Dec 2015
5 answers
328 views

Hi,

 I am using ObjectDataSource. I have 4 list objects inside that object.

 In the report design view, I can see all the properties (fields) inside that object but not other 4 sub-objects. How can I make those properties (fields) display in the selection window?

Thank you!

 

 

Stef
Telerik team
 answered on 12 Dec 2015
1 answer
136 views

I have delivery tickets that I need to print.  The number of these can vary from 1 to 30+.  

I can get an individual report to show fine using this syntax in my MVC view.

@{
    var typeReportSource = new TypeReportSource() { TypeName = "Fasttrak.Reports.CarrierTrakDeliveryTicket, Fasttrak" };
        typeReportSource.Parameters.Add(new Telerik.Reporting.Parameter() { Name = "BOLRecId", Value = 16778 });
}
 
@(Html.TelerikReporting().ReportViewer()
        .Id("reportViewer1")
        .ServiceUrl("/api/reports/")
        .TemplateUrl("/ReportViewer/templates/telerikReportViewerTemplate-9.0.15.324.html")
        .ReportSource(typeReportSource)       
        .ViewMode(ViewModes.INTERACTIVE)
        .ScaleMode(ScaleModes.SPECIFIC)
        .Scale(1.0)
        .PersistSession(false)
)

 

I need to be able to bring up multiples of this report together.  I have tried the following and get "No Report" returned in the viewer.

@{
    var reportBook = new Telerik.Reporting.ReportBook();
     
    var test = Activator.CreateInstance(typeof(Fasttrak.Reports.CarrierTrakDeliveryTicket)) as Telerik.Reporting.Report;
    test.ReportParameters["BOLRecId"].Value = 16778;
    reportBook.Reports.Add(test);
     
    var reportDocument = new Telerik.Reporting.InstanceReportSource();
    reportDocument.ReportDocument = reportBook;
     
}
 
@(Html.TelerikReporting().ReportViewer()
        .Id("reportViewer1")
        .ServiceUrl("/api/reports/")
        .TemplateUrl("/ReportViewer/templates/telerikReportViewerTemplate-9.0.15.324.html")
        .ReportSource(reportDocument)       
        .ViewMode(ViewModes.PRINT_PREVIEW)
        .ScaleMode(ScaleModes.SPECIFIC)
        .Scale(1.0)
        .PersistSession(false)
)

 

This is my ReportsController:

using System.Web;
using Telerik.Reporting.Cache.Interfaces;
using Telerik.Reporting.Services.Engine;
using Telerik.Reporting.Services.WebApi;
 
public class ReportsController : ReportsControllerBase
{
    protected override IReportResolver CreateReportResolver()
    {
        var reportsPath = HttpContext.Current.Server.MapPath("~/Reports");
 
        return new ReportFileResolver(reportsPath)
            .AddFallbackResolver(new ReportTypeResolver());
    }
 
    protected override ICache CreateCache()
    {
        return Telerik.Reporting.Services.Engine.CacheFactory.CreateFileCache();
    }
}

 

Any idea why I'm not seeing the ReportBook in the viewer?  

Stef
Telerik team
 answered on 12 Dec 2015
4 answers
1.0K+ views

This works:

 <PictureBox Width="4.76060201236516cm" Height="2.80000019073486cm" Left="4.40019964058639cm" Top="5.5cm" Sizing="ScaleProportional" MimeType="image/png" Name="companyLogoPictureBox" Value="iVBORw0KGgoAAAANSUhEUgAAASwAAACWCAYAAABkW7XSAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAATKSURBVHhe7d09q/NkGAfwRwUd/QLObk5+ACcdBBcHwUHERVdR0MXF3VVx8AsILgqK4CAIgigouKigPpODgoio+P5y/dvemKenPX05SZq2vx/8SXKapD1t7qt30jS9BgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABwBP6u/NvJ7xWAyfmnkiKVohVtWtECJuOnSutRtWLVtKIFcHDdXcCH8ocVFCzg4FqxWu5VLVOwOBvvLoZMy7bFKjLf2/NROE13Va5XvDtPzy7FKjKv15GTlg38x8ojsymmYtdiFX9WsswHsyk4Qd6Rp2efYtVkOa8pJ8vGPS1XKVbxdCXL5zQHODkK1nRctVg1bT1wUu6p2LCnoa9i1XhdOZjbKkNsgN9XbNiH13exiqzv1fkojOv2yhCFJetM0eJwhihWkXUOsc3ARkP0sO6uZJ3ZLWR8OZWkFZW+i1X8Vmnrh9H1veF9VbExj6/1qFr+qgzJazz3eOXDyi+VfILqmx0D63vDS8MZurHwv3Y1hZb0sMZwCgXrycqblS8red7+qCw/n5uS7f27ymuVfLuDgeVJ71PW9+l8lIE8Wuk2rIy/XBlTu+9TSIrOr5UUno8rr1TuqzBBecH6lPXdMR+lZ59VlgtVihecjSEKFv3Ku38rUskQB9PhKChY0zX2gXSYPAVrWh6rLO/2fVEBSp/v3A9XFKz9vFdZLlQpXkBHaxx9yMfCCtbulgsVHKWbFsMhpYHkfvq4rzS4XOzt1tnUOIYqkGM899Ge//wfN+cPwHrtwO5Vtd3BDMcyRI8uX1dKhvZ+JY89SZEHtvBRJY0mX6m5ikPsDrYGPxXbPpYcM2yPPYUL2EEfDT/Lp2iN6RD3uc7yKQib4lgV7Kk1tn17WfdWsnx3d/CWShrlU7OpYeQ+D+3bSitCTuiEkbRGt492SZNlV1nnNoZc9yb53ln7/xIndcKIrtLLynKrdnG+ruS29LaGkHUP5dlK/qfcx2VRqOBAWiPcVZZJj2OV3PbEfLR3fRaMfFK3qkDlbz7Fgwna5xSHlypZ5s7Z1EWt0Q9hmx7Qrsk6E5d4hiOQRruLVjTW+aSS21+fTV3UCkVyWW+pO9+qAGcojX+X77Bl/h/mo2vl9sz34GzqRjlJMz+G0QrfqqL1c+WyopTbcqla4Myk8ad4bCPXsb6skHRlvk3HglrRWl5nplO01nmjknlcTxvOzKZdvK7Mt21xe6uyy3q7tl0OODPt6pabtF7N87Op7exSsJYDsFIKRHpOL86mVtunkGR+vywC9Kr7vbhVV19ovasMd5He2/X5KEC/UpRWHaNqxWxXz1SyvvtnUwA9WncAfp/eVfNC5Z35KEB/1p3/tE/vCmBwChawFdf4Bo7GFAvWc4shwORk9697Jc11B+KBMzeVHlb3J6/aT1IBTM5yjyrjdguBSWo/A9boXQGTpmABGzmtATgaUypY3yyGAJPWDrw/sBgCXNA9neDQuoVqSo8LmIgp7RJ+vhgCHIV9frcQ4GAULGAlpzUAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABwo2vX/gO1UuVd1+ULSgAAAABJRU5ErkJggg==">
          <Style TextAlign="Center" VerticalAlign="Middle" />
        </PictureBox>

  

But this does not:

 

<PictureBox Width="4.76060201236516cm" Height="2.80000019073486cm" Left="4.40019964058639cm" Top="5.5cm" Sizing="ScaleProportional" MimeType="image/png" Name="companyLogoPictureBox"  Value="= IsNull(Fields.CollectorSignature)">
          <Style TextAlign="Center" VerticalAlign="Middle" />
        </PictureBox>

 

My Table stored the field "CollectorSignature" as VARHCAR(MAX) and contains :

 

iVBORw0KGgoAAAANSUhEUgAAASwAAACWCAYAAABkW7XSAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAATKSURBVHhe7d09q/NkGAfwRwUd/QLObk5+ACcdBBcHwUHERVdR0MXF3VVx8AsILgqK4CAIgigouKigPpODgoio+P5y/dvemKenPX05SZq2vx/8SXKapD1t7qt30jS9BgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABwBP6u/NvJ7xWAyfmnkiKVohVtWtECJuOnSutRtWLVtKIFcHDdXcCH8ocVFCzg4FqxWu5VLVOwOBvvLoZMy7bFKjLf2/NROE13Va5XvDtPzy7FKjKv15GTlg38x8ojsymmYtdiFX9WsswHsyk4Qd6Rp2efYtVkOa8pJ8vGPS1XKVbxdCXL5zQHODkK1nRctVg1bT1wUu6p2LCnoa9i1XhdOZjbKkNsgN9XbNiH13exiqzv1fkojOv2yhCFJetM0eJwhihWkXUOsc3ARkP0sO6uZJ3ZLWR8OZWkFZW+i1X8Vmnrh9H1veF9VbExj6/1qFr+qgzJazz3eOXDyi+VfILqmx0D63vDS8MZurHwv3Y1hZb0sMZwCgXrycqblS8red7+qCw/n5uS7f27ymuVfLuDgeVJ71PW9+l8lIE8Wuk2rIy/XBlTu+9TSIrOr5UUno8rr1TuqzBBecH6lPXdMR+lZ59VlgtVihecjSEKFv3Ku38rUskQB9PhKChY0zX2gXSYPAVrWh6rLO/2fVEBSp/v3A9XFKz9vFdZLlQpXkBHaxx9yMfCCtbulgsVHKWbFsMhpYHkfvq4rzS4XOzt1tnUOIYqkGM899Ge//wfN+cPwHrtwO5Vtd3BDMcyRI8uX1dKhvZ+JY89SZEHtvBRJY0mX6m5ikPsDrYGPxXbPpYcM2yPPYUL2EEfDT/Lp2iN6RD3uc7yKQib4lgV7Kk1tn17WfdWsnx3d/CWShrlU7OpYeQ+D+3bSitCTuiEkbRGt492SZNlV1nnNoZc9yb53ln7/xIndcKIrtLLynKrdnG+ruS29LaGkHUP5dlK/qfcx2VRqOBAWiPcVZZJj2OV3PbEfLR3fRaMfFK3qkDlbz7Fgwna5xSHlypZ5s7Z1EWt0Q9hmx7Qrsk6E5d4hiOQRruLVjTW+aSS21+fTV3UCkVyWW+pO9+qAGcojX+X77Bl/h/mo2vl9sz34GzqRjlJMz+G0QrfqqL1c+WyopTbcqla4Myk8ad4bCPXsb6skHRlvk3HglrRWl5nplO01nmjknlcTxvOzKZdvK7Mt21xe6uyy3q7tl0OODPt6pabtF7N87Op7exSsJYDsFIKRHpOL86mVtunkGR+vywC9Kr7vbhVV19ovasMd5He2/X5KEC/UpRWHaNqxWxXz1SyvvtnUwA9WncAfp/eVfNC5Z35KEB/1p3/tE/vCmBwChawFdf4Bo7GFAvWc4shwORk9697Jc11B+KBMzeVHlb3J6/aT1IBTM5yjyrjdguBSWo/A9boXQGTpmABGzmtATgaUypY3yyGAJPWDrw/sBgCXNA9neDQuoVqSo8LmIgp7RJ+vhgCHIV9frcQ4GAULGAlpzUAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABwo2vX/gO1UuVd1+ULSgAAAABJRU5ErkJggg==

 

 I get Error:

Value cannot be null.

Parameter name: key

 

 

Que
Top achievements
Rank 1
 answered on 12 Dec 2015
7 answers
129 views

I have read the documentation end to end and I have no idea how to use the Reporting tool.  Maybe my application is not a good fit for this tool.  Let me describe what I am trying to do.

 

I have a C#/MVC web application that simulates a report designer. The user can pick Key Performance Indicators (KPIs) from a list and save the report.  Then I would like to use the Telerik.Reporting to display a report based on these dynamic KPIs.  Then each value on the report is clickable to drill into a different view of the report.

 

I have been searching through all the documentation and I keep seeing references to use the ReportDesigner in Visual Studio which I don't want to do since each report is dynamic to the number and types of KPIs.

 

Am I looking at this wrong?

Stef
Telerik team
 answered on 11 Dec 2015
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?