Login
`
Templates, Tools and Utilities
|
||
Add a comment to an Icetips ArticlePlease add your comments to this article.
Please note that you must provide both a name and a valid email address in order
for us to publish your comment. Comments are moderated and are not visible until they have been approved. Spam is never approved!
Back to article list Search Articles Add Comment Printer friendly Direct link 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
Today is November 21, 2024, 6:59 am This article has been viewed 35402 times. Google search has resulted in 36 hits on this article since January 25, 2004.
|
|