Any way to use this information with Report Listener

[markros]

Re thread184-1538957

How can we use it with Report Listener?

Thanks.

 

[Mike Lewis]

What exactly do you want to achieve?

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business

 

[markros]

I want to print multiple reports using only one prompt command for them. I'd prefer to not change the actual programs generating these reports, where I have

report form (myReport) object loListener to printer prompt preview

command.

However, I don't want preview (or I want just one preview showing them all - unfortunately some reports are portrait and some are landscape) and only one prompt dialog.

 

[Mike Lewis]

Markros,

In that case, NOPAGEJECT should do what you want. I can't see that using a ReportListener would affect that.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business

 

[markros]

I already found several problems with NOPAGEEJECT, though may be my tests were not very thorough.

1. You can not chain reports with different orientation

This is the major problem.

2. Not every report generates data every time - so I found that if SQL for the report produced 0 records, I either end up with blank page or NOPAGEJECT doesn't print.

 

[bborissov]

1. You can not chain reports with different orientation

I can, with XFRX



Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[markros]

We do have XFRX here, I believe it's somehow incorporated into our current listener - though I didn't look too close for the code.

Can you please provide more information?

Thanks again.

 

[Mike Lewis]

Markros,

You can not chain reports with different orientation

This is a documented limitation of NOPAGEEJECT.

We do have XFRX here, I believe it's somehow incorporated into our current listener

You would know if you were using XFRX as your report listener. Your report form command would be pointing to an XFRX object - something like this:

loXFRX = XFRX("XFRX#LISTENER")
....
REPORT FORM (tcReport) OBJECT loXFRX

Not every report generates data every time - so I found that if SQL for the report produced 0 records, I either end up with blank page or NOPAGEJECT doesn't print.

That's got nothing to do with NOPAGEEJECT. It's generally true of VFP reporting. REPORT FORM operates on records in a cursor; if the cursor is empty, there is nothing for the command to do. It's usually the desired behaviour.

If that's not what you want, you need to place a dummy record in the cursor. Presumably it would contain some sort of message that you want to appear in the report that would otherwise be blank.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business