I've searched the forum and have not found any discussion on two problems I'm having. I have the latest build of V8.
I created a database with tables, reports etc. long ago in V4.5 and they were working fine. I haven't printed out any of the reports since converting to A8. Yesterday, I tried to open and print one specific report and encountered a strange error message that I couldn't work around so I created a new report from scratch.
Two problems occur on the report.
One is that the system field PageXofY works fine until the page count reaches 100. At that point the "of Y" part only shows the first two numerals of the total pages. I have expanded the size of the field to two inches which is at least an inch wider than necessary but to no avail.
Secondly, I have a field (called Art) in the table which is a substring of one of the other fields and I group on it. It is nothing more than the alphabet-A-Z. I also put a page break in the group footer. This worked fine in V4.5. After I printed the report, I noticed that a new page wasn't created when Art changed from W to Y.
I went back to the design of the report and deleted the grouping and then re-did it. Now the page break doesn't occur when Art changes from Y to Z.
I have packed the table and done a large number of other things to try to zero in on the second problem but to no avail. This same grouping works on other reports for this same table.
I have attached a dummied down database with the table and report for anyone who wants to look at it.
Another issue that doesn't affect the above is that, in the real database, table and report, I have a summary calculated field in the report footer. This works but the report footer doesn't occur on it's own page. I always thought it did.
I created a database with tables, reports etc. long ago in V4.5 and they were working fine. I haven't printed out any of the reports since converting to A8. Yesterday, I tried to open and print one specific report and encountered a strange error message that I couldn't work around so I created a new report from scratch.
Two problems occur on the report.
One is that the system field PageXofY works fine until the page count reaches 100. At that point the "of Y" part only shows the first two numerals of the total pages. I have expanded the size of the field to two inches which is at least an inch wider than necessary but to no avail.
Secondly, I have a field (called Art) in the table which is a substring of one of the other fields and I group on it. It is nothing more than the alphabet-A-Z. I also put a page break in the group footer. This worked fine in V4.5. After I printed the report, I noticed that a new page wasn't created when Art changed from W to Y.
I went back to the design of the report and deleted the grouping and then re-did it. Now the page break doesn't occur when Art changes from Y to Z.
I have packed the table and done a large number of other things to try to zero in on the second problem but to no avail. This same grouping works on other reports for this same table.
I have attached a dummied down database with the table and report for anyone who wants to look at it.
Another issue that doesn't affect the above is that, in the real database, table and report, I have a summary calculated field in the report footer. This works but the report footer doesn't occur on it's own page. I always thought it did.
Comment