Questions on Reporting Forum

10 answers

1.1K+ views

Produce output in Windows.Reportviewer is slow

Dear support,

I have a report in WinForm environment. After the report object was built and it was loaded into Reportviewer by:
Dim frm As New Reportviewer(report)
frm.Show(Me)

It takes nearly 3 mins to generate 140 pages to screen and when I click "export to pdf" from "Reportviewer", it takes nearly another 3 mins. The speed is not too slow, but SLOW. I assume it only takes 5seconds because the process is in RAM.

Any enhancement is planned in this area.
My version is 2.0.1.0.

Benson.

General Discussions

answered on 12 Jun 2009

2 answers

164 views

Index out of range in Textbox for no rows returned

Hi, if I have a stored procedure that could return either a number or rows or no rows for a given report parameter, but if the stored proc returns no rows can I update the textbox to show either "No rows found" or with the data returned from the stored procedure.

I don't think I can use the IsNull because there are no rows returned for this particular report parameter. When in the textbox I have =Fields.ColumnName I get an error saying "index is out of range" when no rows are returned, otherwise if data is returned it shows the field ok. Is there a solution for this ?

Thanks a lot,

Pete.

General Discussions

answered on 12 Jun 2009

1 answer

97 views

Quick and dirty reporting

All the examples and videos, talk about best practice and creating the reports in a separate class file.

All I want to do is create a few reports in an existing web app and run drive the reports from a stored proc. Are there any examples on how to do this.

Andy

General Discussions

answered on 12 Jun 2009

1 answer

253 views

MissingManifestResourceException when rendering report

Hi,

I am using the latest version of Reporting (as of Jun6), I get this exception when tryign the view a report in the ReportVeiwer control. This is all windos based.
I have a report in a class library, the business object in another class library, and the executing Winforms app with the viewer in it.

Could not find any resources appropriate for the specified culture or the neutral culture. Make sure "Telerik.Reporting.ExcelRendering.Excel97.ExcelReport.resources" was correctly embedded or linked into assembly "Telerik.Reporting.Processing" at compile time, or that all the satellite assemblies required are loadable and fully signed.

I can run sample apps from Telerik without problems, and I am using business object from one of your samples (Master-Detail sample from an earlier forum thread). That works fine when I create a new solution with the same structure, but does not work when using it in my existing solution.

Any idea why this can be?

I made sure all the references are there. But even the simplest, non-nested business object cannot be rendered into a report.

RptOrders

orders = new ObjDataSourceMasterDetail.Reports.RptOrders();

orders.DataSource = Order.CreateOrderList(); //taken from sample provided by Telerik

this.reportViewer1.Report = orders;

reportViewer1.RefreshReport(); //exception occurs after call to RefreshReport()

The report itself is simple. It has one textbox with "=Fields.OrderID" etc. and all that gets rendered correctly, but only after a series of exceptions come up, starting with the MissingManifestResourceException, then this is followed by a ArgumentOutOfRangeException, which is followed by a TargetInvocationException.
No stacktraces are available. In all 3 cases the stacktrace has only one less than helful line. There are no inner exceptions either.
I cannot narrow it down to a component or anything else.

I also made sure I have all the references that the sample project has, too. The sample works, renders the report perfectly, my my app doesn't.

Help!!!

General Discussions

answered on 12 Jun 2009

3 answers

129 views

Index out of Range for Field returned from Stored Procedure

Hi, I've got a sqldataadapter that retrieves a field from a stored procedure for a given report parameter and populates a textbox with this value that works fine, but if I enter a value in the report parameter that hasn't got a row in the database and returns 0 rows in the stored procedure I get the error "An error has occured while processing textbox "Textbox1", index was out of range, must be non negative and less than the size of the collection."

Is there a way of checking for returned rows in the expression, and if empty put in a default value.

Thanks a lot.

General Discussions

answered on 12 Jun 2009

3 answers

136 views

Inline detail (possible to repeat detail items in columns) ?

Hi
When there is only 1 small attribute (say name or date) in detail section it's not very efficent to repeat the whole row for each item (most of the row would be blank).
It would rather by nice to repeat the items "inline" or in principle have the items concated to a larger textbox. Right now I have been able to do it (the concatenation) upfront customising the data preparation. Maybe that is possible out of the box in reporting? Thank you.

General Discussions

answered on 11 Jun 2009

7 answers

259 views

Data Binding a Chart to Access DB

I've been using Active Reports in my applications for many years but recently instead of upgrading to the new versions I decided to look at other options. I found Telerik and was quite impressed with many of the features. I like the way the reports can render in Winforms and the Web along wiht a number of other things. I downloaded a trial and set about building several reports to make sure I can reproduce all the features I used to get from Active Reports before jumping ship. I found the reports side of things quite good although I did have some issues trying to get a simple date field to display by setting a format on the properties of the field.

Anyway, when I got to the report that needed to have a chart I became frustrated. I just wanted to bind a simple chart to the same data source as my report and I foudn this was not easy to do. I searched through all the documentation and tutorials and found there is very little explanation on how to data bind a chart. The examples show binding to a data adaptor or a data table but it doesn't say how the data should be structured to bind it to the report. I tried copying from some of the samples but I can't get a simple chart to show any data.

I gave up trying to bind to my report data source adn tried to create an independant data sourtce to bind to. I am trying to bind to an Access database using OLDB.

I got down to the most simple code but every time I try to run the report it just sits there displaying "Generating report" forever. There is no error message and no clue as to why it doesn't work. I'm just guessing at the SQL I thougth i'd put two simple fields in and it might bind to them.

Here's the code:

Private Sub ChartDailyTotals_NeedDataSource(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ChartDailyTotals.NeedDataSource

Try

Dim Mychart As Telerik.Reporting.Processing.Chart = TryCast(sender, Telerik.Reporting.Processing.Chart)

Dim commandText As String = "SELECT top 5 TriggerDate, TriggerCount from triggers"

Dim MyAdapter As New OleDb.OleDbDataAdapter(commandText, My.Settings.WinCounterReportsDataConnection)

Dim MyDataSet As New DataSet()

MyAdapter.Fill(MyDataSet)

Mychart.DataSource = MyDataSet

Catch ex As System.Exception

System.Diagnostics.Debug.WriteLine(ex.Message)

End Try

End Sub

I don't give up easily but I've been trying to do this for two days. If I don't get an answer soon I will have to go back to Active Reports. It's a shame because I really liked what Telerik had to offer.

Perhaps someone can point me to some documentation or show me what I should do.

General Discussions

answered on 10 Jun 2009

11 answers

352 views

HTML view not aligned

Hello,

I'm currently evaluating telerik reporting and made some simple reports. When I preview the report using the designer then reports looks okay and properly aligned, but when I view it with HTML in the designer of using a web reportviewer, it gets mis-aligned, is this because I'm using a trial version?

also just a followup question, is it possible to change the unit of measure in design time, from inches to millimeter?

Thanks

General Discussions

answered on 10 Jun 2009

1 answer

206 views

Cannot find Report Book control in my toolbox

Hi,

I have Telerik Reporting Q3 2008 SP2(2.9.9.202).

I am trying to create a report book for a group of reports. And i don't whether this version supports report book or not. I was going through some documentation i find that there is one control that places Report Book in the tools column of report viewer. Right now i am not finding this control in my toolbox. I think this comes with the version Q1 2009.

Please tell me how to get this Report book control and how to create report book. I just extracted some code from the document to create report book but i cannot able to access the properties.

                    Imports System.ComponentModel         
                     
            <Description("A collection of Product-related reports")> _         
            Public Class ReportBook         
                Inherits Telerik.Reporting.ReportBook         
                Public Sub New()         
                    Me.Reports.Add(New DashBoard())         
                    Me.Reports.Add(New ProductSales())         
                    Me.Reports.Add(New ProductCatalog())         
                    Me.Reports.Add(New ProductLineSales())         
                End Sub         
            End Class         

Thanks.

Regards

Syed Arshad

General Discussions

answered on 08 Jun 2009

1 answer

293 views

Assign DataTable column to a TextBox

Hi,
I have a trouble displaying a value in a TextBox.
I found simmilar post but unfortunately the link for it is broken (http://www.telerik.com/community/forums/reporting/telerik-reporting/assigning-datatable-column-to-textbox.aspx)

Here is my setup:

On a web form I do the following:

    
            BusinessObjects.ProjectStatementReportCollection collection = new BusinessObjects.ProjectStatementReportCollection(); 
        
            collection.Query.Where(collection.Query.ProjectStatementReportId == projectStatementReportId); 
        
            DataTable dt = collection.Query.LoadDataTable(); 
        
            ProjectStatementReport report1 = new ProjectStatementReport(); 
        
            report1.DataSource = dt; 
        
            ReportViewer1.Report = report1;

BusinessObjects is a EntitySpaces's object.

In the report designer in the detail section (on panel, list control) I have a TextBox with its value set to "=Construction_Mgmt_In".
This text box's value is not being displayed.
However in ItemDataBound for the detail item I can assign textbox's value in the following way.

    
            private void detail_ItemDataBound(object sender, EventArgs e) 
        
            { 
        
                  Telerik.Reporting.Processing.DetailSection section = (Telerik.Reporting.Processing.DetailSection)sender; 
        
                  System.Data.DataRow row = (System.Data.DataRow)section.DataObject.RawData; 
        
                  Telerik.Reporting.Processing.TextBox procTextbox = (Telerik.Reporting.Processing.TextBox)section.ChildElements.Find("textBox2", true)[0]; 
        
                  procTextbox.Value = row["Construction_Mgmt_In"].ToString(); 
        
            }

I would like to be able to specify TextBox value in the designer rather than through item's ItemDataBound event.
Also do you know how to set up EntitySpaces' esDataSource as a DataSource for the report?

Thank you,
Pawel Mozdzen

General Discussions

answered on 08 Jun 2009