Index
2006-03-13 15:45Chester Friesen : Print report problem
2006-03-13 16:01Richard Kaye : Re: Print report problem
2006-03-13 16:18Chester Friesen : Re: Print report problem
2006-03-13 16:33Charlie Coleman : Re: Print report problem
2006-03-13 16:45Chester Friesen : Re: Print report problem
2006-03-13 18:26Chester Friesen : Re: Print report problem
2006-03-14 01:08Chester Friesen : Re: Print report problem
Back to top
Print report problem

Author: Chester Friesen

Posted: 2006-03-13 15:45:28   Link

I am having a problem with a report, which is actually an invoice.

Records are marked for the report, in the preview everything shows

right, but when printed, it only prints the first record, also the total

box in the summary band is blank. I have tried it with three separate

printers, all the same problem. Any ideas?

--

Regards,

Chester Friesen

©2006 Chester Friesen
Back to top
Re: Print report problem

Author: Richard Kaye

Posted: 2006-03-13 16:01:40   Link

Sounds like you're in the wrong workarea when running the report. Or

perhaps a UDF in the degtail band is moving the record pointer.

Chester Friesen wrote:

> I am having a problem with a report, which is actually an invoice.

> Records are marked for the report, in the preview everything shows

> right, but when printed, it only prints the first record, also the

> total box in the summary band is blank. I have tried it with three

> separate printers, all the same problem. Any ideas?

--

Richard Kaye

RFC Systems

Voice: 973.761.0868

Fax: 973.761.4329

For the fastest response time, please send your tech support

queries to techsupport@rfcsystems.com

---------------------------------------------------------

---------------------------------------------------------

©2006 Richard Kaye
Back to top
Re: Print report problem

Author: Chester Friesen

Posted: 2006-03-13 16:18:28   Link

Richard Kaye wrote:

> Sounds like you're in the wrong workarea when running the report. Or

> perhaps a UDF in the degtail band is moving the record pointer.

Does anything change between the preview and the printing? The preview

always shows correct.

--

Regards,

Chester Friesen

©2006 Chester Friesen
Back to top
Re: Print report problem

Author: Charlie Coleman

Posted: 2006-03-13 16:33:01   Link

At 12:45 PM 3/13/2006 -0800, Chester Friesen wrote:

>I am having a problem with a report, which is actually an invoice. Records

>are marked for the report, in the preview everything shows right, but when

>printed, it only prints the first record, also the total box in the

>summary band is blank. I have tried it with three separate printers, all

>the same problem. Any ideas?

>--

There was a 'bug' in VFP pertaining to a 'grids' recordsource. I don't know

if it's been fixed.

If you have a grid on the form when you call a REPORT FORM, and if the grid

currently has focus, the report will maybe print the 1st page correctly,

but then error out because the workarea gets reset to the grids recordsource.

The above may not be entirely accurate. But if you've got a grid that has

focus when you call the report, try setting focus to a button on the form

before the REPORT FORM call.

-Charlie

©2006 Charlie Coleman
Back to top
Re: Print report problem

Author: Chester Friesen

Posted: 2006-03-13 16:45:49   Link

Charlie Coleman wrote:

> There was a 'bug' in VFP pertaining to a 'grids' recordsource. I don't

> know if it's been fixed.

>

> If you have a grid on the form when you call a REPORT FORM, and if the

> grid currently has focus, the report will maybe print the 1st page

> correctly, but then error out because the workarea gets reset to the

> grids recordsource.

No grid, just a line in a prg. BTW, I'm using VFP9SP1-Codemine framework.

--

Regards,

Chester Friesen

©2006 Chester Friesen
Back to top
Re: Print report problem

Author: Chester Friesen

Posted: 2006-03-13 18:26:59   Link

Found this, will call Microsoft.

"FIX: When a report detail band starts on a new page, only the first

detail record for this band is printed in Visual FoxPro 9.0"

http://tinyurl.com/g7ae9

--

Regards,

Chester Friesen

©2006 Chester Friesen
Back to top
Re: Print report problem

Author: Chester Friesen

Posted: 2006-03-14 01:08:13   Link

Chester Friesen wrote:

> Found this, will call Microsoft.

> "FIX: When a report detail band starts on a new page, only the first

> detail record for this band is printed in Visual FoxPro 9.0"

>

> http://tinyurl.com/g7ae9

>

"set reportbehavior 90" , etc. worked. The above article was pre-sp1.

--

Regards,

Chester Friesen

©2006 Chester Friesen