Telerik Forums
Reporting Forum
1 answer
205 views
Hi Friends,

I have created a Telerik Report using ( Q1 2013 - 7.0.13.426 ) in Visual Studio 2012 with MVC4 Application using .NET 4.5 Framework.

The Report Viewer loads it self, but it didn't render the report, and when ever I click on any button within Report viewer it popup the Alert box, with that command name. But it is not displaying any thing in report.

here is the html mark-up code for Report viewer

<%@ Control Language="C#" Inherits="System.Web.Mvc.ViewUserControl<dynamic>" %>
<%@ Import Namespace="PaceSoftware.Models" %>
<%@ Register Assembly="Telerik.ReportViewer.WebForms, Version=7.0.13.426, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" Namespace="Telerik.ReportViewer.WebForms" TagPrefix="telerik" %>
<!DOCTYPE html>
<script runat="server">
 
    protected void Page_Load(object sender, EventArgs e)
    { }
     protected override void OnLoad(EventArgs e)
    {
        base.OnLoad(e);
        Telerik.Reporting.Report rpt = new PaceSoftware.Reports.CustomerReport();
        rptCustomerReport.ReportSource = rpt;
    }
</script>
 
<html>
<head id="Head1" runat="server">
    <title>Balance Report</title>
</head>
<body>
    <form id="form1" method="post" runat="server">
        <div align="center" style="height: 1400px">
            <table class="NoBorderTables" style="width: 100%">
                <tr>
                    <td>
 
<telerik:ReportViewer ID="rptCustomerReport" runat="server" Width="100%" Height="1300px"
   ViewMode="PrintPreview"  Report="PaceSoftware.Reports.CustomerReport, PaceSoftware">
</telerik:ReportViewer>
 
                    </td>
                </tr>
            </table>
        </div>
    </form>
</body>
</html>


I have also tried to use the following Code, But no LUCK :-(

<%@ Control Language="C#" Inherits="System.Web.Mvc.ViewUserControl<dynamic>" %>
 
 
<%@ Register Assembly="Telerik.ReportViewer.WebForms, Version=7.0.13.426, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" Namespace="Telerik.ReportViewer.WebForms" TagPrefix="telerik" %>
<!DOCTYPE html>
<script runat="server">
 
    protected void Page_Load(object sender, EventArgs e)
    {
 
    }
 
    protected override void OnLoad(EventArgs e)
    {
        base.OnLoad(e);
 
         
    }
     
</script>
 
<html>
<head id="Head1" runat="server">
    <title>Balance Report</title>
</head>
<body>
    <form id="form1" runat="server">
        <div align="center" style="height: 1400px">
            <table class="NoBorderTables" style="width: 100%">
                <tr>
                    <td>
 
                        <telerik:ReportViewer ID="rptCustomerReport" runat="server" Width="100%" Height="1300px" ViewMode="PrintPreview">
<typereportsource typename="PaceSoftware.Reports.CustomerReport, PaceSoftware, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null"></typereportsource>
                        </telerik:ReportViewer>
 
 
                    </td>
                </tr>
            </table>
        </div>
    </form>
</body>
</html>

both the above codes didn't throw any error, that's why it becomes very difficult to know either what is happening....!!!

It just display the white sheet of report nothing in it, and when ever I click on any button of the report it display the alert box, with the command name in it... 

I have also attached the screen shot.

Please help me to solve this issue...

Many Thanks.
USMAN
Top achievements
Rank 1
 answered on 31 May 2013
1 answer
149 views
Hi all,
I see a lot of excel export threads but none that covers my dilemma.
I am using Reporting Q1 2013 and when exporting a report into excel the result is jumbled. Columns are hidden and I am unable to sort the resulting excel file.
This happens to all reports that I try and export. 


Thanks for any help,
Andy
IvanY
Telerik team
 answered on 31 May 2013
17 answers
630 views
Hello,

Am very new to Telerik software and so I need your help please. I have a project to create different reports using telerik reporting but all I am given is the MsSql stored procedure codes from an existing database. When I look read the telerik reporting tutorial, it shows steps on how to populate and assign datasource and to drag and drop the fields from a table into the detail section of the designer (middle section) of the tab. But when using stored procedure codes, there are no actual table to drag and drop just codes to carry out a command when data is put on the front-end (website). How can this code be added to the report? Thanks!
Stef
Telerik team
 answered on 31 May 2013
2 answers
262 views
I have configured my Telerik Reporting to use cache provider = File and everything is working just fine.
I notice that that the report files is generated in a sub folder with a name that looks something like a guid, but I can't find anything in the documentation that verifies this assumption.

Since I run several customer on the same web-server, using the same web.config, and there for the came cache directory, I'm a little bit nervous that a customer possible could get another customers data.

Can someone verify that the generated name for the sub folder created is a guid?

Regards
 - Peter
Peter
Top achievements
Rank 1
 answered on 31 May 2013
12 answers
682 views
I am considering giving some users the stand alone designer so they can make some of their own reports.  I know one question that will be asked, "if we make a report we like, how do we get it in our web site?"  In other words, they prototype reports and play around with them.  When they get one they like a lot, they would want me to put it in the VS project so they can view it in the main web site.

So, the report designer saves to a .trdx file.  But the project files are code (vb or cs).  So how to do the import?  I would have expected an "Import trdx file" in the VS Telerik Reporting menu.  Am I missing something? 

Thanks.
Stef
Telerik team
 answered on 31 May 2013
1 answer
683 views
Hi Telerik,

Is it possible to have a single textbox display formatted values for multiple data fields? Specifically my issue is I want to display a date interval in the same textbox where the start and end dates are in two individual datafields of type DateTime, like so:

"01/01/2001 - 07/01/2001"

I want to utilize the localization and formatting capabilities of having the dates as DateTime types and therefore combining them in codebehind as a string is not an option for me, then I would rather have two separate textboxes - BUT having two separate textbox then present me with the problem of proper displaying in the report if the formatting changes (longer or shorter datetime string).

I was trying to do something like this:

=Format("{0:d}, {1:d}", Fields.FirstDistributionDate, Fields.LastDistributionDate)

Thanks in advance,

Best regards,
Kasper Schou
Peter
Telerik team
 answered on 31 May 2013
10 answers
189 views
Just wondering is there any example of the wcf self hosting, running windows system serivce

cheers
Stef
Telerik team
 answered on 31 May 2013
0 answers
330 views
Hi,

I'm using Telerik Reporting Q1 2013 and I have a report which contains a subreport which I have been able to export to HTML, PDF, CSV, etc., etc., programmatically, but it throws an exception when attempting to export to Excel (XLS/XLSX).  I can export a different report that I have (which contains no subreport) to all formats (including Excel) without any exceptions.  As far as I can tell, the only real difference between the two is the subreport.

I get a Null Reference Exception when calling the RenderReport method of the ReportProcessor class.  Here's the stack trace:

{"Message":"An error has occurred.","ExceptionMessage":"Object reference not set to an instance of an object.","ExceptionType":"System.NullReferenceException","StackTrace":" at Telerik.Reporting.ExcelRendering.RenderingItem.Render(IWorksheet worksheet, TableLayoutInfo layoutInfo)\r\n at Telerik.Reporting.ExcelRendering.RenderingItemContainer.RenderInternal(IWorksheet worksheet, TableLayoutInfo layoutInfo)\r\n at Telerik.Reporting.ExcelRendering.Table.RenderInternal(IWorksheet worksheet, TableLayoutInfo layoutInfo)\r\n at Telerik.Reporting.ExcelRendering.RenderingItem.Render(IWorksheet worksheet, TableLayoutInfo layoutInfo)\r\n at Telerik.Reporting.ExcelRendering.RenderingItemContainer.RenderInternal(IWorksheet worksheet, TableLayoutInfo layoutInfo)\r\n at Telerik.Reporting.ExcelRendering.Section.RenderInternal(IWorksheet worksheet, TableLayoutInfo layoutInfo)\r\n at Telerik.Reporting.ExcelRendering.RenderingItem.Render(IWorksheet worksheet, TableLayoutInfo layoutInfo)\r\n at Telerik.Reporting.ExcelRendering.Group.RenderInternal(IWorksheet worksheet, TableLayoutInfo layoutInfo)\r\n at Telerik.Reporting.ExcelRendering.RenderingItem.Render(IWorksheet worksheet, TableLayoutInfo layoutInfo)\r\n at Telerik.Reporting.ExcelRendering.RenderingItemContainer.RenderInternal(IWorksheet worksheet, TableLayoutInfo layoutInfo)\r\n at Telerik.Reporting.ExcelRendering.Report.RenderInternal(IWorksheet worksheet, TableLayoutInfo layoutInfo)\r\n at Telerik.Reporting.ExcelRendering.RenderingItem.Render(IWorksheet worksheet, TableLayoutInfo layoutInfo)\r\n at Telerik.Reporting.ExcelRendering.Report.Render(IWorkbook workbook)\r\n at Telerik.Reporting.ExcelRendering.Excel97.ExcelReport.Telerik.Reporting.Processing.IRenderingExtension.Render(Report report, Hashtable renderingContext, Hashtable deviceInfo, CreateStream createStreamCallback, EvaluateHeaderFooterExpressions evalHeaderFooterCallback)\r\n at Telerik.Reporting.Processing.ReportProcessor.RenderCore(ExtensionInfo extensionInfo, IList`1 reports, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback)\r\n at Telerik.Reporting.Processing.ReportProcessor.ProcessAndRender(String format, ReportSource reportSource, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback)\r\n at Telerik.Reporting.Processing.ReportProcessor.ProcessAndRenderStateless(String format, ReportSource reportSource, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback)\r\n at Telerik.Reporting.Processing.ReportProcessor.RenderReport(String format, ReportSource reportSource, Hashtable deviceInfo)\r\n at CPSReporting.TelerikCPSReportProcessor.RenderExcelReport(CPSReportDefinition reportDefinition) in c:\\Code\\CPS_SVN_REPO\\CPSReporting\\trunk\\TelerikCPSReportProcessor.cs:line 78\r\n at CreditPoint.Web.Controllers.WebAPI.ReportController.PrepResponse(HttpRequest request) in c:\\Code\\CPS_SVN_REPO\\Web\\branches\\RB-4.6\\Controllers\\WebAPI\\ReportController.cs:line 69\r\n at CreditPoint.Web.Controllers.WebAPI.ReportController.Post() in c:\\Code\\CPS_SVN_REPO\\Web\\branches\\RB-4.6\\Controllers\\WebAPI\\ReportController.cs:line 27\r\n at lambda_method(Closure , Object , Object[] )\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass13.b__c(Object instance, Object[] methodParameters)\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments)\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.<>c__DisplayClass5.b__4()\r\n at System.Threading.Tasks.TaskHelpers.RunSynchronously[TResult](Func`1 func, CancellationToken cancellationToken)"}

I believe the stack trace is the same for both XLS and XLSX device formats.  As I said, this is only happening with one of my reports (which happens to contain a subreport).  All other reports work just fine when exporting to Excel.

Here's the code:

InstanceReportSource instanceReportSource = new InstanceReportSource();
XmlReaderSettings xmlReaderSettings = new XmlReaderSettings();
xmlReaderSettings.IgnoreWhitespace = true;
ReportXmlSerializer serializer = new ReportXmlSerializer();
XmlReader primaryReportXmlReader = XmlReader.Create(reportDefinition.PrimaryReport.TemplateLocation, xmlReaderSettings);
Telerik.Reporting.Report primaryReport = (Telerik.Reporting.Report)serializer.Deserialize(primaryReportXmlReader);
primaryReportXmlReader.Close();
this.SetConnectionStrings(ref primaryReport, reportDefinition.ConnectionString);
instanceReportSource.ReportDocument = primaryReport;
if (reportDefinition.PrimaryReport.ReportParameters != null)
{
    foreach (KeyValuePair<string, object> item in reportDefinition.PrimaryReport.ReportParameters)
        instanceReportSource.Parameters.Add(this.CreateParameter(item.Key, item.Value));
}
foreach (CPSReport cpsSubReport in reportDefinition.SubReports)
{
    XmlReader xmlReader = XmlReader.Create(cpsSubReport.TemplateLocation, xmlReaderSettings);
    Telerik.Reporting.Report subReportInstance = (Telerik.Reporting.Report)serializer.Deserialize(xmlReader);
    xmlReader.Close();               
    this.SetConnectionStrings(ref subReportInstance, reportDefinition.ConnectionString);
    Telerik.Reporting.SubReport subReport = primaryReport.Items.Find(cpsSubReport.ReportName, true).FirstOrDefault() as Telerik.Reporting.SubReport;
    ReportSource subReportSource_Type = subReport.ReportSource;
    InstanceReportSource subReportSource_Instance = new InstanceReportSource();
    subReportSource_Instance.ReportDocument = subReportInstance;
    foreach(Telerik.Reporting.Parameter param in subReportSource_Type.Parameters)
        subReportSource_Instance.Parameters.Add(param);
    subReport.ReportSource = subReportSource_Instance;
}
Hashtable settings = new Hashtable() {
    { "UseNativePageHeader", false },
    { "UseNativePageFooter", true },
    { "ShowGridLines", false }
};
//Exception thrown here:
RenderingResult result = _reportProcessor.RenderReport("XLS", instanceReportSource, settings);
return result.DocumentBytes;

Thank you in advance,
An otherwise extremely happy Telerik user  :)
Adam
Top achievements
Rank 1
 asked on 30 May 2013
3 answers
53 views
Hi ,
    I have web application where i am using 2 reports in the same page , when I access the web application from IPAD safari (IOS6) when a telerik report page opens ,  randomly either the first or the second report will be blank and if I click on next button report loads the next page and then I have to click the previous to see the first page which was blank. im using Telerik Q1 20113 build 7.0.13.412(7.0.13.412) and this is an urgent issue to fix.
Stef
Telerik team
 answered on 30 May 2013
7 answers
393 views
Hi there!

We’ve identified that the reporting component returns verbose error messages with a 200 HTTP status code, making our application vulnerable to XSS attacks. 

Please could you contact us privately, as soon as possible for more details.

Thanks, in advance.
Bill
Top achievements
Rank 1
 answered on 30 May 2013
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
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?