Questions on Reporting Forum

4 answers

137 views

I have a SQLDataSource that produces three columns:AccountNumber, Date, Amount. I want to databind a LineChart to have the AccountNumber drive the series, PostDate on XAxis and Amount on YAxis. I'm part way there. I have the DataGroupColumn set to AccountNumber so when I run the report a line generates for each AccountNumber. The amount shows on the YAxis but I am getting 1,2,3,4,5 on the XAxis. How do I get my date values to show on the XAxis? I tried usagechart.PlotArea.XAxis.DataLabelsColumn = "PostDate" but thats not doing anything. Can I format my data values to not show cents? Do I have to do that in the NeedDatasource or can I do it from the designer?

General Discussions

answered on 28 May 2011

2 answers

183 views

Get Report Data in Code of Report Viewer

Hi,

I have a Telerik report that I preview in a web page with a standard telerik:ReportViewer.

Within code of the report viewer page I would like to read data from textboxes on the report being previewed (or from the datasource of the report if that is easier). I have tried getting a reference to the report and then the report section and then the textbox, but all I get
back from the textbox.value is the formula of the value property (eg "=Fields.assessment_id") not the actual data.

Is what I am trying to do possible?

Could anyone send me a snippet (VB if possible) to get me going, or point me in the direction of an article that discusses this topic?

Thanks in advance.

Mike

General Discussions

answered on 28 May 2011

1 answer

57 views

Session State required for WCF ReportService

Just lost half a day debugging a "Null reference" exception inside the ReportService. The strange thing is that in case of a disable Session State a null reference exception is fired. I can understand that it might be required, but I can't find this in the documentation. Besides the missing documentation I'd have liked a proper exception.

Hope a change in both documentation and library will happen to help others.

-
Mark Monster

General Discussions

answered on 27 May 2011

17 answers

429 views

Multiple textBoxes with Navigate to url action in cell

Hi,

I have a requirement where in the report I need to dynamically generate textboxes with navigate to url actions based on the data bound to it. I'm connecting to a sqldatasource.

I tried the following. Placed a Panel in the cell. Hooked up to the ItemDataBound event. But I'm not able to reach to that particular field in the DataObject. If I can get to it I can generate TextBoxes on the fly and add to the panel. Is this possible to do?

Cheers,
Ganesh

General Discussions

answered on 27 May 2011

1 answer

67 views

Crosstab withing table row

Telerik.Reporting.Processing.Table tblCrosstab = (Telerik.Reporting.Processing.Table)sender;

FairDataList = null;

var tbl_EEEEE_STUDENT_ID = tblCrosstab.DataObject["EEEEE_STUDENT_ID"];

if (strEEEEE_STUDENT_ID != null)

{

if (_objCrosstab != null)

{

if (tbl_EEEEE_STUDENT_ID!= null && tbl_EEEEE_STUDENT_ID.ToString() == strEEEEE_STUDENT_ID)

{

FairDataList = _objCrosstab.GetFAIRDataDetailK2_1(this.ReportParameters["SchoolYear"].Value.ToString(),

this.ReportParameters["District"].Value.ToString(),

this.ReportParameters["School"].Value.ToString(),

this.ReportParameters["Grade"].Value.ToString(),

strEEEEE_STUDENT_ID);

if (FairDataList.Count > 0)

{

if (tblCrosstab.DataSource == null)

{

tblCrosstab.DataSource = FairDataList;

}

General Discussions

answered on 27 May 2011

3 answers

228 views

HTML Report Rendering

I'm trying to render a report in HTML format and use the result stream in a aspx page using a Literal or Text control. My problem is that the rendered result contains tags that are causing the output to break, like <html>, <body>, <head>, etc. I just need the html code that's inside the <body> tag.
I will also like the option to strip all styling from the output and get the raw html without styles.

Thank you.

General Discussions

answered on 27 May 2011

1 answer

132 views

Specified argument was out of the range of valid values. Parameter name: childIndex

Good Day

i am using the telerik Report , i am trying to load the Report on page load in Silverlight. this used to work perfectly in a Silverlight Page, now i am using the report in a SilverlightChild Window and whenever my code reaches this pl

var layoutRoot = (FrameworkElement)VisualTreeHelper.GetChild(reportViewer, 0);

it fails with the Error

Specified argument was out of the range of valid values. Parameter name: childIndex

so to make sure that it does not find the elements i used the code like this

if (VisualTreeHelper.GetChildrenCount(reportViewer) > 0)

{

var layoutRoot = (FrameworkElement)VisualTreeHelper.GetChild(reportViewer, 0);

var viewerModel = (ReportViewerModel)layoutRoot.DataContext;

var refreshCommand = viewerModel.RefreshReportCommand;

if (refreshCommand.CanExecute(null))

{

refreshCommand.Execute(null);

}

I see it does not find an element.

Thanks

General Discussions

answered on 27 May 2011

1 answer

142 views

Change parent section at runtime (on export)

I need to "move" a field from the Deatil Section to the Group Section when the user exports to CSV.

Here's why: When exporting to CSV and opening the document in Excel, every column present in he Group Section is repeated in every line of the CSV file, but the same does not happen to a grouping field that is within the Detail Section (unless it is the data of an unique register). Therefore, in order to make a field from Deatil Section repeat in every line, I have to "move" it to the Group Section when user exports to CSV.

Is there anyway to perform such action?

I'd appreciate any help.

All the best.

General Discussions

answered on 27 May 2011

0 answers

186 views

what changes in web.config changes telerik reporting

I am using Visual Studio 2008 Microsoft.net Framework 3.5 SP1 . I installed telerik Q1 2011 reporting and included all required things. on running the application after adding required controls I get Microsoft JScript runtime error: Object expected.

I have made following changes in web.config file. Can anyone please give me step by step explaination with reason the changes to be made in web.config for letting telerik report work properly. Please reply asasp. Thanks in advance

<

compilation debug="true">

<

assemblies>

<

add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>

<

add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

<

add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>

<

add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>

<

add assembly ="Telerik.ReportViewer.WebForms, Version=5.0.11.316, Culture=neutral, PublicKeyToken=a9d7983dfcc261be"/>

</

assemblies>

</

compilation>

<

pages>

<

controls>

<

add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

<

add tagPrefix="asp" namespace="System.Web.UI.WebControls" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

<

add tagPrefix="telerik" namespace="Telerik.Web.UI" assembly="Telerik.Web.UI"/>

<

add tagPrefix ="telerik" namespace ="Telerik.ReportViewer.WebForms" assembly ="Telerik.ReportViewer.WebForms, Version=5.0.11.316, Culture=neutral, PublicKeyToken=a9d7983dfcc261be"/>

</

controls>

</

pages>

is there any need to make change in handler tag and does q1 2011 works with .net 3.5. Please help me reply asap as I am stuck. Thanks in advance

General Discussions

asked on 26 May 2011

1 answer

82 views

Trouble With Line Graph

I am trying to create a line graph for a report, and I am having a lot of trouble figuring out exactly how to do what I need. This is what my data looks like:

http://dl.dropbox.com/u/2978500/data.png

I want to be able to show sales averages for two different types of accounts over the past several years. The x axis should be the years, the y axis should be the dollar amount, and the account type should be the series.

I have set the chart's DataGroupColumn property to GroupID, and that correctly makes two series. However, the y axis is wrong, and I end up with this:

http://dl.dropbox.com/u/2978500/chart.png

How do I get the months across the y axis?

General Discussions

answered on 26 May 2011