Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reporting from a view - HELP!
Message
From
10/11/1997 17:01:27
Elyse Pomerantz
Dynamic Data Concepts, Inc.
Brooklyn, New York, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Reporting from a view - HELP!
Miscellaneous
Thread ID:
00059393
Message ID:
00059393
Views:
81
I have a grid on my form that is based on a view and I want to print a simple report of what shows in the grid. I used the Report Wizard to design a report from this view. The report contains ONLY fields from this view. In my Print button on my form, I simply say:

select MyView
report form PrintView to print noconsole

For some unknown reason, the report is trying to print from another table! If I suspend after the 'select MyView' command I see that MyView is NOT actually selected, but I can't figure out why.

More details:
1) It doesn't matter whether or not the fields in the report have an alias.
2) It doesn't matter whether or not MyView is in the DataEnvironment of the report.
3) If I step through the code from before the 'select', it works fine.
4) If I 'Browse' instead of 'Report form...', it is on the right file.
5) The STRANGEST - if I say 'preview' instead of 'to print', it previews fine!

I've tried everything I can think of to no avail. This is happening in more than one form with different sets of files/views. Any help would be GREATLY appreciated!

Thanks
Elyse
Elyse Pomerantz
Next
Reply
Map
View

Click here to load this message in the networking platform