Filter Report using Check-Box List-Box xdlg

[Tom Cone Jr]

Re: Filter Report using Check-Box List-Box xdlg

g, sounds as though you're having trouble adapting the AlphaSports example script to your database. Can't help you further without seeing your database and your implementation of the script that works in AlphaSports.

An easy adaptation to preview the customer list report in alphaSports would change the corrected script I posted would look something like this... at the very end of the script:

'now use filter in query against Customer table
'after the script is run open the default browse for this table to 
'    verify that the query ran correctly.
't = table.open("Customer")
'query.options = "MT"
'query.order = "Bill_city"
'query.filter = filter
'idx = t.query_create()
't.close()

report.preview("Customer List",filter,"Bill_City")

[Tim Kiebert]

Re: Filter Report using Check-Box List-Box xdlg

As Tom, I don't know what else to suggest either.

I can confirm that the latest rendition of Tom's script (apart from removing the ",local_variables()" from the message text line) works. ie It results in a report preview. As did report.preview() and preview_report() with my test form.

[G Gabriel]

Re: Filter Report using Check-Box List-Box xdlg

Thanks Tom & Tim.
I am still working on this script. I can't quite understand why it works in alphasports but not on my DB.

I re-wrote the script and replaced Tom's routine with a different expression that transforms the crlf() into a srteamed string with field='...".or.field='...'
still no luck.

I deleted and re-created a new report in case the report is corrupted: no luck.

Tried to run it on a different report and a different table: no luck.

Maybe every table and every report in my DB is corrupted, but when you hard-code the filter, the script runs great ! So, it's neither the tables nor the reports.

Compacted the DB: no luck.

Tried every expression to eval filter, quote it, unquote it etc.: no luck

The script is stuck on one problem: the filter. I keep getting "invalid report filter". How is it invalid in my DB yet valid in alphasports?!

This one of the most annoying things when things don't workwith no clear reason why and I am not in the mode to keep fighting with it.

[Tom Cone Jr]

Re: Filter Report using Check-Box List-Box xdlg

g,

I am willing to help, but need the working model of your database and directions to the specific script in question. Years of experience in this message board has taught me the futility of trying to debug someone else's code without being able to see it or the data it's manipulating. Won't do it.

-- tom

[G Gabriel]

Re: Filter Report using Check-Box List-Box xdlg

Tom:
Here is a bare bone greatly simplified copy of the table I am working on.
It's self-explanatory.
Thanks

[Tom Cone Jr]

Example

Here you go.

[G Gabriel]

Re: Filter Report using Check-Box List-Box xdlg

Tom:
The script runs just fine if you run it from the code tab, but try to put this script on the form (or click the button I have on the form), if you do that or if you want to run the script from a custom menu for example, you still get the error message.

I place a button on the form to run the saved script: same result. I tried to run it from a custom menu: same. I made the variables global, it did not change anything.

Something in the back of my mind reminds me of such problem but I can't just remember why a script would run from the code tab but not from anywhere else!

[G Gabriel]

Re: Filter Report using Check-Box List-Box xdlg

Now I got it working on the button on the form in the test table, but not in my DB ??? I keep getting the same error message: "invalid filter expression" !!

[Tim Kiebert]

Re: Filter Report using Check-Box List-Box xdlg

g,

running your sample as supplied I confirm that the error is 'filter expression not logical'.

To get the report to preview I commented out this line:

'filter="\""+var->filter+"\""

Edit: Sorry g, too slow, you're obviously past this point.

[G Gabriel]

Re: Filter Report using Check-Box List-Box xdlg

Tom/Tim:
I can't thank you enough for working on this. I found the culprit! I had suspected it early on and I thought I did the necessary precautions to avoid it, but evidently not.

The problem is, working with a process of elimination, the report I was printing is based on a set. When I changed the report to one that is based on a table, it worked. Unfortunately, I have to have a report that is based on the set.

I did change the pointers in the script to point to the proper field, for example instead of using "item=" I used a full reference "table_name->item" but still kept getting those error messages.

Now, if I could figure a way to run the script for a report based on the set, that will be great. Maybe "->" is not the proper pointer. Maybe I need to try "@".

I will play with that and if you have other suggestions, I greatly appreciate it.
What a bomber!
Thanks

[G Gabriel]

Re: Filter Report using Check-Box List-Box xdlg

By the way... the speed is blazing !

[G Gabriel]

Re: Filter Report using Check-Box List-Box xdlg

Now, I could go to sleep !

I used the same pointer "->" for a report based on a set and it worked. I debugged my script and I had too many quations in it!

Thanks again!

[Tim Kiebert]

Re: Filter Report using Check-Box List-Box xdlg

I debugged my script and I had too many quations in it!

Scoured the help file for quations but couldn't find a reference to it. But by your reckoning having too many of them is not good.

Glad you got it worked out.

PS Sleep well and don't let the quations bite :D

[trackmanpete]

Re: Filter Report using Check-Box List-Box xdlg

Tom and Tim:
I just came upon this thread in my efforts to print some multiple selected records and just want to thank you all for a great solution. This should definitely be in the archives as an example of using the multiple selection process. It works great in V8.

Thanks again.

Pete Schuder