Report printing

[Khushalay]

A query:

Whenever I give print command on my reports, some tables automatically gets printed with it and too many pages gets wasted. How to overcome this issue?

 

[jdraw]

Sample please.

 

[sneuberg]

Are you saying that data that's not in the report gets printed? It's not likely that any one can tell you the cause without more information. Could you upload the database and tell what data is in the output that you don't want?

 

[Khushalay]

I have quite a few tables in the same db. One table with get printed with the report and sometimes instead of the report.

 

[jdraw]

Khushalay,

Is this the same issue that was solved re On No Data????

 

[Khushalay]

No, its not the same

 

[sxschech]

Are you creating a report from a table using the wizard and selecting all the fields and so the report is trying to print more going across than will fit on a page, or are you saying that you already have a report set up and you want to print for a specific criteria but instead, the report is printing rows for all the records in the table. Or is this a completely different issue?

 

[Khushalay]

Wait
Lemme try to elaborate it a bit more.

I have few reports based on queries and working pretty well. Sometimes when I want to print the report, report will get printed along with few copies of one of the tables in my db. that particular table is not even part of the report.

Its a table named colors and has some 30 plus colors. The report doesn't even have that field. But the report along with the colors table get printed.

 

[JHB]

How do you print the report, choosing "Print" from the Ribbon or do you use some code, if code then show the code.
Is the table in question open when you print?

 

[Khushalay]

No, the table isn't open when I give print command but it is the first table in my db, the topmost in the list.

I just right click, select print preview and from there right click n click on print.

 

[Khushalay]

But it is repetitive n it wastes too many print pages. The manger noticed it and asked me to fix it asap but Im clueless why is it happening. is it bcoz of the print option I am choosing or some other reason.

 

[JHB]

No, the table isn't open when I give print command but it is the first table in my db, the topmost in the list.

I just right click, select print preview and from there right click n click on print.

Is the report open then?
What is "bcoz"?

 

[sneuberg]

Assuming the table content doesn't show up in the print preview it sound like the printing of the table is queued as a separate item. Could you check you print queue to see if this is the case? Also if the report has a code module could you post the code that is in it?

 

[Khushalay]

bcoz is because

 

[Khushalay]

every single time this table gets printed and it can't be queued on its own every time and if it is, what could be the reason.

I do not have any code module

 

[sneuberg]

every single time this table gets printed and it can't be queued on its own every time

If you are not seeing it in the print preview that I'd say it would have to be queued on its own. To debug this I think you will have to make a copy of the database and just poke at it until you figure it out. Some things to try are:

1. Delete the table. What happens then?
2. Delete all of the controls in the report and see what happens.


If you upload the database I'll see what I can find.

 

[gemma-the-husky]

are you working from the database navigator/pane whatever it's called, or from a control button on a form.

I can imagine if you inadvertently select a table and press "print" it may well print the table. My databases work from switchboards, that issue commands such as

docmd.openreport "some report name"

 

[The_Doc_Man]

Don't know if it SHOULD make a difference in this case, but Colors is the name of a function used in MS Graph, used to present an index and get back an RGB setting. It is considered a bit tricky to use an unqualified name that happens to overlap with another object.

If you print a report AND a table at the same time and they seem inextricably bound, and if you are distributing the front-end, I would suggest that you make a new copy of the FE file by deleting the report, then recreating it. See if your new copy does the same thing. My guess here is some obscure form of corruption in the FE file that you distributed. So... try rebuilding the report and distribute a new copy.

 

[Khushalay]

I compact and repair the database as well.
Im using the print command by right click on t he report n click print. I dont have any print command button on the report.

and yes, the users open the report from the command button on the form.

 

[gemma-the-husky]

so can you show us the code for the command button?