I'm sure I am probably just overlooking something simple but it's beginning to drive me crazy. I have a report that when previewed looks ok, but as soon as it's printed it no longer uses the right table.
I have a simple SQL that generates the data for the report.
Select ... Into Cursor Creport
select creport
report form rptForm to printer Prompt preview
The preview is fine, but if I click on the preview to zoom in out or to go to the next page, Status bar indicating the file in use changes and the report ends up with repeating rows of 0's. I tried reference every field with the alias. I hacked the frx to make sure that there is no data enviroment or that and fields are miss referenced with the wrong alias. I even disabled the form from which this is called from thinking that some event somewhere may be triggering something that changes the alias.
If anyone can tell me what I need to do, I would sure be grateful
Thanks
HJ
I have a simple SQL that generates the data for the report.
Select ... Into Cursor Creport
select creport
report form rptForm to printer Prompt preview
The preview is fine, but if I click on the preview to zoom in out or to go to the next page, Status bar indicating the file in use changes and the report ends up with repeating rows of 0's. I tried reference every field with the alias. I hacked the frx to make sure that there is no data enviroment or that and fields are miss referenced with the wrong alias. I even disabled the form from which this is called from thinking that some event somewhere may be triggering something that changes the alias.
If anyone can tell me what I need to do, I would sure be grateful
Thanks
HJ