This should be very simple but I can't figure out how to do it.  I have spent hours looking for a solution and trying different options.

I have a sql datasource with data as:

Period     |  Avg_Total
1/1/2011  |  $1000
2/1/2011  |  $1500
3/1/2011 |  $2000
...
...
12/1/2011 | $ 1200

I set my Chart's properties as:
- PlotArea.XAxis.AxisLabel.DataLabelsColumn = Period
- Series collection with DataYColumn = Avg_Total

I keep getting the error message.  Unable to cast object of type 'System.DataTime' to type 'System.String'.  All I want is a line chart with X-Axis with date value and Y-Axis for the avg_total.  I even upgraded to the latest version, Telerik Q1 2012, and is still getting the same issue. 

Help??

I just got through my first major experience with Telerik reports, and I hope this can prove to be some constructive criticism.  While the API and the documentation & forum were very good, I was trying to do something very specific that I simply had the most difficult time completing.  I was trying to use a table (as a sub-report) and dynamically remove *some* header rows while keeping others depending on the number of rows returned by the underlying stored procedure.  I really, really, really, really wish there was an easy way to programmatically get at the number of rows returned in a Telerik SqlDataSource object.  I also wish it was made more clear that the DataObject property referred to the *parent*'s data source.  

Also, it seems that there are some unknown (unknowable?) rules about what table cells can and cannot be merged - something I find completely bizarre.  I sort of hope that in the future there is some better documentation that clearly explains how rows can be removed from a table.  Also, I think that this functionality relied on having the table set up absolutely perfectly in the designer screen.  Is it possible that a checklist could be set up of items to look for to insure that my table is set up correctly to allow me to remove rows?  I greatly appreciate that you allow options to be set at runtime via the event handlers like Table_ItemDataBound, but man... finding simple, reliable answers to row counts, and turning off/making invisible/removing table rows was very difficult to come by.   

We have nested tables. Table B is in Row 14 of Table A. When the Table B has no data we would like to not show it and this we did by setting its visible to false. But the white space created by this(row14) is showing up in the report.
How to remove row14 when it is not applicable?

I have a report with header and multiple sub sections in details section.
For each subsection we have placed table and assigned corresponding datasource.
In header i have a textbox which contains patient related data.
Eg:textbox1 -->Expression--> [=Fields.NameField]


Now i need to display a caluculate field in table1 column based on the value of the textbox in header section.

eg:
Table1
----------------
textbox2-->Expression-> =FormatName() (UserDefined function)

In code behind file .cs

public static string FormatName()
{
return textbox1.Value+ "Busineess Logic";
}
But i am not able to access textbox1 here in this method as the method is declared as static.

How to achieve this in telerik ???

hi
for reporting
i want to change numeric format
for example change 123.65 to  123/65
how can i do this?
tnx.

i

When I try and preview my report I get an error as soon as I reference my object data source.  ...

An error has occurred while processing Report 'ShortDetailReport': An error occurred while invoking data retrieval method. Try restarting VisualStudio. ------------- InnerException ------------- Exception has been thrown by the target of an invocation. ------------- InnerException ------------- The specified named connection is either not found in the configuration, not intended to be used with the EntityClient provider, or not valid.

So, I thought I would try and debug it.  I created a "report viewer to point to my report.  When I go to my report view page I get this error ...

error CS0012: The type 'Telerik.Reporting.IReportDocument' is defined in an assembly that is not referenced. You must add a reference to assembly 'Telerik.Reporting, Version=6.0.12.302, Culture=neutral, PublicKeyToken=a9d7983dfcc261be'.
c:\Windows\assembly\GAC_MSIL\Telerik.ReportViewer.WebForms\6.0.12.302__a9d7983dfcc261be\Telerik.ReportViewer.WebForms.dll: (Location of symbol related to previous error)
c:\....\ShortDetailReportViewer.aspx(8,13): error CS0012: The type 'Telerik.Reporting.Report' is defined in an assembly that is not referenced. You must add a reference to assembly 'Telerik.Reporting, Version=6.0.12.302, Culture=neutral, PublicKeyToken=a9d7983dfcc261be'.
c:\Users\Brisco\AppData\Local\Temp\Temporary ASP.NET Files\root\62b29810\64a087af\assembly\dl3\40a66d36\c6893234_be14cd01\...Web.DLL: (Location of symbol related to previous error)
c:\....PHRED.Web\WebConsumer\ShortDetailReportViewer.aspx(8,30): error CS0029: Cannot implicitly convert type ...Web.App_Reports.ShortDetailReport' to 'Telerik.Reporting.IReportDocument'


The correct reference is there, why is it not finding it? So far this has been a horrible experience with the reporting tool. I have been trying for three days now to get this stupid report working. I have not been able to get past just trying to bind to me datasource.

I have a bit of experience with Telerik Reports and using Charts. But I have only used one Chart. I was wondering if it is possible to do something like shown in the attachment? Any help provided would be greatly appreciated. Thanks.

Hi,
I want to test the reporting portal for my company.
Is there anyway to create a "reporting portal" for the for the company where user can enter see a menue with their reports?
and also, do you have a mechanism to manage the security of users accessing it (the "reporting portal")?
I want a link to a tutorial if it is possible.

Thanks

I have created charts inside a report using SQLDataSource to bind the data.  I would like my bar graph to show negative entries in red and positive entries in green.

I have tried setting the "ConditionalFormatting" property as in link below but that doesn't do anything. 
http://www.telerik.com/help/reporting/styling-conditional-formatting.html

Also I found this thread, but my data is generated by datasource.  How can I retrieve the ChartSeriesItem from the reportviewer?
http://www.telerik.com/help/reporting/howtoassigncolors.html

Hello all,

Can anyone give me an example of how to use the PageCount and PageNumber Build-In objects please.

Thanks,

JY