Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Flash poof it's gone
Message
From
18/12/2006 18:12:05
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
18/12/2006 15:50:49
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01178692
Message ID:
01178749
Views:
12
>>>>This line of code causes my report to flash onto the screen and then disappear.
>>>>It's been a while since I created a report, but I think a line such as the one below used to work. Have I made an error for the very first time in my coding career?
>>>>
>>>>Report Form incident For Alltrim(crimetype) = "Vandalism" PREVIEW
>>>>
>>>
>>>Maybe you don't have 'Vandalism' anymore? :)
>>
>>I wish!;-) It's in the table.
>
>I got it - The data environment was hooked to a test table in another folder. Sorry folks.

Why, yes, that is a frequent source of "fun".

In general, I would also recommend, to avoid the report flashing if there is no data:
select ...
if _tally > 0
  report form...
else
  ErrorMsg("No data for report. Perhaps you should change the selection criteria.")
endif
I have this incorporated generically, into my reporting classes.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform