Report Form Won't Print

[fmoore0001]

I have a new one driving me crazy. I want to print a report form, but every time it going to print PREVIEW it blinks and does not print. I cannot seem to find anythring wrong in the REPORT FORM call (I can build a cursor with the same info) but the REPORT itself will not print. Am I missing something?

Frank

 

[Mike Lewis]

Frank,

Before I print or preview any report, I check the RECCOUNT() of the underlying table. If it is zero, I don't do the report.

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[fmoore0001]

Nope, 50,000 records on this table. Any way to pre-test the forms for possible field errors?

Frank

 

[Peping]

Frank,

Double-check all fields or variables used on the report. Mispelled variable/field entries will also prevent you to print the report.

Peping

 

[craigsboyd]

fmoore0001,

Usually if something is misspelled such as a variable or fieldname or you have a syntax error in the report I think it would throw an error, a pretty ambiguous one, but an eroor nonetheless...I concur with what has already been suggested, the datasource that is selected when the report runs is empty....I realize you checked the table and it has records, but are you sure that it is the alias selected when you run the report? Try Selecting that table just before you issue your REPORT FORM command:

Select MyTable
Report Form....

...also, there is the possibility that you have a added a criteria clause to your REPORT FORM command such as a FOR or a WHILE that would cause it not to see any records, or you may even have a filtered view of the table, so even though there are records existing in the table and you are able to create a cursor from the table, the table doesn't actually have any records that meet the criteria.

Is it possible that any one of these is the case?

Slighthaze = NULL
_{craig1442@mchsi.com}

"Whom computers would destroy, they must first drive mad." - Anon​

 

[fmoore0001]

Heres a kick. I took the form down to one field in Detail, still not printing!!

Frank

 

[craigsboyd]

fmoore0001,

As I stated in my above post, your problem is not with any fields on the report...it is more than likely with the alias currently selected when you run the report or some type of filtered criteria you have enforced on your datasource or on the report itself. Have you double-checked these things to make sure it is not causing your problem?

Slighthaze = NULL
_{craig1442@mchsi.com}

"Whom computers would destroy, they must first drive mad." - Anon​

 

[Mike Lewis]

Frank,

Slighthaze's advice is good. If you are confident that the table is not empty, the most likely explanation is that the wrong table is selected when you start the report.

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[jimstarr]

Hi Frank,

I agree with Slighthaze and Mike that the report may actually be running with a table you don't intend. Check the data environment of the report to see if some other table is present.

Jim

 

[fmoore0001]

Well, here is a question. The tables are opened in My primary table is called tran_reg, and client is a child file of tran_reg. The tables are opened and closed by the Form but were also opened (and closed) by the report. This caused problems as the form still ran after the report. Could all this opening and closing cause a problem? Is the open 'local' to the form or report object?

Frank

 

[fmoore0001]

If I open a report with the data environment, what determines the parent file?

Frank

 

[jimstarr]

Hi Frank,

The table controlling the report will be the the one SELECTed when the report runs. When multiple tables are opened in the data environment of the report I'm not sure which one gets selected - probably the 1st one in the DE.

I'd suggest removing the tables from the DE altogether. USE and SELECT tables explicity and see if this solves your problem.

Jim

 

[BPeisch]

If you want to open tables in your report's DE, independently from the form, make sure you go to the Report menu pad and click on Private Data Session. The table that drives the report is determined by the alias named in the DE's InitialSelectedAlias property.


-BP (Barbara Peisch)

http://www.peisch.com