Subreport madness

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

This is in Access2000 on Windows2000. Thanks in advance - I find trolling
these message boards invaluable!!!!

Perhaps I've created my own problem through dbase design (which I'm happy to
change), but I can't get a report/subreport to work. The database is
supposed to help with auditing records from an external system. I import in
a week's worth of records, flag 10 % per specialist for auditing etc. After
the records are audited I would like to report on the results. First, here's
the basic structure (minus lots of irrelevant fields) of the source tables.

tblData
ID - Autonumber (primary key)
Week - Number
Specialist - Text
ToAudit - Text
TotalDollar - Currency

tblAudit
AuditID - Autonumber
ID - Primary Key from tblData
Results - text (ok or error)
DollarErrors - Currency
AuditorName - text

I'd like a report by week for each specialist. The report should show how
many records they did for the week, the dollar amount, how many were audited,
and the dollar errors. Seem pretty straightforward (I do want some other
information, but I'm sure if I can get this to work... I can get the others
to work).

I can get each report separately based on queries, but when I try to link
them in master/child based on Specialist and week I get an empty subreport.
When I remove all links the subreport shows up but of course it's not what I
want.

What am I doing wrong? Where have I fallen off the logic train? I'm open
to any and all suggestions! I'd be happy to post additional information
(like queries etc) if anyone thinks that would help.

Thanks!

Karrie
 
KJGinNC said:
This is in Access2000 on Windows2000. Thanks in advance - I find trolling
these message boards invaluable!!!!

Perhaps I've created my own problem through dbase design (which I'm happy to
change), but I can't get a report/subreport to work. The database is
supposed to help with auditing records from an external system. I import in
a week's worth of records, flag 10 % per specialist for auditing etc. After
the records are audited I would like to report on the results. First, here's
the basic structure (minus lots of irrelevant fields) of the source tables.

tblData
ID - Autonumber (primary key)
Week - Number
Specialist - Text
ToAudit - Text
TotalDollar - Currency

tblAudit
AuditID - Autonumber
ID - Primary Key from tblData
Results - text (ok or error)
DollarErrors - Currency
AuditorName - text

I'd like a report by week for each specialist. The report should show how
many records they did for the week, the dollar amount, how many were audited,
and the dollar errors. Seem pretty straightforward (I do want some other
information, but I'm sure if I can get this to work... I can get the others
to work).

I can get each report separately based on queries, but when I try to link
them in master/child based on Specialist and week I get an empty subreport.
When I remove all links the subreport shows up but of course it's not what I
want.

What am I doing wrong? Where have I fallen off the logic train? I'm open
to any and all suggestions! I'd be happy to post additional information
(like queries etc) if anyone thinks that would help.
Click to expand...


Sorry, but from the way I read your report description, I
don't see where a subreport would come into it. Maybe I
could get a clearer picture if you would post a half dozen
sample records from each table and how you would like the
report to look.

If I am right about not needing a subreport because all you
want is total dollars and counts for each specialist, then
the issue is more a matter of getting the report's record
source query straightened out. Again, some sample data and
the desired result would be helpful in figuring out how to
approach it.
 
Thanks Marshall! You're absolutely correct.

It came to me this morning in the shower.... I was totally OVERTHINKING the
report. I've started over with a single query and things are going much
better. I'm not using a subreport at all. I'm having some issues with
conditional summing, but I'm sure if I troll the boards I'll be able to
figure that out as well. But if I can't I'll be back again looking for help.

Sometimes it just helps to write it down!

Thanks again,

Karrie
 
Back
Top