Telerik Forums
Reporting Forum
7 answers
311 views
I have a Telerik report that I'm exporting to Excel. My TextBox has a padding-left set, and in the designer it looks good (the text in the TextBox is indented). But when I export the report to Excel, the indenting goes away. How can I get the Excel report to indent the text in the cell?
Steven
Top achievements
Rank 1
 answered on 05 Feb 2013
1 answer
118 views
Hi,

I have MVC4 application with a partial view that contains ReportViewer control. When I viewed a page on IPad2 (iOS 6.1) the report content did not render. Report viewer showed toolbar with correct page numbers and all buttons, but the styling was lost. When I tried to export the report to PDF (worked just fine) or tried to print (worked too), and then when I used back button to return back to the report page, I was getting this error:

NullReferenceException
Object reference not set to an instance of an object. at Telerik.ReportViewer.WebForms.ViewerState.get_CurrentPage() at Telerik.ReportViewer.WebForms.ReportPageOperation.RenderReport(String format, IList`1 processingReports, Hashtable deviceInfo, IRenderingContext renderingContext) at Telerik.ReportViewer.WebForms.ReportRenderOperation.PerformOperationOverride() at Telerik.ReportViewer.WebForms.BasicHandler.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) 
https://***/Telerik.ReportViewer.axd?instanceID=86efca68bccf4a05b646716ff2110e00&optype=Report&PageIndex=0&RenderID=8ce444b8b34a41ecbd219ae649ac1674&RenderingFormat=HTML

Here is the content of the aspx page:
<%@ Page Language="C#" Inherits="System.Web.Mvc.ViewPage<Telerik.Reporting.ReportSource>" %>
 
<%@ Register Assembly="Telerik.ReportViewer.WebForms, Version=6.2.13.110, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" Namespace="Telerik.ReportViewer.WebForms" TagPrefix="telerik" %>
<%@ Register Assembly="Telerik.Reporting, Version=6.2.13.110, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" Namespace="Telerik.Reporting" TagPrefix="telerik" %>
  
<!DOCTYPE html>
<html>
    <head>
        <%--<link rel="stylesheet"
            type="text/css"
            href="/Telerik.ReportViewer.axd?optype=Resource&version=6.2.13.110&name=Skins.Metro.ReportViewer.css">--%>
    </head>
    <body>
        <script runat="server">
            public override void VerifyRenderingInServerForm(Control control)
            {
                // to avoid the server form (<form runat="server"> requirement
            }
          
            protected override void OnLoad(EventArgs e)
            {
                base.OnLoad(e);
                EReportViewer.ReportSource = Model;
            }
  
        </script>
        <form id="main" method="post" action="">
            <div id="repcontent">
                <telerik:ReportViewer ID="EReportViewer" Width="100%" Height="750"
                    runat="server"
                    Font-Names="Segoe UI" Font-Size="Small"
                    ShowHistoryButtons="false"
                    ZoomMode="FullPage"
                    DocumentMapVisible="false"
                    ParametersAreaVisible="false"
                    ShowParametersButton="false"
                    ShowRefreshButton="false"
                    ProgressText="Generating report"
                    ViewMode="PrintPreview" 
                    EnableViewState="false"
                    >
                </telerik:ReportViewer>
            </div>
        </form>
    </body>
</html>

The same page worked fine on my PC using any browser. The report content is displayed and control's formatting was kept.

Thanks for your help.

Steve
Telerik team
 answered on 05 Feb 2013
6 answers
107 views
Hi,
 
I am using the silverlight report viewer from Telerik Reporting Q2 2012 with Visual Studio 2010 and the problem apears when trying to export.  After the report is rendered in the report viewer, when selecting any option from the export drop down box, its content icon is replaced by the export type name and the export process does't start.
Could you please advise regarding this behavior or suggest a solution?
Thank you.

Regards,
Cristian 
Kriztine
Top achievements
Rank 1
 answered on 04 Feb 2013
3 answers
958 views
I have created a report in the standalone designer and it previews just fine.  When I try to display the report on an ..aspx web page in a Visual Studio 2012 web application, I receive errors on every item on the report viewer (all buttons and the ReportViewer itself).

I have attached a screen capture of the displayed page + the error dialog box (DisplayedPage1.png).  I have also attached a screen capture of the actual javascript error line (DisplayedPage2.png), and a screen capture of the Visual Studio project including the .aspx html page.  There is no code at all in the code-behind file.  I have also attached the Fiddler screen capture which shows that nothing related to the Report Viewer is found when the page is displayed.

The web.config file source code is included below.  The report uses the AdventureWorks database and produces a simple listing of the products in the database.

This is my first attempt at using Telerik Reporting, so I've probably done something stupid, but I need some help, please and thank you.  

Lynn

<?xml version="1.0"?>
<configuration>
  <appSettings>
    <add key="Telerik.Skin" value="Metro"/>
    <add key="Telerik.ScriptManager.TelerikCdn" value="Disabled"/>
    <add key="Telerik.StyleSheetManager.TelerikCdn" value="Disabled"/>
  </appSettings>
  <system.web>
    <compilation debug="false" targetFramework="4.5">
      <assemblies>
        <add assembly="Microsoft.ReportViewer.WebForms, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845DCD8080CC91"/>
        <add assembly="Microsoft.ReportViewer.Common, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845DCD8080CC91"/>
        <add assembly="Microsoft.Build.Framework, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
        <add assembly="Telerik.Reporting, Version=6.2.13.110, Culture=neutral, PublicKeyToken=a9d7983dfcc261be"/>
      </assemblies>
    </compilation>
    <httpRuntime targetFramework="4.5"/>
    <pages>
      <controls>
        <add tagPrefix="telerik" namespace="Telerik.Web.UI" assembly="Telerik.Web.UI"/>
      </controls>
    </pages>
    <httpHandlers>
      <add path="ChartImage.axd" type="Telerik.Web.UI.ChartHttpHandler" verb="*" validate="false"/>
      <add path="Telerik.Web.UI.SpellCheckHandler.axd" type="Telerik.Web.UI.SpellCheckHandler" verb="*" validate="false"/>
      <add path="Telerik.Web.UI.DialogHandler.aspx" type="Telerik.Web.UI.DialogHandler" verb="*" validate="false"/>
      <add path="Telerik.RadUploadProgressHandler.ashx" type="Telerik.Web.UI.RadUploadProgressHandler" verb="*" validate="false"/>
      <add path="Telerik.Web.UI.WebResource.axd" type="Telerik.Web.UI.WebResource" verb="*" validate="false"/>
      <add path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=x.x.x.x, Culture=neutral, PublicKeyToken=a9d7983dfcc261be"/>
    </httpHandlers>
    <httpModules>
      <add name="RadUploadModule" type="Telerik.Web.UI.RadUploadHttpModule"/>
      <add name="RadCompression" type="Telerik.Web.UI.RadCompression"/>
    </httpModules>
  </system.web>
  <system.webServer>
    <modules runAllManagedModulesForAllRequests="true">
      <remove name="RadUploadModule"/>
      <add name="RadUploadModule" type="Telerik.Web.UI.RadUploadHttpModule" preCondition="integratedMode"/>
      <remove name="RadCompression"/>
      <add name="RadCompression" type="Telerik.Web.UI.RadCompression" preCondition="integratedMode"/>
    </modules>
    <handlers>
      <remove name="ChartImage_axd"/>
      <add name="ChartImage_axd" path="ChartImage.axd" type="Telerik.Web.UI.ChartHttpHandler" verb="*" preCondition="integratedMode"/>
      <remove name="Telerik_Web_UI_SpellCheckHandler_axd"/>
      <add name="Telerik_Web_UI_SpellCheckHandler_axd" path="Telerik.Web.UI.SpellCheckHandler.axd" type="Telerik.Web.UI.SpellCheckHandler" verb="*" preCondition="integratedMode"/>
      <remove name="Telerik_Web_UI_DialogHandler_aspx"/>
      <add name="Telerik_Web_UI_DialogHandler_aspx" path="Telerik.Web.UI.DialogHandler.aspx" type="Telerik.Web.UI.DialogHandler" verb="*" preCondition="integratedMode"/>
      <remove name="Telerik_RadUploadProgressHandler_ashx"/>
      <add name="Telerik_RadUploadProgressHandler_ashx" path="Telerik.RadUploadProgressHandler.ashx" type="Telerik.Web.UI.RadUploadProgressHandler" verb="*" preCondition="integratedMode"/>
      <remove name="Telerik_Web_UI_WebResource_axd"/>
      <add name="Telerik_Web_UI_WebResource_axd" path="Telerik.Web.UI.WebResource.axd" type="Telerik.Web.UI.WebResource" verb="*" preCondition="integratedMode"/>
      <add name="Telerik.ReportViewer.axd_*" path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=x.x.x.x, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" preCondition="integratedMode"/>
    </handlers>
    <validation validateIntegratedModeConfiguration="false"/>
  </system.webServer>
</configuration>
Stef
Telerik team
 answered on 04 Feb 2013
3 answers
224 views
I see from some of the posts here that Telerik has a PDF Viewer available for the latest release of SilverLight and WPF. Does anyone know if this feature is available in Telerik Reporting or if there are any plans of adding this feature.
Thanks.
Steve
Telerik team
 answered on 04 Feb 2013
4 answers
362 views
Seeing this error. I fall back to an earlier version of my report which doesn't do this, make  a few changes, and I see this again. Any help would be appreciated.

An error has occurred while rendering the report: System.NullReferenceException: Object reference not set to an instance of an object.
   at Telerik.Reporting.Processing.Table.ForEachCell(Action`1 action)
   at Telerik.Reporting.Processing.Table.MeasureContent(IMeasureContext context, SizeRF availableClientSize)
   at Telerik.Reporting.Processing.VisualElement.MeasureOverride(IMeasureContext context, SizeRF availableSize)
   at Telerik.Reporting.Processing.ProcessingElement.MeasureOverride(IMeasureContext context, SizeRF availableSize)
   at Telerik.Reporting.Processing.AbsolutePositionLayout.MeasureChildItems(IMeasureContext context, SizeRF availableClientSize)
   at Telerik.Reporting.Processing.AbsolutePositionLayout.MeasureContent(IMeasureContext context, SizeRF availableClientSize)
   at Telerik.Reporting.Processing.ReportSectionBase.MeasureContent(IMeasureContext context, SizeRF availableClientSize)
   at Telerik.Reporting.Processing.VisualElement.MeasureOverride(IMeasureContext context, SizeRF availableSize)
   at Telerik.Reporting.Processing.ProcessingElement.MeasureOverride(IMeasureContext context, SizeRF availableSize)
   at Telerik.Reporting.Processing.StackLayout.MeasureContent(IMeasureContext context, SizeRF availableClientSize)
   at Telerik.Reporting.Processing.Group.MeasureContent(IMeasureContext context, SizeRF availableClientSize)
   at Telerik.Reporting.Processing.VisualElement.MeasureOverride(IMeasureContext context, SizeRF availableSize)
   at Telerik.Reporting.Processing.ProcessingElement.MeasureOverride(IMeasureContext context, SizeRF availableSize)
   at Telerik.Reporting.Processing.StackLayout.MeasureContent(IMeasureContext context, SizeRF availableClientSize)
   at Telerik.Reporting.Processing.Report.MeasureContent(IMeasureContext context, SizeRF availableClientSize)
   at Telerik.Reporting.Processing.VisualElement.MeasureOverride(IMeasureContext context, SizeRF availableSize)
   at Telerik.Reporting.Processing.ProcessingElement.MeasureOverride(IMeasureContext context, SizeRF availableSize)
   at Telerik.Reporting.Processing.LayoutElement.MeasureElement(LayoutElement elementToMeasure, IMeasureContext context)
   at Telerik.Reporting.XamlRendering.SilverlightReportInteractive.MeasureReportCore(Report report, IMeasureContext measureContext)
   at Telerik.Reporting.BaseRendering.RenderingExtensionBase.Render(Report report, Hashtable renderingContext, Hashtable deviceInfo, CreateStream createStreamCallback, EvaluateHeaderFooterExpressions evalHeaderFooterCallback)
Steven
Top achievements
Rank 1
 answered on 02 Feb 2013
1 answer
192 views
Hi,

i am very new to telerik reporting, i need to develop a bar chart, based on the data from datatable.
my datatable design.

 

DataTable

 

 

dtStudent = new DataTable();

 

dtStudent.Columns.Add(

 

"Date", typeof(DateTime));

 

dtStudent.Columns.Add(

 

"Group", typeof(string));

 

dtStudent.Columns.Add(

 

"Score", typeof(double));


//data

 

dtStudent.Rows.Add(

 

"2013-01-12", "Drawing", 25.0);

 

dtStudent.Rows.Add(

 

"2013-01-12", "Music", 10.0);

 

 

 

//date2

 

 

 

 

 

dtStudent.Rows.Add(

 

"2013-01-13", "Drawing", 30.0);

 

dtStudent.Rows.Add(

 

"2013-01-13", "Music", 11.0);

 

 

 

//date3

 

 

 

 

 

dtStudent.Rows.Add(

 

"2013-01-14", "Drawing", 28.0);

 

dtStudent.Rows.Add(

 

"2013-01-11", "Dance", 40.0);

i need to display the chart as match as the attachment file Bar chart.

if any one help me with example will be very helpfull for me.

Thanks in advance..

 

Elian
Telerik team
 answered on 01 Feb 2013
1 answer
104 views
Hello,
i tried to set the report's datasource,going on ReportSource property,a dialog appeared where i choosed the type
and chose from "Select a report Type" and a blank window in dialog mode appear,and i couldn't do anything from that point on.i had to close Visual Studio.
I attached a screenshot.Is this an error,or some wrong operation on reports?!

P.S:i used the Reporting Q3 2012
Stef
Telerik team
 answered on 01 Feb 2013
4 answers
382 views
Hi all,
I have a hierarchical data structure and I am using a sub report with object data source to recursively iterate over it. 
In all the leaf nodes I have a value that I would like to aggregate in a bottom up manner and display the running aggregate at each level.  Aggregating the values outside of the report is not an option at the moment.

Basically, it boils down to passing values from all the subreports up to the parent report.
I am still new to Telerik so some pointers / techniques/patterns would be highly appreciated 

Report should look like this in the end

(root) 12
    (A1) 3
      (B1) 1      // leaf
      (B2) 2      // leaf
   (A2)  9 
     (C1) 6
        (D1) 4
           (E1) 1 // leaf
           (E2) 3 // leaf
         (D2) 2   // leaf
    (C2) 3        // leaf
etc...

Greetings.
Stef
Telerik team
 answered on 01 Feb 2013
1 answer
216 views
I have created a report and added a table to the detail section.
I have set the sql datasource of this table at design time. The sql data source is dynamic and can return a different number of columns at run time.
I would like to be able to get (or convert) the sqldatasource into a datatable at run time so I can identify the number of columns and column names returned by the datasource and build the table dynamically.
I have managed to build a dynamic table but I cannot figure out how to convert or access the sql datasources dataset/datatable/rawdata. How do I do this? is it even possible?

Thanks in advance.
Hadib Ahmabi
Top achievements
Rank 1
 answered on 01 Feb 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?