mnmdesigns
MIS
Hi all,
I am using CR 10 with SQL server 2000. I have a report that contains two subreports in the report header. The main report has three parameters and one group. The parameters are
1. fromDate(date)
2. toDate(date)
3. levelinfoid(number)
The problem I am having is that the main report is using the parameters but the subreports are returing all the data in the database and not restricting them by parameters. I have linked the subreports on the field that the group is based on. Can someone please guide me in the right direction? I have tried suggestions from other posts but cant seem to figure it out.
My main report selection formula is:
(({cr_all_informal.lvl1id} = {?levelinfoid})
or
({cr_all_informal.lvl2id} = {?levelinfoid})
or
({cr_all_informal.lvl3id} = {?levelinfoid})
or
({cr_all_informal.lvl4id} = {?levelinfoid}))
and
{cr_all_informal.initial_contact} in {?fromDate} to {?toDate}
Any help would be appreciated.
Thanks!
I am using CR 10 with SQL server 2000. I have a report that contains two subreports in the report header. The main report has three parameters and one group. The parameters are
1. fromDate(date)
2. toDate(date)
3. levelinfoid(number)
The problem I am having is that the main report is using the parameters but the subreports are returing all the data in the database and not restricting them by parameters. I have linked the subreports on the field that the group is based on. Can someone please guide me in the right direction? I have tried suggestions from other posts but cant seem to figure it out.
My main report selection formula is:
(({cr_all_informal.lvl1id} = {?levelinfoid})
or
({cr_all_informal.lvl2id} = {?levelinfoid})
or
({cr_all_informal.lvl3id} = {?levelinfoid})
or
({cr_all_informal.lvl4id} = {?levelinfoid}))
and
{cr_all_informal.initial_contact} in {?fromDate} to {?toDate}
Any help would be appreciated.
Thanks!