Questions on Reporting Forum

1 answer

107 views

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

211 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

196 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

113 views

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

121 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

190 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

53 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

2 answers

313 views

Setting table datasource to collection in parent

Hello there,

I am creating a report whose datasource is an array of a custom object. I am displaying properties from my custom objects in text boxes successfully, however I also want to populate a table from a collection that is a property on my custom object.

If I use the NeedDataSource of the table I can't see how to access the current business object from the report's data source. If I try the following in the itemDataBinding the table does not get populated with any data:

                            private void detail_ItemDataBinding(object sender, EventArgs e)         
                    {         
                        Log.Debug("detail_ItemDataBinding");         
                         DetailSection section = (DetailSection) sender;         
                        MyObject c = section.DataObject.RawData as MyObject ;         
                        tblHistory.DataSource = c.History;         
                    }         

Please can anyone advise where I am going wrong?

Many thanks, Carl

General Discussions

answered on 19 Nov 2009

2 answers

146 views

X axis label appearence

Hi,

I have added "Lab Name" as X-axis Items in the bar and Line chart.The label is cut off of if more than 30 characters

For example: if lab Name is "Angeline Elizabeth Kirby Memorial Health Center", It is showing as "Angeline Elizabeth Kirby Memor...".

i would like to show the full name in x axis without ...

How to show the x axis label without overlap and cut off?

Thanks for any help,

General Discussions

answered on 19 Nov 2009

1 answer

91 views

Show GroupFooterSection using code

Hi All,
I am binding a report to viewer using code at run time.
report details and header are displaying well.
I want to show sum/count summary information of all columns within report in "GroupFooterSection".
I have written following code

    
            Telerik.Reporting.ReportItemBase[] reportitmfooter = new ReportItemBase[ds.Tables[0].Columns.Count]; 
        
            for (int i = 0; i < ds.Tables[0].Columns.Count; i++) 
        
             { 
        
            //Fill the Group footer for show sum or count 
        
                        Telerik.Reporting.TextBox txtGroupFooter = new Telerik.Reporting.TextBox(); 
        
                        txtGroupFooter.Value = "=count([" + headcolumnname + "])"; 
        
                        txtGroupFooter.Name = "Sum" + headcolumnname; 
        
                        //textBoxDetails.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(xaxis, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(yaxis, Telerik.Reporting.Drawing.UnitType.Inch)); 
        
                        textBoxDetails.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2, Telerik.Reporting.Drawing.UnitType.Cm), new Telerik.Reporting.Drawing.Unit(0.5, Telerik.Reporting.Drawing.UnitType.Cm)); 
        
                        reportitmfooter[i] = txtGroupFooter; 
        
            } 
        
            //group footer 
        
                    Telerik.Reporting.GroupFooterSection groupFootersection = new GroupFooterSection(); 
        
                    groupFootersection.Height = new Telerik.Reporting.Drawing.Unit(0.2, Telerik.Reporting.Drawing.UnitType.Inch); 
        
                    groupFootersection.Style.BackgroundColor = System.Drawing.Color.Blue; 
        
                    groupFootersection.KeepTogether = true; 
        
                    groupFootersection.Visible = true; 
        
                    groupFootersection.Name = "rptGroupFooter"; 
        
                    groupFootersection.Items.AddRange(reportitmfooter); 
        
                    report.Items.Add(groupFootersection);

Group Footer is not displaying on web.
Please provide help.

Thank you in advanced.

General Discussions

answered on 18 Nov 2009