Telerik Forums
Reporting Forum
2 answers
207 views

Followed the advice form this link below but still no luck
http://www.telerik.com/community/forums/reporting/telerik-reporting/how-do-you-programmatically-bind-subreports-in-q2-2012.aspx

Telerik.Reporting.SubReport mySubReport = (Telerik.Reporting.SubReport)oReport.Items.Find("MySubReport", true)[0];

//*** This is working
// this code block loads the data in sub report in this case if i set the subreport as an object Instance

var repSource = (InstanceReportSource)mySubReport.ReportSource;
var subreport = (Telerik.Reporting.Report)repSource.ReportDocument;
var odsItems = (Telerik.Reporting.ObjectDataSource)subreport.DataSource;
subreport.DataSource = objectDataSource;

//*** End

//*** This is not working
// this code block doesn't load the data in sub report in this case if i set the subreport as an XML Source (serialized report using ReportXmlSerializer)
var repSource = (XmlReportSource)kpiActionsSubReport.ReportSource;
Report subreport = TelerikReportHelper.DeSerilizeTelerikReportXML(XElement.Parse(repSource.Xml)); //(deserialized report using ReportXmlSerializer)
subreport.DataSource = objectDataSource;
//*** End

John North
Top achievements
Rank 1
 answered on 27 Oct 2012
2 answers
191 views
Hello,

Currently we are attempting to use the Web Report Viewer in our MVC4 project, and have run into some issues running on the IE9 Browser. When using Chrome or another browser, the viewer renders the report with no issues. Currently the aspx partial view that holds the viewer is being served up by a regular MVC controller.

Here is the error I receive when running the viewer in IE:

Unhandled exception at line 561, column 13 in script block
0x800a138f - Microsoft JScript runtime error: Unable to get value of the property 'ErrorMessage': object is null or undefined

I've searched extensively for a solution to this issue with no luck... someone from the Telerik team please help!

I've also put my code snippets below:

this is coming from the ReportViewer javascript code, where it makes the function call and contentWindow is null:
ReportViewer.prototype.GetError = function ()
{
var paramsArea = document.getElementById(this.paramsFrameID);
var msg = "";
if (paramsArea){ msg = paramsArea.contentWindow.ErrorMessage; }
if (!msg) { var reportFrame = document.getElementById(this.reportFrameID);
if (reportFrame) { msg = reportFrame.contentWindow.ErrorMessage; }
return this.LocalizeMessage(msg);
}

Here is the code for my ReportViewer.aspx:
<%@ Page Language="C#" Inherits="System.Web.Mvc.ViewPage<dynamic>" %>
<%@ Register Assembly=
"Telerik.ReportViewer.WebForms, Version=6.1.12.820, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" Namespace="Telerik.ReportViewer.WebForms" TagPrefix="telerik" %>
<%@ Register Assembly=
"Telerik.Reporting, Version=6.1.12.820, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" Namespace="Telerik.Reporting" TagPrefix="telerik" %><br><%@ Import Namespace="System.Web.Mvc" %>
<%@ Import Namespace=
"System.Data" %>
<head runat=
"server">
   <title></title>
</head>  

<form id=
"main" runat="server" method="post" action="#">
   <telerik:ReportViewer ID=
"ReportViewer1" runat="server" style="width: 790px; height: 800px;" >
   </telerik:ReportViewer>
</form>
<script runat="server">
 public override void VerifyRenderingInServerForm(Control control)
 {
   //base.VerifyRenderingInServerForm(control);
   // to avoid the server form (<form id="Form2" runat="server">) requirement
 }

 protected override void OnLoad(EventArgs e)
 {
    base.OnLoad(e);
    ReportViewer1.ReportSource = new QuoteRpt();
    var name = "QuoteReport"
    ReportViewer1.ReportSource.Parameters.Add(new Telerik.Reporting.Parameter("QuoteId", ViewBag.QuoteID));
 }
</script>

Ranjit
Top achievements
Rank 1
 answered on 26 Oct 2012
4 answers
311 views
Is it possible to export only the data, for example if i have a table set in the report as following

Column1 Column2 Column3
xxx1 xxx2 xxx3
yyy1 yyy2 yyy3
zzz1 zzz2 zzz4

i would like to have the following csv :
Column1,Column2,Column3
xxx1,xxx2,xxx3
yyy1,yyy2,yyy3
zzz1,zzz2,zzz4

for the moment i have some textbox string that appear in the csv and i do not know how to get rid of them.

thanks for your help
sebastien
Elian
Telerik team
 answered on 26 Oct 2012
1 answer
174 views
Hi,

I've recently upgraded to the Q3 2012 Reporting controls.  I've found that Telerik.ReportViewer.Silverlight.dll no longer contains "FormatedNumberConverter."  I'm referencing the assembly as follows.

xmlns:Telerik_ReportViewer_Silverlight="clr-namespace:Telerik.ReportViewer.Silverlight;assembly=Telerik.ReportViewer.Silverlight"

This is how my static resource is defined:

<Telerik_ReportViewer_Silverlight:FormatedNumberConverter x:Key="FormatedNumberConverter"/>

And this is how it's being used:

<TextBlock Margin="2, 0, 10, 0"
TextAlignment="Center"
Text="{Binding PageCount, ConverterParameter=of \{0\} pages, Converter={StaticResource FormatedNumberConverter}}"
VerticalAlignment="Center">

Is there a new way to handle this?



Thanks,
- Aaron
IvanY
Telerik team
 answered on 26 Oct 2012
4 answers
427 views
I have a skeleton ASP.NET application with the following:

1) One Telerik report with nothing in it. In the default constructor for this report I added a "Debug.WriteLine" statement so I can see when the constructor is called.

2)  One ASPX page, which contains a ReportViewer control in it. In the Page_Load event I create an instance of the report, then set it to the Report property of the ReportViewer.

When ASP.NET Session is set to InProc, all works fine, I look at the Debug window and the constructor is called once. However, when I set the ASP.NET Session to StateServer, I notice the constructor is called three times. Considering I'm planning on putting a few Chart controls in this report and calling a few SQL Server sprocs, this worries me.

Any ideas why using ASP.NET Session = StateServer, the reporting engine would create the report object three times? FYI, this is the Q1 2012 release of Telerik Reporting.

Thanks.
Elian
Telerik team
 answered on 26 Oct 2012
1 answer
522 views
Hi Telerik,

Please respond to this question asap, because I am in a deep ...

I would like to have a two datasources. So I must use table. How can I join the report datasource a and the table datasource? I have also another question in this forum which is ignored, so I am trying to find another way how to solve my problem.

http://www.telerik.com/community/forums/reporting/telerik-reporting/how-to-specify-connection-string-for-detail-report.aspx

Thank you

Tom
Elian
Telerik team
 answered on 26 Oct 2012
3 answers
248 views
I use an HTMLTextbox in my report to add line breaks in a field with <br />. When exports to Excel, the line breaks disappear. 

I know there is something in the Design Considerations for Report Rendering that says formatting is removed from the Excel export. Is there something I can do to get the line breaks in the cell, or is this something that will be fixed in a future version?
Peter
Telerik team
 answered on 26 Oct 2012
6 answers
97 views

Hi, I'm facing problem with latest reporting (Q3 2012). I'm trying to format charts on one report, but everytime I save and build, those changes are reverted as if I did nothing.

What I'm trying to change is to:

  • hide series labels
  • change series empty value display type
  • change PlotArea dimension properties (margins, etc.)
  • change display mode of legend and its positioning

I'm using VS2008, fully patched. In this project, I use Reporting Q3 2012, but I have installed Reporting Q2 2009 SP1 and Reporting Q1 2012.

Is there any way how to fix it myself/known workaround. Thanks in advance.

Daniel

Chavdar
Telerik team
 answered on 26 Oct 2012
1 answer
81 views
Hello, I have a question. Is there some possibility to "Stick" the starting point of my chart to Y-axis? Now it is some free space between Y axis and my chart. You can see an example in attachment.

I will be glad if you could help me.

Regards, Pawel Janda
Elian
Telerik team
 answered on 26 Oct 2012
5 answers
958 views
I'm trying to follow these instructions to directly export reports from their definitions to the end file (Word or PDF) without passing through a viewer. This is the requirement of the application I'm doing.

I know how to obtain the PDF given the IReportDocument, but how do I get an IReportDocument from the TRDX file I just created using the Standalone builder?
Peter
Telerik team
 answered on 25 Oct 2012
Top users last month
Rob
Top achievements
Rank 3
Bronze
Iron
Iron
Missing User
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?