Telerik Forums
Reporting Forum
1 answer
113 views
Hi,

I have 2 questions regarding excel reporting:

1. Is it possible to use XLSX rendering with Right-To-Left layout?

2. Is it possible to keep excel cells border as default (Width=1) for the whole sheet?

Thanks,
Asaf.
Nasko
Telerik team
 answered on 15 Jul 2014
1 answer
83 views
We have a client/server solution, and our client software is Winforms.  Our client-side does not have access to the database server, but it communicates to our server through our own home-rolled rpc services (ip and/or http communication).  

We have a partially implemented solution where our server software runs the sql and sends it back to the client as a datatable, along with the Telerik report definition.  Our client software puts these two pieces together, and displays the resulting Telerik report in a ReportViewer.

This works fine, except we want to utilize Telerik reports where report parameter tokens are embedded into the sql statements, e.g. "SELECT * FROM TableA WHERE FieldA = @parameterA".  This does not work with our current solution, as our server does not have the parameter values to inject into the sql, because at that point, the ReportViewer on the client side has not yet allowed the user to select parameter values.

What approach would you recommend to resolve this?  Continue with our solution and somehow send the user's parameter values to the server before the ReportViewer attempts to display the report (i.e. right as the user clicks the "Preview" button)?  It seems like we are re-inventing the wheel.

Or use Telerik Reporting Services (REST or WCF), and scrap our current approach?  I'm not sure I know what flavour of Telerik Reporting Services would be most appropriate in our situation, or if is the proper approach at all.

Thanks,
Eric.
Stef
Telerik team
 answered on 15 Jul 2014
3 answers
132 views
I have a certificate that is generated using Telerik Reporting. It has been working as expected for years. No changes have been made to the certificate.  All of the sudden in the past month the certificate started generating an error "An error has occurred while processing TextBox 'txtMyTextBox': The expression contains undefined function call".

I've dealt with this type of error in the past during development. Thought it was odd to happen out of the blue. Rebuilt the dll (with no changes to the code). Plopped the dll into the bin folder. Started working again, lasting several days. Then it occurred again so I recycled the application pool. Worked again for almost 2 weeks.

I've searched all the usual spots for a solution to this issue with no results. No other issues/errors are happening on the site.

What could be causing this? More importantly, how do I fix it?

Using Telerik Reporting version 4.2.10.1221

Thanks!
Stef
Telerik team
 answered on 15 Jul 2014
4 answers
509 views
Hi,

I am using Reporting Q3 2013. I am using a crosstab which has one column group and three row groups. My issue is that due to the level of grouping, the main row group may extend to different pages, vertically. I want to be able to repeat certain rows from the group on each page. The RowHeadersPrintOnEveryPage property does not help me as it only repeats the left column if the report expands horizontally, and ColumnHeadersPrintOnEveryPage will repeat vertically, but only column values, nothing related to the row values. I aslo tried to add row values to column header, but it will only repeat the first value, as expected.

Thanks
Hinata
Top achievements
Rank 1
 answered on 15 Jul 2014
1 answer
112 views
I am trying to create a report with a Map . Something similar to the Sales By Region example supplied . Except my data has a zipcode instead of state . 

How do I use the zip code to display my points on the map . 

Setting the geoLocationMapGroup to the zipcode field does not seem to do it . 

Can you please help. 

Ivan Hristov
Telerik team
 answered on 15 Jul 2014
1 answer
104 views
I have downloaded telerik report demo and followed the instructions to implement it through it's video demo but I am unable to view report,it's not showing report while if I preview then it displaying report,and also it's not showing images,pls help me to resolve this.

I had referred below demo link.
http://blogs.telerik.com/careypayette/posts/13-03-26/telerik-reporting-in-mvc-sure-it-takes-8-quick-steps-
Nasko
Telerik team
 answered on 15 Jul 2014
3 answers
367 views
Hi there, I've just recently purchased reporting, and am trying to get it up and running on our production website. I have run into a problem with the drilldown action on my first crosstab report - the PUT is generating a 401 error, though I'm not clear on why that would be. I am using Forms authentication for the website, and everything works well on the local development server. The only other wrinkle is that the application is that there are some URL Rewrite rules in effect to properly route traffic to the site, but it appears that the PUT URL is correct.

I haven't been able to find anything on the forums indicating others with this problem - but I thought I'd ask. Has anyone else experienced this or have any ideas on what might be amiss?

Thanks!
Brandon
Top achievements
Rank 1
 answered on 14 Jul 2014
1 answer
78 views
Hi

I am using Telerik Reporting  Q3 2011

On browser versions earlier than firefox 30,Chrome 35.0  and IE 11 the print button works fine on Firefox 30. now when i click the print button the page refreshes and nothing happens, same with IE11, on chrome i get an error message "Unable to perform print operation" is there any way i can resolve this issue?
Stef
Telerik team
 answered on 14 Jul 2014
1 answer
90 views
im new in telerik report. my project is, i want webapi call Report Library that i created using telerik VS report designer). after follow the demo, i success for calling standalone report. but now i want to call from report library

.here is my code

in view
@( Html.TelerikReporting().ReportViewer()
.Id("reportViewer1")
 .TemplateUrl("/ReportViewer/templates/telerikReportViewerTemplate.html")
.ReportSource(new UriReportSource() { Uri = "User.trdx" })
.ViewMode(ViewModes.INTERACTIVE)
.ScaleMode(ScaleModes.SPECIFIC)
.Scale(1.0) )


in web api
public class Reports1Controller : ReportsControllerBase
{
    protected override IReportResolver CreateReportResolver()
    {
        var appPath = HttpContext.Current.Server.MapPath("~/Reports");
 
        return new ReportFileResolver(appPath)
            .AddFallbackResolver(new ReportTypeResolver());
    }
 
    protected override ICache CreateCache()
    {
        return CacheFactory.CreateFileCache();
    }
}

i have create a Project for ReportLibrary and class UserReport.cs using VS ReportDesigner. i need to call UserReport in WebApi or View? and how to call?

firstly i need to change

.ReportSource(new UriReportSource() { Uri = "User.trdx" }

to 
.ReportSource(new TypeReportSource() { TypeName ="Class1.User, Class" })

how about in ReportsController?

i no need to use ReportFileResolver right?

thank you so much
Nasko
Telerik team
 answered on 11 Jul 2014
1 answer
179 views
I've recently began updating one of our projects from Reporting Q1 2013 (7.2.14.127) to Q2 2014 (8.1.14.618), but have ran into the problem of trying to pass a model to an objectdatasource.  Previously, I used 8 Easy Steps to display the ReportViewer using .aspx and would use an InstanceReportSource to render the report:

aspx View
<%@ Page Language="C#" Inherits="System.Web.Mvc.ViewPage<MyProject.Models.MyModel>" %>
 
protected override void OnLoad(EventArgs e)
    {
        base.OnLoad(e);
        var instanceReportSource = new InstanceReportSource();
  
        Report report = new Report1(Model);
  
        instanceReportSource.ReportDocument = report;
  
        ReportViewer1.ReportSource = instanceReportSource;
        ReportViewer1.ViewMode = ViewMode.Interactive;
    }

Report class:
using MyProject.Models;
 
namespace Admissions.Reports
{
    using Telerik.Reporting;
  
    public partial class Report1 : Report
    {
        public Report1()
        {
            InitializeComponent();
        }
  
        public Report1(MyModel model) : this()
        {
            DataSource = model;
        }
    }
}

With the new version of Telerik Reporting, InstanceReportSource is obsolete when using the new razor syntax to generate the report so we
have to use UriReportSource or TypeReportSource.
I've tried to use a custom report resolver (example at bottom of OP (Missing Report Name), and was able to pass data in using InstanceReportSource, but I wasn't able to attach any report parameters since the Model is being populated inside of the resolver (which I'd prefer not to do) and the report is created in the resolver and not actually using any parameters from the view.

.cshtml view
@{
    var uriRS = new UriReportSource() { Uri = "1"};
}
@(
Html.TelerikReporting().ReportViewer().Id("reportViewer1")
   .ServiceUrl("/api/reports/")
   .TemplateUrl("/Content/ReportViewer/templates/telerikReportViewerTemplate.html")
        .ReportSource(uriRS)
        .ViewMode(ViewModes.INTERACTIVE)
        .ScaleMode(ScaleModes.SPECIFIC)
        .Scale(1.0)
        .PersistSession(false)
      )

Report Resolver
namespace Admissions.Controllers
{
    public class ReportsController : ReportsControllerBase
    {
        protected override ICache CreateCache()
        {
            return Telerik.Reporting.Services.Engine.CacheFactory.CreateFileCache();
        }
  
        protected override IReportResolver CreateReportResolver()
        {
            return new CustomReportResolver();
        }
    }
  
    public class CustomReportResolver : IReportResolver
    {
        public ReportSource Resolve(string reportId)
        {
            var report = new Report();
  
            report = new Report1(new DashboardViewModel { TotalRolesCount = "Hello Report World" });
  
            var irs = new InstanceReportSource { ReportDocument = report };
  
            return irs;
        }
    }
}

Has anyone found a way to pass the Model directly into the report, (var report = new Report1(Model) ); or a solution that would work equally well?
Stef
Telerik team
 answered on 11 Jul 2014
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?