View Full Version : invalid Report Filter Expression


René Stout
08-21-2004, 12:29 PM

I think I copied the Print Invoice thing from the demo database.
However, I keep getting this error:

500 Internal Server Error
Script Error
Error:Invalid report filter expression: 'Lid_Id = "L1557"'.

Alpha Five Web Application Server/6.0 Build/1532 at NVST Port 80

Enclosed is the A5W page that calls the report. The A5W is called by a link in a component, just like the demo database.
The field Lid_Id is a Character field and is unique. The values are like L1234.

What do I do wrong?

greetings, René

Selwyn Rabins
08-21-2004, 06:05 PM
go to the interactive window and
type this:

report.preview("brief_acceptgiro","lid_id = " + quote("L1557")")

does that cause the preview window to show correctly.
if not, then that's your problem.

René Stout
08-21-2004, 11:58 PM
Hi Selwyn,

I think I should start all over again and try to fly over and follow a course...

I found the problem: the field Lid_Id is part of a set, I had to put the table name in front of it.
Also I changed one name to "Filterveld" (value to filter on) to prevent confusion with the field that is actually filtered.

IF eval_valid("Filterveld") = .f. Then
goto skipreport
end if
dim filter as c
dim order as c
Filter = "Leden-"Lid_Id = " + quote(Filterveld)

Greetings, René