` Reusing QBE filter in a report (Russ Eggen ) - Icetips Article
Icetips - Templates, Tools & Utilities for Clarion Developers

Templates, Tools and Utilities
for Clarion Developers

Icetips Article

Back to article list   Search Articles     Add Comment     Printer friendly     Direct link  

Par2: Reusing QBE filter in a report
2000-01-22 -- Russ Eggen
 
1) Define a global variable as a CSTRING(255). 2) Use PrintBrowse control template. In the embeds for event accepted for the button, insert a CallABCMethod code template. Select QBEx (or if you have rename the object choose that). The method to call is GetFilter(),STRING. No parameters, return value GLO:Filter. 3) On the browse object kill method, ensure you clean up: GLO:Filter = '' 4) In the report procedure, ThisReport.Open (before parent call) use this code: IF GLO:Filter ThisReport.SetFilter(GLO:Filter) ELSE ThisReport.SetFilter('') END Make and run your app and you will discover that it prints based on the QBE results or if you clear the QBE, then it prints everything. This is in addition to any range limits or sorts you may have in the report.

Today is November 21, 2024, 8:29 am
This article has been viewed 35214 times.


Back to article list   Search Articles   Add Comment   Printer friendly

Login

User Name:

Password:


Gold Subscription
Buy Now
Silver Subscription
Buy Now
Solo Subscription
Buy Now
Multiple Copy Pricing
Renew Subscription