subreports with parameters

rbuser

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

digitalmetaphors

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

rbuser

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