Questions on Reporting Forum

5 answers

383 views

I need to know when to pass parameters to a subreport

Hi

I have a main report which uses an xml file (to DataTable) as a datasource containing Member ID's.
I also have a subreport for the Member's Addresses.

As each Member is processed in the main report I want to pass the MemberID to the subreport, where I then pass the MemberID into as a parameter in DataAdapter.Fill() method.

I have already implemented the passing of parameters into the DataAdapter and also implemented properties in the subreport to store the parameters being passed from the main report. As so:

    
             public partial class PersonalSubReport : Telerik.Reporting.Report 
        
                { 
        
                    private int _paramOid; 
        
                    private int _paramMemberId; 
        
                    public PersonalSubReport() 
        
                    { 
        
                        /// <summary> 
        
                        /// Required for telerik Reporting designer support 
        
                        /// </summary> 
        
                        InitializeComponent(); 
        
                        // TODO: This line of code loads data into the 'dsMemberPersonalDetails.dsMemberPersonalDetailsTable' table. You can move, or remove it, as needed. 
        
                        try 
        
                        { 
        
                            this.dsMemberPersonalDetailsTableAdapter1.Fill((this.dsMemberPersonalDetails.dsMemberPersonalDetailsTable), _paramOid, _paramMemberId); 
        
                        } 
        
                        catch (System.Exception ex) 
        
                        { 
        
                            // An error has occurred while filling the data set. Please check the exception for more information. 
        
                            System.Diagnostics.Debug.WriteLine(ex.Message); 
        
                        } 
        
                    } 
        
                    public int ParamOid 
        
                    { 
        
                        get 
        
                        { 
        
                            return _paramOid; 
        
                        } 
        
                        set 
        
                        { 
        
                            _paramOid = value; 
        
                        } 
        
                    } 
        
                    public int ParamMemberId 
        
                    { 
        
                        get 
        
                        { 
        
                            return _paramMemberId; 
        
                        } 
        
                        set 
        
                        { 
        
                            _paramMemberId = value; 
        
                        } 
        
                    }

My question is....when do I set the properties?
I tried setting them in the main report sections item databinding event but this occurs after the subreport's DataAdapter.Fill() method is called so parameters being passed are 0 and no data is being returned in the subreport.

Many thanks.

General Discussions

answered on 05 Feb 2009

1 answer

89 views

alternate detail item style problem?

i am using the code defined in knowlegde base section for showing alternate items with different styles using itemDatabound event handler.....i tried it, but having a little difficulty.....its working fine but for each odd page. Although i havent touched anything like page settings...But its showing alternate items with alternate styles in one page, and dont shows any item in next page, then shows in another page n so on....plz help me

General Discussions

answered on 05 Feb 2009

11 answers

173 views

Do not see any ajax in ReportViewer.WebForums

Is there an example of using ajax with ReportViewer? I am using 2008 Q2

General Discussions

answered on 05 Feb 2009

3 answers

75 views

Report header and filtering

Dear Community,

I am currently struggling with some minor issues regarding filtering on my data. So far, I have followed the help tutorial file located on the telerik help section, and have a filtering that looks something like this (in my detail section on the master-report page):

--------------------------------
user: foo
                    - item a
                    - item b

user: bar
                    - item c
--------------------------------

I suppose this might require a bit more detailed explaination, as the above example may not suffice. In my data I have a number of users, each user may have one or more items. If a user has more then one item bound, the user will only be shown once, hence the items are listed under the username. This is currrently what I have gotten, so far so good.

My problem comes down to splitting up the data a bit more then this. I would like to be able to have the filtered user in the header of the masterpage, not the detail section, and then have the items bound to that specific user shown in the detail section. Furthermore, for every user I filter, I would like to make a pagebreak, hence creating a new page with a new header labled the new user. So, for the above example I would like to have 2 pages, one with the user "foo" in the header, and the items "item a" and "item b" in the detail section, as well as user "bar" with item "item c" on page 2.

If anyone has a good way of implementing this, or surgestions to my problem, please let me know.

Kind regards,
Søren Engel

General Discussions

answered on 04 Feb 2009

6 answers

415 views

[Solved] Two Reports on ONE page

I would like to make a report that has two grids/outputs on it. How can I do this? The report i created only has a reportHeader, labelsGroupHeader, detail, labelGroupFooter, and Footer. The page does not seem to get any larger so I can add another little report/grid in this one report. Any ideas?

General Discussions

answered on 04 Feb 2009

3 answers

165 views

Totals in the footer and division

How do I get a line to go all the way across?

column 1 column 2

--------------------------------------
Column 1 Total Column 2 Total

General Discussions

answered on 04 Feb 2009

3 answers

110 views

Deployment Issue and Viewer Rendering

I have deployed some reports to my production server, all was going well until i ran the reports first the date fields did not display the calendar icon, then the field that is a drop down as another filter to another table is empy and a red icon is shown and showing Invalid Value. I have deployed the dll from my project and the objects from the reporting /bin. Is there anything else i need to deploy for the report to display correct and run?

Many Thanks

Mark

General Discussions

answered on 04 Feb 2009

1 answer

114 views

Datasource storage of server name/ip

I have created some reports and deployed to my server, but it occured to me that i used the external facing ip address from my development server to the live database server. Because the server is behind a firewall i should use the NAT'd ip address but cannot find where i can change the connection string settings once i the datasource has been created. Can anyone point me in the right direction please.

Mark

General Discussions