Questions on Reporting Forum

3 answers

329 views

I'm having a really frustrating time trying to get the reports to work. I've created a report like below:

    
            Partial Public Class JuvenileAges 
        
                Inherits Telerik.Reporting.Report 
        
                Public Sub New() 
        
                    InitializeComponent() 
        
                    Dim datatable As DataTable = datatable returned from business class  
        
                    Me.DataSource = datatable 
        
                End Sub 
        
            End Class

I've set up the report viewer like this:

    
            <telerik:reportviewer id="ReportViewer1" runat="server" height="438px" width="760px"></telerik:reportviewer>

Code for the report viewer like this:

    
            Dim rptJuvenileAges As New JuvenileAges() 
        
            ReportViewer1.Report = CType(rptJuvenileAges, Telerik.Reporting.IReportDocument)

When I run the page I see the reportviewer controls on it, but I don't see any data. I know that the datatable is being filled because I ran sql profiler to check that the data was being called.

When I go into design view of the report and right click > View > Data Explorer, I get 'No Data Source' - I guess because I'm adding it programatically.

How do I get the report data to show up in the reportviewer? Any tips much appreciated, as I'm just getting started with reporting.

cheers,

Steve

General Discussions

answered on 24 Nov 2009

3 answers

336 views

Drawing an average line on a bar chart

I'm new to telerik reporting tools and i wanna draw an average line on a bar chart surface like the following image can any one give me a hand
thanx in advance
p.s
I have seen the scale break property of the chart object, and I set its value tolerance to the average value from the code behind file and used it as the average line, but the thing is as the pictures shows I wanna make the line to appear behind the chart bars not above them is there a way for me to achieve this please help me!

General Discussions

answered on 24 Nov 2009

0 answers

128 views

Batch Processing Best Practice

We're currently trying out Telerik reporting to see if it will work for our situation. So far it is working out just fine, but I was curious if someone could point out some best practices for batch processing.

We have about 20,000 (will continue to grow) individual reports we have to generate every month to PDF and then store in our DB.

What would be the best way to go about doing this as fast as possible using Telerik Reporting? What is a reasonable amount of time one should expect this to take?

General Discussions

asked on 23 Nov 2009

1 answer

131 views

Reporting Bug Cost Me 6 Hours

Here's a bug that you REALLY don't want to come across

I have a huge product catalog in a database with pictures that reside on the file system. The database holds a uri to the picture.

I spent 6 hours in the designer trying to work out why I was getting blank pages on every other page. Every online comment suggested that my designer had items outside the allotted width, but I KNEW this was not the case with me.

I also saw that there was a bug fix in the latest release which suggested it may fix my problem - it didnt.

After 6 hours I was ready to give up when I started returning a limited number of rows (100) from the DB - it worked.

So I wondered if somehow a single product has an image issue that was throwing a single page out of size (and the rest of the document adopting the extra width). I skimmed over each page in the catalog and could find nothing.

I then just went back to 100 rows and kept increasing it until the report broke.

Eventually I found the culprit - a record where the image uri doesnt exist.

It seems that an invisible error message is put in place of the image. This error message takes up most of the width, pushing you into 2 pages width - however, you dont actually see anything wrong.

Theres 6 hours of my life I'm not going to get back.

General Discussions

answered on 23 Nov 2009

5 answers

267 views

Subreport All On One Page

Hi,

I have a report with multiple sub reports. I have tried to set every KeepTogether property to false but everything still comes up on one page. What else should I be looking for?

Thanks,
Darren

General Discussions

answered on 23 Nov 2009

6 answers

227 views

Q3 Reporting vs. EntitySpaces Entity

Hi,
I just upgraded to 2009 Q3 Reporting and all my reports are broken, saying:

An error occured while processing TextBox 'txtNumber':
The expression contains object 'Number' that is not defined in the current context.

the field Format is:
this.txtNumber.Value = "=Format(\"Invoice Nr.: {0}\", Fields.Number)";

and the Entity is assigned in NeedDataSource event.

General Discussions

answered on 21 Nov 2009

1 answer

142 views

[Solved] Export 2nd or later page in TIFF format

Hi All,

I am new to telerik reporting tool. I am evaluating this for Web application.
I have generated sample report having two pages. I Clicked on next button to view second page.
Then selects Export to image option and hit "export" link. A image is save on local, when open it is shows page 1 data only.
How can i export to image with other pages data. Please provide me help on this.
I have generated report with programmatically.

Thank you in advance.

General Discussions

answered on 20 Nov 2009

1 answer

137 views

Multivalue Parameter Help

Hi there.

I have a multivalued parameter called of type int called "Person". With that in mind, I have 2 questions:

1. How do I pull the data out programmatically? Basically, I want to do something like this:

foreach (int personId in (List)this.ReportParameters["Person"].Value)
{
myList.Add(personId);
}

I can't quite figure out how to get at the collection and extract the values.

2. Along those same lines, how would I programmatically populate a multivalue parameter?

Thanks, Mike

General Discussions

answered on 20 Nov 2009

9 answers

218 views

Parameter box disappears on preview...

The parameter box disappears when I have a dropdown parameter after pressing preview and data is not retrieved. It disappears even when there are other parameters in the box (all input types). It works with multi-select, but I cannot use that with the reports I'm trying to generate. The datasource is currently a LINQ object. It also happens with data I grab using the built in wizard.

Help!

    
            namespace Reporting 
        
            { 
        
                using System; 
        
                using System.ComponentModel; 
        
                using System.Drawing; 
        
                using System.Windows.Forms; 
        
                using Telerik.Reporting; 
        
                using Telerik.Reporting.Drawing; 
        
                using IRWLReporting_Rules; 
        
                /// <summary> 
        
                /// Summary description for Report1. 
        
                /// </summary> 
        
                public partial class ActivityRegistrationReport : Telerik.Reporting.Report 
        
                { 
        
                    public ActivityRegistrationReport() 
        
                    { 
        
                        /// <summary> 
        
                        /// Required for telerik Reporting designer support 
        
                        /// </summary> 
        
                        InitializeComponent(); 
        
                        try 
        
                        { 
        
                            this.ReportParameters["ActivityId"].UI.AvailableValues.DataSource = new Reporting_Rules().GetActivityDataForReportParamDropdown(); 
        
                        } 
        
                        catch (Exception ex) 
        
                        { 
        
                            throw ex; 
        
                        } 
        
                    } 
        
                    private void ActivityRegistrationReport_NeedDataSource(object sender, EventArgs e) 
        
                    { 
        
                        Telerik.Reporting.Processing.Report report = (Telerik.Reporting.Processing.Report)sender; 
        
                        report.DataSource = new Reporting_Rules().GetActivityRegistrantsForActivityReport(Convert.ToInt32(report.Parameters["ActivityId"])); 
        
                    } 
        
                } 
        
            }

General Discussions

answered on 20 Nov 2009

1 answer

68 views

ActiveRegion Class Defined But Not Usable

Hello,

Please clarify:

I see from the documentation that there is an ActiveRegion Class defined for Telerik.Reporting.Charting, but not supported?
http://www.telerik.com/help/reporting/telerik.reporting-telerik.reporting.charting.activeregion.html

For example, I can't seem to be able to set series item tooltips, URLs, etc.

Thanks,
Jon

General Discussions

answered on 19 Nov 2009