printed report different than preview

[Guest]

some detail, such as calculated variables or subreport detail displays
properly in print preview, but when the report prints, the items are not
printed, or the data is different. Does anyone know of the possible cause and
solutions?

 

[Duane Hookom]

I'm having trouble seeing your report, records, or what you have done to
trouble-shoot this issue.

Feel free to tell us more about your report, code, record source, criteria,
relationships to forms, as well as what you have done other than ask us for
help.

 

[Guest]

I have starting and ending dates in text boxes on a form, and text boxes on
the report ( in the header) that reference the boxes from the form. the
values appear on the print preview, but not on the printed report. The
subreport also shows up on the preview but not when the report prints. Thanks
for your help.

 

[Guest]

I have the same problem with my report. This is one report with 5 subreports
strait-forward... the only code in the report is to filter the Fiscal Year.
The sub
reports present the details related to my project.

I can preview my report correctly, but when I try to print, only the main
report
and subreport #4 print out, the subreport 1,2,3 and 5 don't print. Although
they
present different data, they have the same link to the main report (project ID
and Fiscal Year) and the only programming behind is to paint the backgrounds
on the sections (white/gray pattern).

I have tryed:
- Erase the code and recode again
- Recreate the report objects from scratch
- No programming in the subreports
- Decompile the database and recompile
- Use the function detect/Repair of MS Access
- Copy all objects to a new blank report
- Copy the objects to a new blank database

So far, nothing worked. I am clueless now.

Mauricio Silva - 2005
P.S. Using MS Access 2000 SP-3 / Windows 2000 Pro

 

[Guest]

I'm really puzzled with this, I am using the same technique in a different
application, and it works fine.
Thanks.

 

[Duane Hookom]

Bill,
Do you have any code in your report that might close the form when the
report closes?

 

[Guest]

No, that's a good thought, the form stays open after the report prints, so
users can run additional reports. It's a report setup form, using text boxes
for the date range and a select case option grp for report definitions. those
parts work OK, it's just that the date range shows on the print preview but
not on the printed report....

 

[Duane Hookom]

How is this set up "text boxes on the report ( in the header) that reference
the boxes from the form"? Are you control sources something like:
=Forms!frmDates!txtStartDate

 

[Guest]

yes, exactly. I have a text box for each date, then another to display: "For
the period: "&[txtBeginDate]&" to "&[txtEndDate] Like I said, it displays on
print preview and prints OK in another application, but it doesn't print in
this app. thanks again

 

[Duane Hookom]

I would check the references as well as do everything I could think of as if
the mdb was corrupt.

--
Duane Hookom
MS Access MVP

yes, exactly. I have a text box for each date, then another to display:
"For
the period: "&[txtBeginDate]&" to "&[txtEndDate] Like I said, it displays
on
print preview and prints OK in another application, but it doesn't print
in
this app. thanks again

How is this set up "text boxes on the report ( in the header) that
reference
the boxes from the form"? Are you control sources something like:
=Forms!frmDates!txtStartDate

 

[Guest]

I still don't know why, but my problem with variables printing has resolved
itself. The results appear in print preview, and on the printed report.

 

[Guest]

Maruricio - I don't know how, but my problem solved itself, subreports and
variables are now printing.