ABC: Passing QBE filter to a report 1999-08-04 -- Russell B. Eggen [topspeed] Newsgroups: topspeed.products.c5ee > Is there a simple example of using the new QBEClass to filter a record >set and then pass that to a reporting procedure? I have looked through >the new "Learning your ABCs" book, and I cannot seem to find any >discussion of reporting on queried data sets. Anyone? Thanks in >advance! Declare a global variable. Make it a CSTRING. In your QBE template, there is a dropdown list asking for which control will receive the results of this query. This control (suggest using a string based on the global variable), has to be on the window, but you can turn on the hide attribute if needed. While testing, you may want to defer this until you know it works. In your report, this is used as the filter for the report or band (depending on how you want to use it). Both entries for the filter condition are found under the Report Properties button. -- Russell B. Eggen Printed May 3, 2024, 3:07 am This article has been viewed/printed 35122 times. Google search has resulted in 36 hits on this article since January 25, 2004. |