What determines how many pages is in a report ? You say, well the parent table, and I say, NOT really!.
I have what I call a "Base" report (BASE.FRX) that instead of printing on a SINGLE page, it prints on 5 pages. Apparently triggering a new page based on an open Table that has 5 records in it, but this table is not even mentioned in the report or in the DataEnvironment.Init() code !.
To simplfy my case and troubleshoot, I created a BRAND new report called (NEW.FRX) from scratch, use Default DataEnvornment, change AutoOpen and AutoClose to .F. and .F.. There is nothing else on the report. Data Source is .NULL. and there is nothing in Data Grouping. I do a Preview and it is a single page report as desired. I make a second copy of this report and call it COPY.FRX. So, everything is honky dorie so far.
Then, I paste the code in DataEnvironment.Init() and the stuff on the report from my BASE.FRX onto this new NEW.FRX report. Run it, now all of a sudden I get 5 pages again. Then, I delete everything on the NEW.FRX Report and all the code in it's Init(). Run it, and I still get 5 pages !
Then I compares the two EMPTY reports NEW.FRX with COPY.FRX (the copy) and BROWSE the tables and find that everything is idential!. I also checked everyuthing in the FRT files and they were identical as well. But NEW.FRX still prints on 5 pages, while COPY.FRX (the copy) prints correctly on 1 page.
I have tried filtering, closing, creating another cursor... for the table that has 5 records in it, but I can never get it to work right....
So, how does a Report Template connect itself to a table ? When there is really nothing on the report, or in the init() what-so-ever. I think this is really odd.
Would really appreciate any help I can get.