Jim
After you have run the view data, try inserting all view data into temp tables and base report (same one you're doing now except use temp tables) on the Temp tables. Should be easy and fast. Bill Eyring From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Tuesday, June 25, 2019 4:41 PM To: [email protected] Subject: [RBASE-L] - sub reports I have a report I am making that will have three sub reports. Each sub report is based on a separate table. Here is what I am trying to accomplish efficiently. Each sub report is based on a common field of the previous sub report and one sub report has a common field with the main parent report. So it goes: Parent report. Sub report with one common field to the parent. Sub report with one common field to the sub report. Sub report with one common field with the second sub report. Each sub report will have sub totals. So what is the most efficient way to get other sub totals that are based on two and sometimes all three sub reports? The problem is the totals from each sub report are based on different column names though the information is the same (such as minutes). That is the reason I cannot use the DB calc for this. Plus I will need to sometimes combine a subtotal with another subtotal and you cannot do that with DB calc. I hope I was able to explain this well enough. I am able to get these totals with views but that slows things down a bit for the report. I already have 8 views on this report just to get the information I want. James Belisle Making Information Systems People Friendly Since 1990 cid:[email protected] -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/DM6PR02MB4539C7A927ABAE9B825783FCA0E30%40DM6PR02MB4539.namprd02.prod.outlook.com <https://groups.google.com/d/msgid/rbase-l/DM6PR02MB4539C7A927ABAE9B825783FCA0E30%40DM6PR02MB4539.namprd02.prod.outlook.com?utm_medium=email&utm_source=footer> . For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/00e801d53034%24b1c1fa10%241545ee30%24%40com. For more options, visit https://groups.google.com/d/optout.
