Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Crystal Reports: Need Fetch & Store documentation
Message
From
07/04/2000 13:37:34
Walter Meester
HoogkarspelNetherlands
 
General information
Forum:
Visual FoxPro
Category:
Third party products
Miscellaneous
Thread ID:
00356844
Message ID:
00356985
Views:
37
Phil,

>Thanks for the response. I agree about Seagate's online support. Yuk.

>Fetch & Store:
>Well, they are supposed to enable you to get a value back from a subreport. Currently, you can have a parameter send a value from the main report TO the subreport, but you can't do it the same way to get a value back. For instance, if you generate a total in the subreport, and you want to use it in your main report.

>Theoretically, you should be able to call StoreNumberVar("TOTAL",SUM(whateveer)) in a formula in the subreport. Then in the main report you call FetchNumberVar("TOTAL") in a formula, and it should return the SUM that you stored!!

>After you install the UFL for Fetch & Store, then these new functions will appear in your function tree. FetchCurrencyVar, FetchBooleanVar, etc...

That's nice, I've been looking for something like that. I solved it another way, but the next time I need this, I'll remember.

Thanks,

>Unfortunately, I have been doing work for a client who's database odbc driver does not support outer joins. So I can only work with one table at a time in a report. So, I need to use a lot of sub-reports. And, since you can not nest sub-reports, I have the need to get a return value from the subreport.
Previous
Reply
Map
View

Click here to load this message in the networking platform