Questions on Reporting Forum

1 answer

167 views

Firstly sorry if this is a common question but I cant find an answer there are some broken links which may have helped me:

I have a data layer that does all the database stuff, I would call the get functions and populate say a Radgrid like this:

Dim jp As New JobPlan

Dim ds As Data.DataTable = jp.JobPlansByUser(User_GUID)

With radgrid_JobPlans

.DataSource = ds

.DataBind()

End With

How do I do this with a report, and where would I put the code, in the report itself or the aspx display page.
I understand I wont get the design time benifits of having a sample of the data to design the reports.

Andy

These are the broken links:
http://www.telerik.com/community/forums/reporting/community/code-library/submission/b311D-bkhgmc.aspx
http://www.telerik.com/community/support/videos/preview/b221i-cm-b221c-kcb.aspx

UPDATE:
I think I may have found it here:
http://www.telerik.com/help/reporting/designing-reports-adding-data-source-programmatically.html

Are there any other examples?

General Discussions

answered on 05 Oct 2009

1 answer

156 views

[Solved] Zoom option not available in mozilla browser

Hi,
In telerik report viewer, zoom option is not available in mozilla3.5 browser. But its available in Internet explorer. Is there any way to bring zoom option in mozilla3.5 browser too? Please help me ASAP.
Thanks....

General Discussions

answered on 05 Oct 2009

5 answers

161 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

122 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

108 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

170 views

[Solved] 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

381 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

137 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

133 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

182 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