columns in detail area of access report

  • Thread starter Thread starter DBTrueheart
  • Start date Start date
D

DBTrueheart

I have created an Access report to show training for an employee filtered by
the employee id. To minimize paper use, I would like the detail section ONLY
of the report to format as columns. I tried inserting a subreport but the
entries repeated an enormous number of times... a two page report went to
27002+ pages. Not good. Please help.
 
If you are adding a subreport of details, you must remove the "details" level
from the main report. The individual training records table(s) should not be
included in the main report's record source.
 
Duane, I am not sure what you mean by remove the "details" level. I cannot
actually remove the details section from the physical report and I have
nothing in the details area of my report except the subreport. Below is the
SELECT statement for my report:
SELECT Employees.Employee, [Completed Classes].Class, [Completed
Classes].[Date Completed], Employees.EmployeeID, Employees.Status,
Employees.Grade, Employees.GS, Employees.[Hire Date], Employees.Department,
Employees.[Position Title], Employees.Orientation, Employees.WCCS,
Employees.[Active Duty], Employees.[Training Needed] FROM Employees INNER
JOIN [Completed Classes] ON Employees.EmployeeID=[Completed
Classes].EmployeeID WHERE (((Employees.EmployeeID) Like "*" & [Employee ID] &
"*") AND ((Employees.Status)="Active"));

When opened, the report asks for the employee id.
Thank you,
Dana
 
By "details", I meant the detail level of your report's record source. I
expect this is the [Completed Classes] table/query. Your main report might
contain only the unique, active employees and the subreport contains the
training records. You would set the link master/child properties to the
EmployeeID fields.

--
Duane Hookom
Microsoft Access MVP


DBTrueheart said:
Duane, I am not sure what you mean by remove the "details" level. I cannot
actually remove the details section from the physical report and I have
nothing in the details area of my report except the subreport. Below is the
SELECT statement for my report:
SELECT Employees.Employee, [Completed Classes].Class, [Completed
Classes].[Date Completed], Employees.EmployeeID, Employees.Status,
Employees.Grade, Employees.GS, Employees.[Hire Date], Employees.Department,
Employees.[Position Title], Employees.Orientation, Employees.WCCS,
Employees.[Active Duty], Employees.[Training Needed] FROM Employees INNER
JOIN [Completed Classes] ON Employees.EmployeeID=[Completed
Classes].EmployeeID WHERE (((Employees.EmployeeID) Like "*" & [Employee ID] &
"*") AND ((Employees.Status)="Active"));

When opened, the report asks for the employee id.
Thank you,
Dana
--
"Success is the ability to go from one failure to another with no loss of
enthusiasm." - Winston Churchill


Duane Hookom said:
If you are adding a subreport of details, you must remove the "details" level
from the main report. The individual training records table(s) should not be
included in the main report's record source.
Click to expand...
Click to expand...
 
OkeeDokee, I kinda thought that's what you meant, but when I do that my
report goes from 3 pages to (now) 207 pages. I don't know enough to alter the
SQL statement or even how to alter it. I know this can be done. Do I need to
start over? Make a new report?
--
"Success is the ability to go from one failure to another with no loss of
enthusiasm." - Winston Churchill


Duane Hookom said:
By "details", I meant the detail level of your report's record source. I
expect this is the [Completed Classes] table/query. Your main report might
contain only the unique, active employees and the subreport contains the
training records. You would set the link master/child properties to the
EmployeeID fields.

--
Duane Hookom
Microsoft Access MVP


DBTrueheart said:
Duane, I am not sure what you mean by remove the "details" level. I cannot
actually remove the details section from the physical report and I have
nothing in the details area of my report except the subreport. Below is the
SELECT statement for my report:
SELECT Employees.Employee, [Completed Classes].Class, [Completed
Classes].[Date Completed], Employees.EmployeeID, Employees.Status,
Employees.Grade, Employees.GS, Employees.[Hire Date], Employees.Department,
Employees.[Position Title], Employees.Orientation, Employees.WCCS,
Employees.[Active Duty], Employees.[Training Needed] FROM Employees INNER
JOIN [Completed Classes] ON Employees.EmployeeID=[Completed
Classes].EmployeeID WHERE (((Employees.EmployeeID) Like "*" & [Employee ID] &
"*") AND ((Employees.Status)="Active"));

When opened, the report asks for the employee id.
Thank you,
Dana
--
"Success is the ability to go from one failure to another with no loss of
enthusiasm." - Winston Churchill


Duane Hookom said:
If you are adding a subreport of details, you must remove the "details" level
from the main report. The individual training records table(s) should not be
included in the main report's record source.
--
Duane Hookom
Microsoft Access MVP


:

I have created an Access report to show training for an employee filtered by
the employee id. To minimize paper use, I would like the detail section ONLY
of the report to format as columns. I tried inserting a subreport but the
entries repeated an enormous number of times... a two page report went to
27002+ pages. Not good. Please help.
Click to expand...
Click to expand...
Click to expand...
 
You really need to be able to identify the Record Sources of your reports. I
can only guess that your subreport has the [Completed Classes] as part of its
record source. The main report should have only [Employees] as the record
source (or query based on Employees). Set the Link Master/Child properties to
EmployeeID.

If you can't figure this out, come back with the record sources and the link
properties.
--
Duane Hookom
Microsoft Access MVP


DBTrueheart said:
OkeeDokee, I kinda thought that's what you meant, but when I do that my
report goes from 3 pages to (now) 207 pages. I don't know enough to alter the
SQL statement or even how to alter it. I know this can be done. Do I need to
start over? Make a new report?
--
"Success is the ability to go from one failure to another with no loss of
enthusiasm." - Winston Churchill


Duane Hookom said:
By "details", I meant the detail level of your report's record source. I
expect this is the [Completed Classes] table/query. Your main report might
contain only the unique, active employees and the subreport contains the
training records. You would set the link master/child properties to the
EmployeeID fields.

--
Duane Hookom
Microsoft Access MVP


DBTrueheart said:
Duane, I am not sure what you mean by remove the "details" level. I cannot
actually remove the details section from the physical report and I have
nothing in the details area of my report except the subreport. Below is the
SELECT statement for my report:
SELECT Employees.Employee, [Completed Classes].Class, [Completed
Classes].[Date Completed], Employees.EmployeeID, Employees.Status,
Employees.Grade, Employees.GS, Employees.[Hire Date], Employees.Department,
Employees.[Position Title], Employees.Orientation, Employees.WCCS,
Employees.[Active Duty], Employees.[Training Needed] FROM Employees INNER
JOIN [Completed Classes] ON Employees.EmployeeID=[Completed
Classes].EmployeeID WHERE (((Employees.EmployeeID) Like "*" & [Employee ID] &
"*") AND ((Employees.Status)="Active"));

When opened, the report asks for the employee id.
Thank you,
Dana
--
"Success is the ability to go from one failure to another with no loss of
enthusiasm." - Winston Churchill


:

If you are adding a subreport of details, you must remove the "details" level
from the main report. The individual training records table(s) should not be
included in the main report's record source.
--
Duane Hookom
Microsoft Access MVP


:

I have created an Access report to show training for an employee filtered by
the employee id. To minimize paper use, I would like the detail section ONLY
of the report to format as columns. I tried inserting a subreport but the
entries repeated an enormous number of times... a two page report went to
27002+ pages. Not good. Please help.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top