Questions on Reporting Forum

0 answers

93 views

Report From Database XML Column with filtering option

I want to generate report from XML data coming from database, along with the filtering option each column in report!

I have noticed that whatever changes I make in any report sample given on telerik blog for reporting....It stops working.

What is wrong with it? I did download the following sample too
http://blogs.telerik.com/kevinbabcock/posts/09-02-06/bind_your_telerik_reports_to_xml_data.aspx
And again did nothing but added some code and again deleted it back, then report stopped working!!!!!!
I am trying for 5 days for make a single report and cant even see any wrong results though!

Please can anyone give me sample of report generated from database xml column having data like:

<Markers>

<Line>

</Line>
</Markers>

General Discussions

asked on 07 Jan 2010

0 answers

119 views

How to show XML in report with filtering e.g. through querystring?

I have XML stored my my database. I searched over internet and found this:
http://blogs.telerik.com/kevinbabcock/posts/09-02-06/bind_your_telerik_reports_to_xml_data.aspx

In this article, XML file is been used and report has been made in a classlibrary. I want to make my report to generate from XML data coming from database at runtime. For example, being on one .aspx page I select VehicleNumber, StartDateTime and EndDateTime from some control (already been done) and pass that information to next .aspx page having report viewer in it showing results based on that filtering parameters!
In the article mentioned above, I learned how to using LINQ for showing XML data in report but how can I pass parameters to that the query as SomeReport_NeedDataSource event would be in class library?

Please can anyone provide me a little example? I am now exhausted trying everything....

General Discussions

asked on 06 Jan 2010

5 answers

424 views

NeedDataSource event firing when exporting report

I stepped through the report event and noted that the NeedDataSource fires whenever I press preview from the Report viewer. I do notice however, that the NeedDataSource event fires again when I do an export from the report viewer. This event is where I set the report.DataSource, this also means that this is where I run the database queries.

I would have thought that since the report.DataSource has already been set/cached during the "preview" action (through the NeedDataSource), the "export to excel" action will not cause the NeedDataSource event to fire again. This is a winforms application by the way so asp.net statelessness is not an issue.

You see, I have a fairly large monthly data set and it takes twice the time to preview the report and export the report because of this NeedDataSource event.

How is the NeedDataSource event triggered? What sets the report.Datasource to nothing?

An example of the NeedDataSource event:

Private Sub MonthlyAccepted_AS_MasterReport_NeedDataSource(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.NeedDataSource

Dim subGroupName As ISOSettlementProvisionSubGroupName = EnumUtility(Of ISOSettlementProvisionSubGroupName).Parse(Me.ReportParameters(SETTLEMENT_TYPE).Value)

Dim dayofMonth As Date = Date.Parse(Me.ReportParameters(MONTH).Value & " 1, " & Me.ReportParameters(YEAR).Value)

me.DataSource = BusinessObjects.MonthlyAcceptedASInfo.GetData(dayofMonth, subGroupName)

End Sub

Thanks.

General Discussions

answered on 06 Jan 2010

2 answers

86 views

DateFormat in Silverlight report

Hi
I would like the default datetime format to mm/dd/yyyy using a format function.
for eg.
How can i change the format of = Now()
from 1/5/2010 4:48:00PM to 1/5/2010

Regards
SUNU

General Discussions

answered on 06 Jan 2010

1 answer

144 views

Copying a report

Is there a simple way to copy a report to use as a basis for a new report. Right now I am creating a new report and then copying individual items from the original to the new report. This works, but is time consuming.

General Discussions

answered on 05 Jan 2010

3 answers

256 views

Error: Report is unavailable or session has expired. When Exporting to PDF.

When we generate large reports (150 + pages) and then try to export those reports as PDFs, we get the following errror: Report is unavailable or session has expired.

We have increased the seession timeout to 60 in the web.config

<

sessionState timeout="60" />

Any ideas?

General Discussions

answered on 05 Jan 2010

2 answers

254 views

VB.NET Documentation

Hello,

In general I am very please with telerik; however, it seems like VB.NET is an afterthought in regards to samples...

The following is the code supplied for VB.NET to connect a chart to a datasource and seems useless as far as correct code....not that it can't be modified but just a bit annoying.

This is from ms-help://telerik.reporting.3.2/Reporting/BuildingDatabindDatabase.html

    
            Imports System  
        
            Imports Telerik.Reporting.Chart  
        
            Public Partial Class Report1  
        
             Inherits Report  
        
             Public Sub New()  
        
              """ <summary>  
        
              """ Required for telerik Reporting designer support  
        
              """ </summary>  
        
              InitializeComponent()  
        
                End Sub 
        
             Private Sub chart1_NeedDataSource(sender As Object, e As System.EventArgs)  
        
             " create a datasource  
        
               Dim sqlDataSource As New SqlDataSource()  
        
               sqlDataSource.ID = "myDataSource" 
        
               sqlDataSource.ConnectionString = ConfigurationManager.ConnectionStrings("NorthwindConnectionString").ConnectionString  
        
               sqlDataSource.SelectCommand = "SELECT CategoryName, SUM(ProductSales) AS TotalSales FROM [Product Sales for 1997] GROUP BY CategoryName" 
        
             Dim procChart As Telerik.Reporting.Processing.Chart = DirectCast(sender, Telerik.Reporting.Processing.Chart)  
        
             procChart.DataSource = "myDataSource" 
        
            " Set the column for data and data labels: 
        
             " Each bar will show "TotalSales", each label along  
        
             " X-axis will show "CategoryName.  
        
             chart1.Series(0).DataYColumn = "TotalSales' 
        
             chart1.PlotArea.XAxis.DataLabelsColumn = 'CategoryName' 
        
             " assign appearance related properties  
        
             chart1.PlotArea.XAxis.Appearance.LabelAppearance.RotationAngle = 300  
        
             chart1.PlotArea.XAxis.Appearance.TextAppearance.TextProperties.Color = System.Drawing.Color.BlueViolet  
        
             chart1.PlotArea.Appearance.Dimensions.Margins.Bottom = Telerik.Reporting.Charting.Styles.Unit.Percentage(30)  
        
            End Sub 
        
            End Sub 
        
             End Class

John

General Discussions

answered on 05 Jan 2010

2 answers

138 views

SqlDataAdapter missing?

I am trying to follow the video tutorial for using parameterized queries here, but the tutorial seems to revolve around using a SqlDataAdapter which the video shows as showing up in the Telerik Reporting menu in the toolbox, but in my Telerik Reporting Q3 2009 there is no SqlDataAdapter.

How do I get this to show up?

Help! I'm under a time crunch!!

General Discussions

answered on 05 Jan 2010

3 answers

124 views

Enterprise Library 4.1

Hello,

Has anyone connected to Reporting Q2 2009 using Enterprise Library 4.1 DAAB?

I've reviewed the Code Examples and Videos, 22Reporting ConnectingToData however I was unable to find a way.

Are there any short online examples of this type of data connection?

Many thanks

General Discussions