Questions on Reporting Forum

3 answers

233 views

Unable to serialize the session state error with Telerik report Q2 2009

Hi,

I am using telerik report Q2 2009 and using the session mode="Sql Server".
when i opem telerik report it shows error message

Unable to serialize the session state. In 'StateServer' and 'SQLServer' mode, ASP.NET will serialize the session state objects, and as a result non-serializable objects or MarshalByRef objects are not permitted. The same restriction applies if similar serialization is done by the custom session state store in 'Custom' mode

Though it works fine with INProc mode of session.
But i have to use session mode="SQL Server".

Please help me to solve this issue.

Thanks,
Hrushikesh

General Discussions

answered on 19 Mar 2010

1 answer

105 views

How to fill dataset from database XML Column for Telerik.Reporting.Table?

Hello,

I was looking at the Product Line Sales example and wanted to make table with chart at right hand side showing some calculated results for each row data in Telerik.Reporting.Table component. Then I realized that I have to show XML data (coming from xml column).

I dont know how to make Table component show xml data? Can anyone give a veru simplified example here so that I can move forward?

General Discussions

answered on 19 Mar 2010

1 answer

172 views

where is latest internal builds for Telerik Reporting and RadControls for Silverlight

I cant find it in my account manager

General Discussions

answered on 19 Mar 2010

4 answers

229 views

2010 Q1 RawData null

Prior to Q1 I used this in my subreport:

    
            private void MySubReport_NeedDataSource(object sender, EventArgs e)  
        
            {  
        
                Processing.Report report = (Processing.Report)sender;  
        
                Processing.IDataObject dataObj = (Processing.IDataObject)report.DataObject;  
        
                MyClass myObj = dataObj.RawData as MyClass;  
        
                ...  
        
            }

In Q1 raw data returns null. Is there a way to cast MyClass or is my access restricted to String s = dataObj["valName"]; ?

Thanks

General Discussions

answered on 19 Mar 2010

0 answers

136 views

Refresh button on report viewer doesn't work?

I updated something with my report and then clicked refresh but it didn't work. I had to click select button where it get datasource again and rebind reportviewer to refresh report.

Or I need to do anything else with refreshing function to make it work? Please give me a suggestion.

General Discussions

asked on 19 Mar 2010

1 answer

78 views

How to page Crosstab report using web viewer

Hi guys,

I wanted to ask if it is possible to have paging on web viewer of report containing only one simple crosstab element.

When the page and the report are rendered, even when it has 300 rows, it is displayed in one page. But if I export to PDF, or print the report, it appears on 20+ pages. I want the basic HTML display to be paged as well, because the page has rendering problems with such large report.

Thanks,

Dave

General Discussions

answered on 19 Mar 2010

2 answers

110 views

Change to version 2010 Q1 and now unabled to cast datarow in GroupHeader_ItemDataBound event.

Hi,

I've made some reports with the tryal version 2009 Q3 and, just installed the developper version 2010 Q1. While the installation, it asks me to uninstall previous versions. I did. Install the version and make an upgrade with the Telerik Report Upgrad wizard. So, in several reports, I trap the GroupHeader_ItemDataBound event, cast the sender to a GroupSection variable and cast the in a datarow like the next exemple :

    
            Private Sub moduleIDGroupHeader_ItemDataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles moduleIDGroupHeader.ItemDataBound  
        
                    Dim Group As Telerik.Reporting.Processing.GroupSection = DirectCast(sender, Telerik.Reporting.Processing.GroupSection)  
        
                    Dim txtTitle As Telerik.Reporting.Processing.TextBox = DirectCast(Group.ChildElements.Find("txtDMTitle", True)(0), Telerik.Reporting.Processing.TextBox)  
        
                    Dim txtDescription As Telerik.Reporting.Processing.TextBox = DirectCast(Group.ChildElements.Find("txtDMDescription", True)(0), Telerik.Reporting.Processing.TextBox)  
        
                    Try 
        
                        ' Dim row As System.Data.DataRow = DirectCast(Group.DataObject.RawData, System.Data.DataRow)  
        
                        Dim row As System.Data.DataRow = DirectCast(Group.DataObject.RawData, System.Data.DataRow)  
        
                        txtDescription.Visible = row("DMPDescription")  
        
                        txtTitle.Visible = row("DMPTitle")  
        
                        txtTitle.Style.Color = System.Drawing.Color.FromArgb(28, 51, 97)  
        
                    Catch ex As Exception  
        
                        Stop 
        
                    End Try

When the compiler execute the line Dim row As System.Data.DataRow = DirectCast(Group.DataObject.RawData, System.Data.DataRow),
It append an error with the message "Impossible to cast an objet of type '<EnumRawData>d__0' in 'System.Data.DataRow."

I tried to cast to an array of rows, Build, Rebuild, Clean, etc..

Thanks a lot,

Ben

General Discussions

answered on 18 Mar 2010

1 answer

88 views

is there someone making video for introducing sqldatasource in report?

I would glad if there is someone can make a video teaching us how to use sqldatasource in report chart and supporting parameters. It is too difficult for me to use dataset in 2009.

General Discussions

answered on 18 Mar 2010

1 answer

138 views

Pie Chart

Hi,

I am trying to get a pie chart to work similar to your sales dashboard demo.

I am using the following sql:

"SELECT SUM(Value) AS [Sum], C.Name FROM (Category AS C INNER JOIN Subcategory AS SC ON C.Id=SC.Category_id) INNER JOIN [Data] AS D ON SC.ID=D.SubCategory_Id WHERE [Year]=@Year GROUP BY C.ID, C.Name ORDER BY C.ID"

For the series property I am using name as the DataLablesColumn and sum as the DataYColumn

However, when i run the report I see the name in both the legend as well as the pie chart section. What property do i need to set to see the sum on the chart and the name on the legend.

Also do you have a video of the pie chart design? The one on telerik tv is for bar charts and I see that pie charts are quite different in implemetation.

Thanks

General Discussions