subreport question

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

Guest

I have a report with a subreport which I think works great but, my boss would
like the information that appears only once (within a header section sorted
by EmployeeName) to appear all together by date.

Example would be, an employee would have only one entry for this record per
day, but within the details section, they may have many entries for one day.
So they want, the report info, that appears only once for a day to appear in
consecutive Date order (with only one header info on top) and then the detail
information to appear below it, by consecutive date order under that
information.

Now I have messed with this for hours. Can this even be done?
 
Melissa said:
I have a report with a subreport which I think works great but, my boss would
like the information that appears only once (within a header section sorted
by EmployeeName) to appear all together by date.

Example would be, an employee would have only one entry for this record per
day, but within the details section, they may have many entries for one day.
So they want, the report info, that appears only once for a day to appear in
consecutive Date order (with only one header info on top) and then the detail
information to appear below it, by consecutive date order under that
information.
Click to expand...


I do not understand your explanation of hoe you want the
result to look. My best guess at this point is that you
want to group on the emplyee name field (View menu - Sorting
and Grouping) and put the employee specific data in the
group header section.
 
I do that and it does work how it is suppose to.
I guess to explain it better, they want two Details section. first detail
would be from the first report. This report would list all entries by
employee by date, consecutively, Then under that the 2nd report information
would appear to list the same employees entry for those dates. So if my
report parameters are by 12/01/05 thru 12/31/05 then I "the employee" would
have one entry per day from report one. 12/01;12/02 etc. Then under that, all
my entries from report two in date order.

I guess what they want is all information from both of these reports kept
together by Employee. Both reports do this when a part from each other, but,
there is only one "Detail" section. I guess I need two Details section??

I hope I am making sense.
 
I'm afraid that I still don't have a grasp of what you're
describing. Maybe what you want is to just move the
subreport to the employee group footer section??

If that's not a good guess, could you include a simple
example of of what the report looks like and how you want it
to look.
 
Here is an example of what "they" want.

rpt1 record- 12/01/2005, employee, data, data, data, etc..
12/02/2005 same employee, data, data, data, etc.
12/03/2005 same employee, data data etc.
rpt2 record- 12/01/2005 same employee, data, data, data, etc..


They basically want the "employee's records" from both tables kept together
consectuatively. So me as an employee, the report would list all my entries
from report 1 and report 2 together for me, then begin again for the next
employee.

Hope this helps. Thanks for your help


Marshall Barton said:
I'm afraid that I still don't have a grasp of what you're
describing. Maybe what you want is to just move the
subreport to the employee group footer section??

If that's not a good guess, could you include a simple
example of of what the report looks like and how you want it
to look.
--
Marsh
MVP [MS Access]

I do that and it does work how it is suppose to.
I guess to explain it better, they want two Details section. first detail
would be from the first report. This report would list all entries by
employee by date, consecutively, Then under that the 2nd report information
would appear to list the same employees entry for those dates. So if my
report parameters are by 12/01/05 thru 12/31/05 then I "the employee" would
have one entry per day from report one. 12/01;12/02 etc. Then under that, all
my entries from report two in date order.

I guess what they want is all information from both of these reports kept
together by Employee. Both reports do this when a part from each other, but,
there is only one "Detail" section. I guess I need two Details section??
Click to expand...
Click to expand...
 
Melissa said:
Here is an example of what "they" want.

rpt1 record- 12/01/2005, employee, data, data, data, etc..
12/02/2005 same employee, data, data, data, etc.
12/03/2005 same employee, data data etc.
rpt2 record- 12/01/2005 same employee, data, data, data, etc..


They basically want the "employee's records" from both tables kept together
consectuatively. So me as an employee, the report would list all my entries
from report 1 and report 2 together for me, then begin again for the next
employee.
Click to expand...


Did you try placing the rpt2 subreport in the employee group
footer section? I think that's what you're looking for.
 
Yes, that doesn't work.

Marshall Barton said:
Did you try placing the rpt2 subreport in the employee group
footer section? I think that's what you're looking for.
Click to expand...
 
That's two "doesn't work" explanations I gotten today so I
may be a little frustrated trying to figure out what you
want and why I don't understand what I suggested isn't
taking care of the issue.

My understanding is that rp1 is the main report and rpt2 is
the subreport. Both of them list some data grouped by
employee and then sorted by a date field. The final result
should look like

EmployeeA group header
date1 some data in main report detail1
date2 some data in main report detail2
EmployeeA group footer
date1 some data in subreport detail1
date2 some data in subreport detail2
EmployeeB group header
date3 some data in main report detail3
date4 some data in main report detail4
EmployeeB group footer
date3 some data in subreport detail3
date4 some data in subreport detail4
 
Yes, that is exactly right. That is how I originally set it up (I think the
way it should be.) But, they want:

Employee A group header
date1 data in main report detail1
date2 data in main report detail 1
date3 data in main report detail 1
etc.
All data on Same Employee, by date, listed for "report 1" by date
then after that,
Report 2 data below on same employee listed by date. Report 2 is coming from
the
many side of the relationship.

Then this would start again for next employee B.

I have tried everything I know and gave up. I do not think this can be done.


Marshall Barton said:
That's two "doesn't work" explanations I gotten today so I
may be a little frustrated trying to figure out what you
want and why I don't understand what I suggested isn't
taking care of the issue.

My understanding is that rp1 is the main report and rpt2 is
the subreport. Both of them list some data grouped by
employee and then sorted by a date field. The final result
should look like

EmployeeA group header
date1 some data in main report detail1
date2 some data in main report detail2
EmployeeA group footer
date1 some data in subreport detail1
date2 some data in subreport detail2
EmployeeB group header
date3 some data in main report detail3
date4 some data in main report detail4
EmployeeB group footer
date3 some data in subreport detail3
date4 some data in subreport detail4
--
Marsh
MVP [MS Access]

Yes, that doesn't work.
Click to expand...
Click to expand...
 
Maybe there's a meaning to "Same Employee" that I'm just not
picking up. I thought it meant all the data for a single
employee.

I think your example's "etc" came a little too early. What
you posted looks just like the first part of what I posted
so I still don't understand the distinction you're trying to
make. Could you expand it to include two employees and some
stuff from the subreport?
 
Ok I apologize I haven't explained properly,

Data from Rpt1 would come first by date.
So all entries from Melissa would list by date from Rpt 1.

Example
All entries from Rpt 1 by Melissa from December would list:
Melissa
12/01
12/02
12/03
etc.

Then after the last entry for Melissa from December, Rpt 2
comes up after (12/31)and lists each entry for Melissa for December as well
from the 2nd rpt.
12/01
12/02
12/03

So all entries from both tables stay together by employee but, all entries
from
rpt1 by date come first then all entries from rpt2 comes next. This repeats
for all
employees.

Marshall Barton said:
Maybe there's a meaning to "Same Employee" that I'm just not
picking up. I thought it meant all the data for a single
employee.

I think your example's "etc" came a little too early. What
you posted looks just like the first part of what I posted
so I still don't understand the distinction you're trying to
make. Could you expand it to include two employees and some
stuff from the subreport?
--
Marsh
MVP [MS Access]

Yes, that is exactly right. That is how I originally set it up (I think the
way it should be.) But, they want:

Employee A group header
date1 data in main report detail1
date2 data in main report detail 1
date3 data in main report detail 1
etc.
All data on Same Employee, by date, listed for "report 1" by date
then after that,
Report 2 data below on same employee listed by date. Report 2 is coming from
the
many side of the relationship.

Then this would start again for next employee B.

I have tried everything I know and gave up. I do not think this can be done.
Click to expand...
Click to expand...
 
I also apologize for not getting it. You have explained
what I take to be the same thing several times now. From
everything I can see about what you want, it can be done
using the subreport in the Employee Group footer section.
You did say that that "doesn't work", but I still don't
understand what it actually produced nor what's wrong with
it.

I do think it should work, so maybe I have misscomunicated
something and maybe I can figure out what if you add to the
example to show what it is doing wrong. Please include at
least a little bit of a second employee so I can see how
that fits into what you're describing.
--
Marsh
MVP [MS Access]

Ok I apologize I haven't explained properly,

Data from Rpt1 would come first by date.
So all entries from Melissa would list by date from Rpt 1.

Example
All entries from Rpt 1 by Melissa from December would list:
Melissa
12/01
12/02
12/03
etc.

Then after the last entry for Melissa from December, Rpt 2
comes up after (12/31)and lists each entry for Melissa for December as well
from the 2nd rpt.
12/01
12/02
12/03

So all entries from both tables stay together by employee but, all entries
from
rpt1 by date come first then all entries from rpt2 comes next. This repeats
for all
employees.

Marshall Barton said:
Maybe there's a meaning to "Same Employee" that I'm just not
picking up. I thought it meant all the data for a single
employee.

I think your example's "etc" came a little too early. What
you posted looks just like the first part of what I posted
so I still don't understand the distinction you're trying to
make. Could you expand it to include two employees and some
stuff from the subreport?
--
Marsh
MVP [MS Access]

Yes, that is exactly right. That is how I originally set it up (I think the
way it should be.) But, they want:

Employee A group header
date1 data in main report detail1
date2 data in main report detail 1
date3 data in main report detail 1
etc.
All data on Same Employee, by date, listed for "report 1" by date
then after that,
Report 2 data below on same employee listed by date. Report 2 is coming from
the
many side of the relationship.

Then this would start again for next employee B.

I have tried everything I know and gave up. I do not think this can be done.


:
That's two "doesn't work" explanations I gotten today so I
may be a little frustrated trying to figure out what you
want and why I don't understand what I suggested isn't
taking care of the issue.

My understanding is that rp1 is the main report and rpt2 is
the subreport. Both of them list some data grouped by
employee and then sorted by a date field. The final result
should look like

EmployeeA group header
date1 some data in main report detail1
date2 some data in main report detail2
EmployeeA group footer
date1 some data in subreport detail1
date2 some data in subreport detail2
EmployeeB group header
date3 some data in main report detail3
date4 some data in main report detail4
EmployeeB group footer
date3 some data in subreport detail3
date4 some data in subreport detail4


Melissa wrote:
Yes, that doesn't work.


Melissa wrote:
Here is an example of what "they" want.

rpt1 record- 12/01/2005, employee, data, data, data, etc..
12/02/2005 same employee, data, data, data, etc.
12/03/2005 same employee, data data etc.
rpt2 record- 12/01/2005 same employee, data, data, data, etc..


They basically want the "employee's records" from both tables kept together
consectuatively. So me as an employee, the report would list all my entries
from report 1 and report 2 together for me, then begin again for the next
employee.


:
Did you try placing the rpt2 subreport in the employee group
footer section? I think that's what you're looking for.
Click to expand...
Click to expand...
Click to expand...
 
Ok, I will try to do better:

Main Report will have two subreports:
First rpt will be Employee Hrs: Only one record can be entered into this
table per day.
Second rpt will be; Employee Correspondense Completed. This table can have
more multiple entries for one day by employee, if necessary.

Now my Main rpt is based on the many side of the relationship tbl: Correp
Completed.
I have these fields within the Details section, Sorted by Date then Employee
Name.

My sub Rpt is based on Employee Hrs. This subrpt I put within the
EmployeeName Header. The EmployeeName Footer holds the totals on
Correspondence Completed by employee.

So here is how they want the report to look like.
SubRpt from EmployeeHrs
Employee: Melissa
12/01 HrsAbsent, HrsMeeting, HrsClass, #IncomingCalls, #OutgoingCalls,etc, etc
12/02 HrsAbsent, HrsMeeting, HrsClass, #IncomingCalls, #OutgoingCalls, etc,
etc.
12/03 HrsAbsent, HrsMeeting, HrsClass, #IncomingCalls, #OutgoingCalls, etc,
etc,
(listed directly under Melissa's data for Hrs will list the Correspondence
Completed by
melissa for each of those days)
(AuditTypes must be different if more than one entry in this tbl per day.)
Melissa
12/01 AuditType, BeginningInventory, EndingInventory, Billing, Assessment, etc
12/01 AuditType, BeginningInventory, EndingInventory, Billing, Assessment, etc
12/02 AuditType, BeginningInventory, EndingInventory, Billing, Assessment, etc
this will go on for Melissa for all records under this employee.

Then it would begin again for next employee. Does this help?
Thanks for all your help. I'm sorry if I am confusing you.











Marshall Barton said:
I also apologize for not getting it. You have explained
what I take to be the same thing several times now. From
everything I can see about what you want, it can be done
using the subreport in the Employee Group footer section.
You did say that that "doesn't work", but I still don't
understand what it actually produced nor what's wrong with
it.

I do think it should work, so maybe I have misscomunicated
something and maybe I can figure out what if you add to the
example to show what it is doing wrong. Please include at
least a little bit of a second employee so I can see how
that fits into what you're describing.
--
Marsh
MVP [MS Access]

Ok I apologize I haven't explained properly,

Data from Rpt1 would come first by date.
So all entries from Melissa would list by date from Rpt 1.

Example
All entries from Rpt 1 by Melissa from December would list:
Melissa
12/01
12/02
12/03
etc.

Then after the last entry for Melissa from December, Rpt 2
comes up after (12/31)and lists each entry for Melissa for December as well
from the 2nd rpt.
12/01
12/02
12/03

So all entries from both tables stay together by employee but, all entries
from
rpt1 by date come first then all entries from rpt2 comes next. This repeats
for all
employees.

Marshall Barton said:
Maybe there's a meaning to "Same Employee" that I'm just not
picking up. I thought it meant all the data for a single
employee.

I think your example's "etc" came a little too early. What
you posted looks just like the first part of what I posted
so I still don't understand the distinction you're trying to
make. Could you expand it to include two employees and some
stuff from the subreport?
--
Marsh
MVP [MS Access]


Melissa wrote:
Yes, that is exactly right. That is how I originally set it up (I think the
way it should be.) But, they want:

Employee A group header
date1 data in main report detail1
date2 data in main report detail 1
date3 data in main report detail 1
etc.
All data on Same Employee, by date, listed for "report 1" by date
then after that,
Report 2 data below on same employee listed by date. Report 2 is coming from
the
many side of the relationship.

Then this would start again for next employee B.

I have tried everything I know and gave up. I do not think this can be done.


:
That's two "doesn't work" explanations I gotten today so I
may be a little frustrated trying to figure out what you
want and why I don't understand what I suggested isn't
taking care of the issue.

My understanding is that rp1 is the main report and rpt2 is
the subreport. Both of them list some data grouped by
employee and then sorted by a date field. The final result
should look like

EmployeeA group header
date1 some data in main report detail1
date2 some data in main report detail2
EmployeeA group footer
date1 some data in subreport detail1
date2 some data in subreport detail2
EmployeeB group header
date3 some data in main report detail3
date4 some data in main report detail4
EmployeeB group footer
date3 some data in subreport detail3
date4 some data in subreport detail4


Melissa wrote:
Yes, that doesn't work.


Melissa wrote:
Here is an example of what "they" want.

rpt1 record- 12/01/2005, employee, data, data, data, etc..
12/02/2005 same employee, data, data, data, etc.
12/03/2005 same employee, data data etc.
rpt2 record- 12/01/2005 same employee, data, data, data, etc..


They basically want the "employee's records" from both tables kept together
consectuatively. So me as an employee, the report would list all my entries
from report 1 and report 2 together for me, then begin again for the next
employee.


:
Did you try placing the rpt2 subreport in the employee group
footer section? I think that's what you're looking for.
Click to expand...
Click to expand...
Click to expand...
 
Smacking forehead, I never realized there were two sub
reports and that the first subreport is in the main report's
Employee header. If you want the second subreport to
immediately follow the first subreport, can't you just put
them both in the Employee header section one above the
other?
--
Marsh
MVP [MS Access]

Main Report will have two subreports:
First rpt will be Employee Hrs: Only one record can be entered into this
table per day.
Second rpt will be; Employee Correspondense Completed. This table can have
more multiple entries for one day by employee, if necessary.

Now my Main rpt is based on the many side of the relationship tbl: Correp
Completed.
I have these fields within the Details section, Sorted by Date then Employee
Name.

My sub Rpt is based on Employee Hrs. This subrpt I put within the
EmployeeName Header. The EmployeeName Footer holds the totals on
Correspondence Completed by employee.

So here is how they want the report to look like.
SubRpt from EmployeeHrs
Employee: Melissa
12/01 HrsAbsent, HrsMeeting, HrsClass, #IncomingCalls, #OutgoingCalls,etc, etc
12/02 HrsAbsent, HrsMeeting, HrsClass, #IncomingCalls, #OutgoingCalls, etc,
etc.
12/03 HrsAbsent, HrsMeeting, HrsClass, #IncomingCalls, #OutgoingCalls, etc,
etc,
(listed directly under Melissa's data for Hrs will list the Correspondence
Completed by
melissa for each of those days)
(AuditTypes must be different if more than one entry in this tbl per day.)
Melissa
12/01 AuditType, BeginningInventory, EndingInventory, Billing, Assessment, etc
12/01 AuditType, BeginningInventory, EndingInventory, Billing, Assessment, etc
12/02 AuditType, BeginningInventory, EndingInventory, Billing, Assessment, etc
this will go on for Melissa for all records under this employee.

Then it would begin again for next employee. Does this help?
Thanks for all your help. I'm sorry if I am confusing you.


Marshall Barton said:
I also apologize for not getting it. You have explained
what I take to be the same thing several times now. From
everything I can see about what you want, it can be done
using the subreport in the Employee Group footer section.
You did say that that "doesn't work", but I still don't
understand what it actually produced nor what's wrong with
it.

I do think it should work, so maybe I have misscomunicated
something and maybe I can figure out what if you add to the
example to show what it is doing wrong. Please include at
least a little bit of a second employee so I can see how
that fits into what you're describing.
--
Marsh
MVP [MS Access]

Ok I apologize I haven't explained properly,

Data from Rpt1 would come first by date.
So all entries from Melissa would list by date from Rpt 1.

Example
All entries from Rpt 1 by Melissa from December would list:
Melissa
12/01
12/02
12/03
etc.

Then after the last entry for Melissa from December, Rpt 2
comes up after (12/31)and lists each entry for Melissa for December as well
from the 2nd rpt.
12/01
12/02
12/03

So all entries from both tables stay together by employee but, all entries
from
rpt1 by date come first then all entries from rpt2 comes next. This repeats
for all
employees.

:

Maybe there's a meaning to "Same Employee" that I'm just not
picking up. I thought it meant all the data for a single
employee.

I think your example's "etc" came a little too early. What
you posted looks just like the first part of what I posted
so I still don't understand the distinction you're trying to
make. Could you expand it to include two employees and some
stuff from the subreport?
--
Marsh
MVP [MS Access]


Melissa wrote:
Yes, that is exactly right. That is how I originally set it up (I think the
way it should be.) But, they want:

Employee A group header
date1 data in main report detail1
date2 data in main report detail 1
date3 data in main report detail 1
etc.
All data on Same Employee, by date, listed for "report 1" by date
then after that,
Report 2 data below on same employee listed by date. Report 2 is coming from
the
many side of the relationship.

Then this would start again for next employee B.

I have tried everything I know and gave up. I do not think this can be done.


:
That's two "doesn't work" explanations I gotten today so I
may be a little frustrated trying to figure out what you
want and why I don't understand what I suggested isn't
taking care of the issue.

My understanding is that rp1 is the main report and rpt2 is
the subreport. Both of them list some data grouped by
employee and then sorted by a date field. The final result
should look like

EmployeeA group header
date1 some data in main report detail1
date2 some data in main report detail2
EmployeeA group footer
date1 some data in subreport detail1
date2 some data in subreport detail2
EmployeeB group header
date3 some data in main report detail3
date4 some data in main report detail4
EmployeeB group footer
date3 some data in subreport detail3
date4 some data in subreport detail4


Melissa wrote:
Yes, that doesn't work.


Melissa wrote:
Here is an example of what "they" want.

rpt1 record- 12/01/2005, employee, data, data, data, etc..
12/02/2005 same employee, data, data, data, etc.
12/03/2005 same employee, data data etc.
rpt2 record- 12/01/2005 same employee, data, data, data, etc..


They basically want the "employee's records" from both tables kept together
consectuatively. So me as an employee, the report would list all my entries
from report 1 and report 2 together for me, then begin again for the next
employee.


:
Did you try placing the rpt2 subreport in the employee group
footer section? I think that's what you're looking for.
Click to expand...
Click to expand...
Click to expand...
 
I got it to work !! The subrtp is in employee header which is pulling from
the EmployeeHrs qry. Now, I changed the Master and Child Fields link to just
EmpID from EmpID & DateCompleted. This allowed it to work.

So now, my Main rpt prompts me for date criteria which is great and my
report comes up with how they the data how they want it but, My subrpt is
bringing over all records instead of the ones within the date specified... If
I relink the Child & Master fields back up to EmpID & DateCompleted I am back
to where I started. This is getting crazy. I also tried putting date
parmeters within the subrpt qry and that got messy. So to ask again but, any
thoughts on this.

Marshall Barton said:
Smacking forehead, I never realized there were two sub
reports and that the first subreport is in the main report's
Employee header. If you want the second subreport to
immediately follow the first subreport, can't you just put
them both in the Employee header section one above the
other?
--
Marsh
MVP [MS Access]

Main Report will have two subreports:
First rpt will be Employee Hrs: Only one record can be entered into this
table per day.
Second rpt will be; Employee Correspondense Completed. This table can have
more multiple entries for one day by employee, if necessary.

Now my Main rpt is based on the many side of the relationship tbl: Correp
Completed.
I have these fields within the Details section, Sorted by Date then Employee
Name.

My sub Rpt is based on Employee Hrs. This subrpt I put within the
EmployeeName Header. The EmployeeName Footer holds the totals on
Correspondence Completed by employee.

So here is how they want the report to look like.
SubRpt from EmployeeHrs
Employee: Melissa
12/01 HrsAbsent, HrsMeeting, HrsClass, #IncomingCalls, #OutgoingCalls,etc, etc
12/02 HrsAbsent, HrsMeeting, HrsClass, #IncomingCalls, #OutgoingCalls, etc,
etc.
12/03 HrsAbsent, HrsMeeting, HrsClass, #IncomingCalls, #OutgoingCalls, etc,
etc,
(listed directly under Melissa's data for Hrs will list the Correspondence
Completed by
melissa for each of those days)
(AuditTypes must be different if more than one entry in this tbl per day.)
Melissa
12/01 AuditType, BeginningInventory, EndingInventory, Billing, Assessment, etc
12/01 AuditType, BeginningInventory, EndingInventory, Billing, Assessment, etc
12/02 AuditType, BeginningInventory, EndingInventory, Billing, Assessment, etc
this will go on for Melissa for all records under this employee.

Then it would begin again for next employee. Does this help?
Thanks for all your help. I'm sorry if I am confusing you.


Marshall Barton said:
I also apologize for not getting it. You have explained
what I take to be the same thing several times now. From
everything I can see about what you want, it can be done
using the subreport in the Employee Group footer section.
You did say that that "doesn't work", but I still don't
understand what it actually produced nor what's wrong with
it.

I do think it should work, so maybe I have misscomunicated
something and maybe I can figure out what if you add to the
example to show what it is doing wrong. Please include at
least a little bit of a second employee so I can see how
that fits into what you're describing.
--
Marsh
MVP [MS Access]


Melissa wrote:
Ok I apologize I haven't explained properly,

Data from Rpt1 would come first by date.
So all entries from Melissa would list by date from Rpt 1.

Example
All entries from Rpt 1 by Melissa from December would list:
Melissa
12/01
12/02
12/03
etc.

Then after the last entry for Melissa from December, Rpt 2
comes up after (12/31)and lists each entry for Melissa for December as well
from the 2nd rpt.
12/01
12/02
12/03

So all entries from both tables stay together by employee but, all entries
from
rpt1 by date come first then all entries from rpt2 comes next. This repeats
for all
employees.

:

Maybe there's a meaning to "Same Employee" that I'm just not
picking up. I thought it meant all the data for a single
employee.

I think your example's "etc" came a little too early. What
you posted looks just like the first part of what I posted
so I still don't understand the distinction you're trying to
make. Could you expand it to include two employees and some
stuff from the subreport?
--
Marsh
MVP [MS Access]


Melissa wrote:
Yes, that is exactly right. That is how I originally set it up (I think the
way it should be.) But, they want:

Employee A group header
date1 data in main report detail1
date2 data in main report detail 1
date3 data in main report detail 1
etc.
All data on Same Employee, by date, listed for "report 1" by date
then after that,
Report 2 data below on same employee listed by date. Report 2 is coming from
the
many side of the relationship.

Then this would start again for next employee B.

I have tried everything I know and gave up. I do not think this can be done.


:
That's two "doesn't work" explanations I gotten today so I
may be a little frustrated trying to figure out what you
want and why I don't understand what I suggested isn't
taking care of the issue.

My understanding is that rp1 is the main report and rpt2 is
the subreport. Both of them list some data grouped by
employee and then sorted by a date field. The final result
should look like

EmployeeA group header
date1 some data in main report detail1
date2 some data in main report detail2
EmployeeA group footer
date1 some data in subreport detail1
date2 some data in subreport detail2
EmployeeB group header
date3 some data in main report detail3
date4 some data in main report detail4
EmployeeB group footer
date3 some data in subreport detail3
date4 some data in subreport detail4


Melissa wrote:
Yes, that doesn't work.


Melissa wrote:
Here is an example of what "they" want.

rpt1 record- 12/01/2005, employee, data, data, data, etc..
12/02/2005 same employee, data, data, data, etc.
12/03/2005 same employee, data data etc.
rpt2 record- 12/01/2005 same employee, data, data, data, etc..


They basically want the "employee's records" from both tables kept together
consectuatively. So me as an employee, the report would list all my entries
from report 1 and report 2 together for me, then begin again for the next
employee.


:
Did you try placing the rpt2 subreport in the employee group
footer section? I think that's what you're looking for.
Click to expand...
Click to expand...
Click to expand...
 
Melissa said:
I got it to work !! The subrtp is in employee header which is pulling from
the EmployeeHrs qry. Now, I changed the Master and Child Fields link to just
EmpID from EmpID & DateCompleted. This allowed it to work.

So now, my Main rpt prompts me for date criteria which is great and my
report comes up with how they the data how they want it but, My subrpt is
bringing over all records instead of the ones within the date specified... If
I relink the Child & Master fields back up to EmpID & DateCompleted I am back
to where I started. This is getting crazy. I also tried putting date
parmeters within the subrpt qry and that got messy. So to ask again but, any
thoughts on this.
Click to expand...


Messy or not, the subreport's query needs to know the date
criteria. You can make it a lot less messy if you use a
form for users to enter the date criteria instead of just
letting the query prompt for it. This should be the same
form with the button that opens the report. Just add the
needed unbound text box(es?) and change the criteria in the
query from something like [Enter Date] to something like
Forms!nameofform.nameoftextbox.

If you still have trouble with it, please post a Copy/Paste
of the query's SQL statement along with the name of the form
and the text box(es?) that you using for this.
 
Ok, I am following you thus far, but, do I need to link the sub with the main
by the DateCompleted as well? If I do this, I do not get to the results I
want.?

2nd question, I have the BeginDate & EndDates within the qry for the main
report, do I add the parameters again within each subs qry as well?

Marshall Barton said:
Melissa said:
I got it to work !! The subrtp is in employee header which is pulling from
the EmployeeHrs qry. Now, I changed the Master and Child Fields link to just
EmpID from EmpID & DateCompleted. This allowed it to work.

So now, my Main rpt prompts me for date criteria which is great and my
report comes up with how they the data how they want it but, My subrpt is
bringing over all records instead of the ones within the date specified... If
I relink the Child & Master fields back up to EmpID & DateCompleted I am back
to where I started. This is getting crazy. I also tried putting date
parmeters within the subrpt qry and that got messy. So to ask again but, any
thoughts on this.
Click to expand...


Messy or not, the subreport's query needs to know the date
criteria. You can make it a lot less messy if you use a
form for users to enter the date criteria instead of just
letting the query prompt for it. This should be the same
form with the button that opens the report. Just add the
needed unbound text box(es?) and change the criteria in the
query from something like [Enter Date] to something like
Forms!nameofform.nameoftextbox.

If you still have trouble with it, please post a Copy/Paste
of the query's SQL statement along with the name of the form
and the text box(es?) that you using for this.
Click to expand...
 
1. No, the criteria in the subreport's record source query
takes care of the dates part of this. Leave the Link
Master/Child properties set to just EmployeeID.

2. Absolutely, add the criteria to the subreport's record
source query.

If you continue to use the prompt strings [BeginDate] and
[EndDate], you will be prompted multiple times for the same
dates. This is why I strongly suggest that you use text box
controls on a form for users to enter the dates. When you
use a parameter like:
Forms!nameofform.nameoftextbox
Access automatically takes care of retrieving the value
instead of throwing up an Input box for you to enter the
value. Try it, you'll like it ;-)
--
Marsh
MVP [MS Access]

Ok, I am following you thus far, but, do I need to link the sub with the main
by the DateCompleted as well? If I do this, I do not get to the results I
want.?

2nd question, I have the BeginDate & EndDates within the qry for the main
report, do I add the parameters again within each subs qry as well?

Marshall Barton said:
Messy or not, the subreport's query needs to know the date
criteria. You can make it a lot less messy if you use a
form for users to enter the date criteria instead of just
letting the query prompt for it. This should be the same
form with the button that opens the report. Just add the
needed unbound text box(es?) and change the criteria in the
query from something like [Enter Date] to something like
Forms!nameofform.nameoftextbox.

If you still have trouble with it, please post a Copy/Paste
of the query's SQL statement along with the name of the form
and the text box(es?) that you using for this.
Click to expand...
Click to expand...
 
Back
Top