Telerik Forums
Reporting Forum
1 answer
429 views
I have built a simple report with one group, where the data output looks something like this:
C1  C2     C3   C4
AAA Blue       
        5   10
        6   20
AAA Yellow     
        2   10
             
BBB Green      
        3   20

I need to change the format (preferably into a table) where the first line of the detail is on the same line as the group.  I need to do this because most of the time, there will only be one detail line per group. So it should look more like this:
C1  C2     C3   C4
AAA Blue    5  10
         6  20
             
AAA Yellow  2  10
             
BBB  Green  3  20
 
My existing group and detail insist on being on different lines. I suspect the way to do it has to do with adjacent left or right groups in a table, but I can't figure out how to make it work.
Stef
Telerik team
 answered on 06 Feb 2013
6 answers
246 views

Hi,

Couple of issues.

I installed reporting using and upgraded the project using the wizard.

When I try to open a report in design mode I get the problem shown in capture2.jpg which is trying to find a prior versioned dll.

Also one of reports has parameters that the viewer prompts for at runtime. the report will take the parameter but the following code that has always run in the past no longer runs:

private void RptADASummary_ItemDataBinding(object sender, EventArgs e)
 {
     if (txtStartDate.Value == string.Empty)
     {
         SchoolMonth _schoolMonth = SchoolMonthService.GetByID(Int32.Parse(this.ReportParameters["SchoolMonthID"].Value.ToString()));
         txtMonthNumber.Value = _schoolMonth.SchoolMonthNumber.ToString();
         txtStartDate.Value = _schoolMonth.StartDate.ToShortDateString();
         txtEndDate.Value = _schoolMonth.EndDate.ToShortDateString();
     }
 }

specifically it says the "this.ReportParameters["SchoolMonthID"].Value" is null.  This code has always compliled and run fine until the most recent upgrade.  has anything changed how one can access parameters in the report? If I take out the contents of this function, the report runs fine but is missing the text boxes.  see capture1.jpg

Thanks,

Jonathan
Khalid
Top achievements
Rank 1
 answered on 05 Feb 2013
0 answers
158 views

Is there a way to initially toggle visibility conditionally? I have a report that a grouping toggles the detail visibility, Everything works fine I can either have the report completely expanded, everything visible, or I can have the report open with all the Details section invisible. What I would like would be for the report to open with only one specified grouping already expanded while the other are still invisible, and then have the toggle function normally after that. Is this possible, I have played with the conditional formatting but whatever I have the detail section visibility section set to over rides the conditional, and once the conditional is set the toggle will no longer properly work.

Eric Klein
Top achievements
Rank 1
 asked on 05 Feb 2013
7 answers
332 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
123 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
122 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
997 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
242 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
375 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
206 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
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
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?