Report printing problem 1

[vecjjk]

I have been getting a GPF error when printing a series of individual reports. It is not consistent. Using the same dataset, sometimes the error will show up after 3 prints, sometimes 10, etc. After reading the various posts already out there, I checked the style sheet and it is ok. However, the report does have some filters saved with it. I eliminated the filters, and the problem seems to go away, but of course the data is not what I want. I'd like to know how I can still implement the filter, but not in the report, since it appears to be causing the issue. My report basically has information from one table about the order, then joins with a second table that contains customer addresses (multiple, representing mailing address and billing address which could be different). For the report, I only want the billing address so that is what the filter is for. How can I best accomplish this to avoid my GPF problem? I have the problem in Paradox 9 and 10, in both full and runtime versions. Thanks in advance !

 

[Langley]

I think you should eliminate the filters and parse your data with a query. Then base the report on the query results rather than a filtered table. If your report is currently based on a table of data, then a simple way to redirect it to an answer table follows:

1. Query the table and produce an answer.db table in PRIV.
2. Temporarily rename the original table on which the report was based.
3. Open the report and you will receive an error message that asks if you want to replace the original table in the data model.
4. Answer Yes and browse to the RIV:answer.db table.
5. The report will open with only the queried data. Save the report and now it will only display data from an answer table.
6. Change the original table back to its old name.

This way, no matter what the query (as long as the results include the fields you have on the report), the report will only reflect the data you want to see.

Remember, after doing this you will have to run a query before you can open the report, even in design mode.


Mac

"There are only 10 kinds of people in this world... those who understand binary and those who don't"

langley_mckelvy@cd4.co.harris.tx.us

 

[vecjjk]

Mac,

Thank you very much for your response. I figured that queries were the way to go, but I was unsure how to change the report without losing all of the fields. I appreciate the "step by step" instructions on that. Thanks again !