I had a similar problem in a claims payable solution.
I solved it by creating one table called "Reports"
Depending on the type of report you are looking for you could:
create one record per report to create, and then run some processes in the other files to create the summaries to include in your report
or you could create one record per table you need to display summaries from
or you could create a log batch in the report table where you have one record per error in the other tables.
Hans
On 11.4.2005, at 14:48, Brandon Work wrote:
All,
I'm trying to create a report that can give me summary information form 13 different tables. Every table has one similar field (lab). Each table basically is something the lab did wrong. What I am trying to do is create a report that I can run, where I chose a date range, it would add up all the problems from that time frame, sorted by the problem and the lab and then give me a total. Is this possible?
Thanks,
Brandon Work Referral Testing Lead LabCorp Dallas
-----------------------------------------
This e-mail and any attachments may contain CONFIDENTIAL information,
including PROTECTED HEALTH INFORMATION. If you are not the intended
recipient, any use or disclosure of this information is STRICTLY
PROHIBITED; you are requested to delete this e-mail and any attachments,
notify the sender immediately, and notify the LabCorp Privacy Officer at
[EMAIL PROTECTED] or call (877) 23-HIPAA / (877) 234-4722.
-- To unsubscribe: send an email to <[EMAIL PROTECTED]> FMPexperts is hosted by Ironclad Networks <http://www.ironclad.net.au/>
-- To unsubscribe: send an email to <[EMAIL PROTECTED]> FMPexperts is hosted by Ironclad Networks <http://www.ironclad.net.au/>
