Questions on Reporting Forum

5 answers

137 views

Help How to Populate Crosstab Programetically

Hi,

I want to populate cross tab at run using needDatasource. I used list as datasouce but it is not working. The following is the code I have written.

BABOKAreaSource.AddRange(new List<CrossTab>()
                                  {
                                      new CrossTab("row1","col1",34),
                                      new CrossTab("row1","col2",34),
                                      new CrossTab("row1","col3",53),
                                      new CrossTab("row4","col4",34),
                                      new CrossTab("row5","col5",53),
                                      new CrossTab("row6","col6",53)
                                  }
                    );
crosstab.DataSource = BABOKAreaSource;

Please suggest me at the earliest.

General Discussions

answered on 05 Oct 2009

0 answers

112 views

Telerik Report not Working IN IIS 7.0 with WS2008

Hi,

I am using Telerik Reporting that is working in Development environment (VS 2008). When I deploy my application in IIS7.0 + windows server 2008 it stopped working and I

am getting the following error

The http handler needed by the Report Viewer has not been registered in the application's web.config file. Add <add verb="*"path="Telerik.ReportViewer.axd" type ="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=2.9.9.202, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" /> to the system.web/httpHandlerssection of the configuration file.

Please guide me to resolve this.

General Discussions

asked on 05 Oct 2009

3 answers

75 views

Add File to Report

I have files that are stored in a database. What I want to be able to do is actually add some of these stored files into a report that I am creating. Is this possible with Telerik Reporting? If so, are there any examples? Thanks.

PJ

General Discussions

answered on 05 Oct 2009

2 answers

147 views

Text overlaps on last page on export

I am having a problem with text over lapping on the last page. This happens pretty regularly. The text is contained inside one htmltextbox and it one string. The text is in the order it is supposed to be but for some reason the line spacing is off and is causing the text to overlap and become unreadable. See the screen shot as an example.

General Discussions

answered on 02 Oct 2009

2 answers

342 views

Running total

Hi, i have a group that has a sum() calculated on a field.

After all groups have been rendered and their sub-totals are done

i need a sum of these sub-totals in the groups displayed at the bottom

of the report.

How do i setup my sum function in a simple way ?

/Daniel

General Discussions

answered on 02 Oct 2009

1 answer

120 views

Aggregate Sum

Hi,

I'm using Enterprise Library to return a DataSet(from a stored procedure) that i use as my datasource to my report.

I have the report almost setup for me but i have trouble with one thing. The report has two columns

NoOfHours
DebitPerUnitHour

Example:

If one detail row has NoOfHours=8 and DebitPerUnitHour=$600, then i have a third column that calculates [=Fields.NoOfHours * Fields.DebitPerUnitHour].

Then I need in my footersection in my group to SUM the values from this third column. I know its simple to sum on an existing Field from satasource, but how to sum on an expression?

/Daniel

General Discussions

answered on 02 Oct 2009

1 answer

114 views

dynamically handling report classes in the report viewer

Hi,

I have created a UserControl (ascx) with the Report Viewer. I am creating instances of my report classes dynamically. My Report viewer code looks like this:

    
                        if (!Page.IsPostBack)  
        
                        {  
        
                            if (!string.IsNullOrEmpty(_reportName))  
        
                            {  
        
                                PageManagementDataContext db = new PageManagementDataContext();  
        
                                var rec = db.ReportGetByReportIDAndLCID(Convert.ToInt32(_reportName), "is-IS").FirstOrDefault();  
        
                                if (rec != null)  
        
                                {  
        
                                    Object obj = Activator.CreateInstance(Type.GetType("Orbit.Benjamin.Reports." + rec.systemname));  
        
                                    Telerik.Reporting.Report rpt = (Telerik.Reporting.Report)obj;  
        
                                    ReportViewer1.Report = rpt;  
        
                                    ReportViewer1.ZoomMode = Telerik.ReportViewer.WebForms.ZoomMode.Percent;  
        
                                    ReportViewer1.ZoomPercent = 100;  
        
                                    ReportViewer1.Style["height"] = "30cm";  
        
                                }  
        
                            }  
        
                        }  
        
                    }  
        
                    protected object GetNewType(string classname)  
        
                    {  
        
                        Type type = Type.GetType(classname, true);  
        
                        object newInstance = Activator.CreateInstance(type);  
        
                        return newInstance;  
        
                    }

Everyting was working fine until I tried to add parameters to a report. I'm adding a parameter using this code:

    
            var enterpr = db.EnterprisesAndDivisionsGetAll().Where(d => d.partyroleid != 4);  
        
            var parameter = this.ReportParameters["Company"];  
        
            parameter.UI.AvailableValues.DataSource = enterpr.Select(o => o.partyname);  
        
            parameter.Value = enterpr.Select(o => o.id);

This causes my class instance to fail. I suspect I need to do something to also handle the parameters when creating the class instance. Can someone point me in the right direction please.

reg.
Axel

General Discussions

answered on 02 Oct 2009

7 answers

157 views

Wizard windows disappears

Hi

When creating a report using the Wizard, the Wizard window disappears when I am selecting fields for list items, groups etc.
This seems to happen when I try to expand the data explorer treeview and click the +/- boxes to expand specific fields.

Is this a known bug ?

reg.
Axel G.

General Discussions

answered on 02 Oct 2009

5 answers

165 views

Installation error

When installing - I'm getting - Failed to execute SQL string, error detail: Invalid object name 'master.sys.databases'., SQL key: createAdventureWorks1.........

I'm installing on XP and trying to point to an existing SQL Server 2000 database.

Thanks,

Jason

General Discussions

answered on 01 Oct 2009

1 answer

279 views

Generating reports from multithreaded applications

Hi guys,

I am working on an application which uses Telerik Reports to generate reports using the PDF rendering extension. The reporting logic in the application allows the users to schedule the reports generation. Because of performance and scalability reasons, the reports are generated (rendered to PDF) each on a different thread.

Now, imagine that different users schedule the same report but with different parameters to run at the same time. We would then have multiple calls to the Telerik.Reporting.Processing.ReportProcessor.Render method from different threads, passing to each call a different instance of the same Telerik.Reporting.Report class. It seems that there are some problems with this scenario. The reports will be rendered, but some of them with errors like "An error has occured while processing TextBox 'TextBox1': Index was outside the bounds of the array.".

I believe that thread safety is a very important functionality, therefore I hope you have a workaround for this or at least consider fixing it as soon as possible.

Regards,

Daniel

General Discussions

answered on 30 Sep 2009