Report DBF prompt

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peter Huish - 26 Nov 2008 00:21 GMT

I have a couple of reports that I have just created (I am a report
novice) that when the line REPORT FORM rptfile is executed I get
prompted for a DBF to use.

In one report there are just local variables being printed so there is
no associated DBF and with the other the report variables that are
sourced directly from a cursor are present.

What is the DBF being looked for?

This is VFP 7

thanks

pete

Reply to this Message

Cathy Pountney - 26 Nov 2008 15:07 GMT

The VFP Report Writer MUST have a table or cursor open to "drive" the
report. Even if you just have variables for all the fields on the report,
you must have a dummy cursor with one record or the report won't even run.

When you get prompted for a table, it either means that there is no table or
cursor open .. or it means that that the expression of one of the fields on
the report is referencing a table that isn't open. For example the
expression could be MyTable.MyField.

An great trick for finding the problem is to change the line of code in your
program that runs the report from REPORT FORM whatever .. to MODIFY REPORT
Whatever. Then run it. It brings up the report designer tool. Select
"Preview" and the report will try to preview. If an error occurs, it tells
you about it, then it brings up the property dialog of the offending object
on the report.

Cathy Pountney

>I have a couple of reports that I have just created (I am a report
> novice) that when the line REPORT FORM rptfile is executed I get
[quoted text clipped - 11 lines]
>
> pete

Reply to this Message

Peter Huish - 27 Nov 2008 05:40 GMT

> The VFP Report Writer MUST have a table or cursor open to "drive" the
> report. Even if you just have variables for all the fields on the report,
> you must have a dummy cursor with one record or the report won't even run.

Thanks for that. Worked a treat.

pete

Reply to this Message