Home Subreports
New Blog Posts: Merging Reports - Part 1 and Part 2

subreports with parameters

edited January 2003 in Subreports
Hello there,
I desperately hope someone can help me. I'm pretty new to using Report
Builder so if this is a stupid question please bare with me. I have a
report that displays current shareholders and their premiums according to
every year they were a member. I also need to display split-members for
each shareholder with premiums for every year they were a member. So I'm
essentially displaying the same information for shareholder and split
member. I have two queries one for shareholders and one for the split
members and have linked the two data pipelines so that the shareholder query
is the master datapipline according to shareholder_code. I am passing in
two parameters into the split member query. Year and Shareholder_Code.
I've created a subreport for the split members and have placed it on the
detail band. Questions are ....
1. Is that the proper place to put the subreport?
2. Where is the best place to assign parameters to the query?
3. What is the best place to find info about ReportBuilder?
Thanks for any and all help
Denise

Comments

  • edited January 2003
    1. Yes

    2. You can use delphi query linking and rely on it to provide the parameters
    to the query, or check out this example project for a manually parameterized
    query:
    http://www.digital-metaphors.com/tips/ManualMasterDetail.zip

    3. There is a Developer's Guide PDF located in your main installation
    directory. You canprint it our since it is in PDF format, or it is also
    available in bounded paper back from us. You can order the printed version
    from our website www.digital-metaphors.com


    Cheers,

    Jim Bennett
    Digital Metaphors


  • edited January 2003
    Thanks
    A few more issues though. The report I'm using has groups for
    shareholder_code. I have to display information for each year for the
    shareholder and the same for the split_member.
    IE
    Shareholder 1
    2001 10,000 20,200
    2000 20,400 23,000
    1999 etc
    totals 30,400 43,200
    Split_member 1

    2000 10,000 20,200
    1999 20,400 23,000
    1998 etc
    totals 30,400 43,200

    Split_member 2

    2001 10,000 20,200
    2000 20,400 23,000
    1999 etc
    totals 30,400 43,200
    Total for 91,200 129,600
    Shareholder 1

    I have the master report grouped by shareholder_code and the detail by
    split_member code. The problem I'm having now is that some of the split
    member information(ie 1 of 3 split Members) is printing for some of the
    shareholders and shareholders that I know have split members have none
    showing.
    I have the subreport placed in the group footer of the master report. Is
    that the correct place to put it. I've put it in the details portion but
    then the data is displayed after each year which is not the way I need it.
    I've stepped throught the code and have seen that the record count is what
    it should be but it's just not displaying it. Are the groups the way I
    should do this or is there a better way to go about a report like this?
    Thanks for your help
    Denise
This discussion has been closed.