How do I combine reports?

[MNNovice]

Denburt: Good morning.

ECHOID is same for all tables. I didn’t quite understand how do you find two separate ECHOIDs? tblAP and tblPayroll (and other similar expense tables – all will have to be connected to tblECHO with ECHOID.

I am trying to create a detailed report by Fund. Funds are a 3-digit numbers starting with 8 (872, 833, 819 etc). A fund can have multiple project number which is a 5-digit numbers usually starts with 6. (63740 , 64690, 65651 etc). A project can be further separated by sub class which is a combination of numbers and digits (T217, PJ08, 0999 etc).

My questions are:

1. What would be the correct way to do a report by Fund for each ECHO?
2.How do I do a summary report for all funds?
3. How do I arrange the report in an ascending order by fund number?

The latest version of my DB is attached. Any help is much appreciated. Thanks.

[NeoPa]

I'll try to get to downloading this tonight M.

I may need to clarify the question somewhat when I have done, as I admit to finding the requirement quite difficult to understand in the terms presented.

Maybe I'll have a clearer understanding when I get the db.

@Den, I'll post back when I have the database so it can be deleted. You do the same if you beat me to it.

[Denburt]

I downloaded it yesterday and managed to look it over to some degree. Before we move on to this second report request I would like to confirm the name of the report you are using for your Echo report. The one I see is a little off so I am not sure if I am looking at the right one. I think if we verify that everything is in order on that one it will help us with your fund report since I think they will be very close to the same thing with just a few minor changes. Thanks

[MNNovice]

Denburt:

Not sure which report you are referring to. I found one inconsistency on posting 11. The correct names for the sub reports are srptEchoAP and srptEchoPay. Usually I add "Detail" or "Sum" to indicate whether it's a detailed report or a summary report.

For the fund report I attempted with srptEchoAPFund and srptEchoPayFund . For the main report I used rptECHOFund. None of these worked.

Hope this answers your questions. If not, let me know. Thanks for your help.

[MNNovice]

NeoPa:

Feel free to ask for further clarifications. I know often I struggle to pose my questions. Many thanks for your help.

[NeoPa]

I found a report called rptAPDetail (rptAPDetails).

I saw no subreports on it at all.

Am I missing something here as I'm a bit stuck on how to proceed.

[NeoPa]

Forget that. I read through the thread again and saw that I was looking for rptECHO instead. I've found that & will have a look as time allows.