Hello,


Here is the situation,

I have around 18 reports for 18 locations.

Report 1 ------ 1 Main report and two subreports.

Main report has Collections from Check

Subreport 1 has collection from cash

Subreport 2 has information about which bank has it been deposited to.

So lets consider how each report works.

Report for location A prompts you for three dates which are three date  parameters  one each for main report, subreport 1 and subreport 2.

So Once you run report for Location A, you get prompted by three parameters which can be same or different, depends on user for which dates hew would like to view the information.

My requirement is


I need a report which should include all these 18 reports.

So One report, prompting me for one date (which should pass same date to all date parameters in  all 18 reports) and then I should get all these reports in one shot.


There are 3 tables involved on the whole.

Table A-- Loc, num,type
Table B --- LocB, Loc#,LocationTypeB
Table C ----- Locationtype



One field called "Loc" is in Table A which is a foreign key referncing "LOcB" field in table B.

One field in Table B is "LOC#" which is a unique three digit number that differentiates these 18 locations.

The table structure is like this

Table C has one field called "Locationtype" and this is a primary key with notnull constraint.

So in database expert I join tables as

TableA.Loc=TableB.LocB
Table C.Locationtype = tableB.Location_typeB

All reports have same query except that the Loc# is different in selection criteria.

So I tried taking one report as skeleton and

In the selection expert I choose "LOC#" in Table B for all 18 locations.
Like this {table.field} is "011","022",,,,,,,,,,,, "088" for 18 locations

Then did a group by for Loc#


The out put is like this

Group1

Collections from check -----Loc 1
011

Collections from check -----Loc 1


022

Collections from check -----Loc 2








    088    ''
Collections from check -----Loc 18

Then Collections from cash which is a subreport.


has same thing


Group1

Collections from cash -----Loc 1
011

Collections from cash -----Loc 1


022

Collections from cash -----Loc 2








    088    ''
Collections from cash -----Loc 18.


My requirement is

Locaation1
collection from check
collection from cash
which bank is it getting deposited to.

location 2
collection from check
collection from cash
which bank is it getting deposited to.


'
'
'

location 18
collection from check
collection from cash
which bank is it getting deposited to.


Plan 2:
So I planned to include all reports as subreports .

Openeed a plain report and inserted following as subreports in group footers.

1)location 1 main report
2)Location 1 subreport1
3)Location 1 Subreport 2

4)location 2 main report
5)Location 2 subreport1
6)Location 2 Subreport 2

''''
;
'
'
'
 Finally I will have 54 subreports, 3 for each, total being 18. The report looks fine but it prompts for 54 parameters which are dates for 18 reports.

Is there any way that I can suppress all these dates such that the user can give only one date and it is same that goes to all 54 date prompts.


Else is there any better way of developing these reports.


Please repy as this is very urgent.


Thanks
Namita