Excel Reporting Issue

It looks like you have "Header Information" checked on, and "Field Information"

Your top left information is header, and the field information is the UNITS IN and -TOL + TOL cells

Uncheck all those.

Replied in both your threads just in case you don't see it.

Well, that worked more or less. When I opened up the program, those fields WERE unchecked. So I did nothing, and it went back to Exhibit A. We will have to wait and see if it changes on us again and see if those boxes are checked or not.

Do you have a print command in your program? That has different settings than  File->Printing->Report Window Print Setup->Excel.

I don't think so. I tried Alt+F3 "print" and found nothing. Here is what we have in terms of saving.

Second thing in that save command group is the print command PRINT/REPORT. You can F9 that and see if there is settings checked, but that Excel reporting is off. Not sure what is causing this to happen if there is no checkboxes selected.

Right. This is the second time it’s happened, too. I made a thread about it a few weeks ago. The next time the issue occurs, I’ll have to see if those boxes are even checked.

Question: is the “print command” a totally different way of reporting to Excel? So, there 3 ways to export to Excel? Report Window Print Setup, Excel Form Report, and the Print Command?

Sort of, the Report Window Print Setup and Print command use the same tool, it's just the Print Command is triggered by execution in the program, whilst the Report Window Print Setup is a global setting and triggered at the end of execution of the program.

I prefer to have Report Window Print Setup turned off, and explicitly add a PRINT command in each program to deal with printing.

Note: If you either switch on Report Window Print Setup printing, or add a Print command and modify the settings, you get a .P2X file generated (So prog1.prg will also have a Prog1.P2X file created)

This specifies the setting to use for that particular program.  If this file doesn't exist then it will use whatever your default settings are.

Wait, so if that .P2X file is deleted, it may not work properly? Maybe that is what I did...

We just decided to switch to Excel Form Report under the assumption that Report Window Print Setup->Excel is too buggy. But maybe it's something that I did.

Wait, so if that .P2X file is deleted, it may not work properly? Maybe that is what I did...

We just decided to switch to Excel Form Report under the assumption that Report Window Print Setup->Excel is too buggy. But maybe it's something that I did.

Possibly - but I think it's more likely that the way it works in general is a bit odd.

If you start a new program and switch printing on in the Report Window Print Setup window, then that will be the setting for that program. 

If you then start another program it will be on by default. 

If you start another, and switch it off, it will then be off by default for future programs, but the previous programs will all remember their own setting.

So in effect, it's kind of a system setting, but also program specific.

Much better to make sure it's working correctly (so the .P2X file is created), and then use the print command within the program.

That said, I do prefer the excel form reports, I just wish we could pass the complete file name in via a variable rather than just the directory.