Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pass a QBE filter to a report

Status
Not open for further replies.

AlanBreck1000

Programmer
Oct 20, 2005
28
US
Using Clasrion 6.0 Enterprise and followed the example from the book to pass a qbe filter to a report.

The book example states to take note of the QBE class on the QBE option tab after adding the template to the browse, I get QBE10. Then when placing the print from browse button on the same browse at the accept embed point place the following code : GLO:ReportQueryResult = QBEn.GetFilter
replacing the n in QBEn with your QBE class which in my case is 10. Upon compiling I get unknown identifier. I have declared the global variable ReportQueryResult and followed the example top the letter but to no avail. All I want to do is query the browse and see these results in the browse then pass these results to a report.

I have tried other examples found around the internet one being to allow the results by qbe template to be placed in string then that string passed to a report, again to no avail, can anybody shed a little more light on this subject.
 
Hi!

Assuming the generated VIEW of the Browse & the Report are the same, you could just find out the filter by ::

Code:
GLO:ReportQueryResult = BRWn::View:Browse{PROP:Filter}

Regards
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top