Hi all,
I have an A5V5 Home Edition application that tracks donations and prints various reports. One of them is a deposit report that requires the data to be manipulated before it is printed.
To do this I use an empty table that has the desired structure and just write the data that table and then run the report. The report is called from a script that does all the work.
The table is populated correctly. The report however will not run. If I run it from the Control Panel after the script has run, it runs correctly.
The script dies on the following line:
:Report.preview("Grouped Deposit")
The error is 'variable type mismatch'.
This is not the most helpful error message! A variable name would be nice. I suspect it is a conflict between the report and the script. I have checked all the tables that are opened looking for a field that might have the same name but be of a different type.
I have checked all the variables in the report to ensure that when they refer to a field they include the table reference just in case. I have checked the script for variable names that might conflict with the report. I have used debug to look at as many variables as I can think of. I have checked the grouping for the report, the total fields, etc etc.
Does any one have any idea what else I should be looking for????
Any help is greatly appreciated.
Barb Hill
I have an A5V5 Home Edition application that tracks donations and prints various reports. One of them is a deposit report that requires the data to be manipulated before it is printed.
To do this I use an empty table that has the desired structure and just write the data that table and then run the report. The report is called from a script that does all the work.
The table is populated correctly. The report however will not run. If I run it from the Control Panel after the script has run, it runs correctly.
The script dies on the following line:
:Report.preview("Grouped Deposit")
The error is 'variable type mismatch'.
This is not the most helpful error message! A variable name would be nice. I suspect it is a conflict between the report and the script. I have checked all the tables that are opened looking for a field that might have the same name but be of a different type.
I have checked all the variables in the report to ensure that when they refer to a field they include the table reference just in case. I have checked the script for variable names that might conflict with the report. I have used debug to look at as many variables as I can think of. I have checked the grouping for the report, the total fields, etc etc.
Does any one have any idea what else I should be looking for????
Any help is greatly appreciated.
Barb Hill
Comment