PDA

View Full Version : Can't define filter lookup



Michael Macliver
16-Mar-2016, 12:09 AM
Hi,

I've just created a new report and added a single Filter on the customer code. But when I set the Search Type to Select the list of lookups does not appear. What have I forgotten?

9866

Bob Cergol
16-Mar-2016, 08:54 AM
Hi Mike,

bug....

For whatever reason, the "#" ending character in the column name confuses the logic on that entry form.

Work-around:

1) Caption the column in the backend data source removing the # character, or by making a new column on top of that column in the report and use it for the filter.

2) Define the combo filter in on-screen report design, i.e. click on the DMACC# column title in the displayed report and select "filter combo". If you want the values for the combo to come from a keylist report instead of the table.column itself, then you'll have to caption the column to remove then ending # character to be able to select the keylist report in design mode.

Regards,
Bob

Michael Macliver
18-Mar-2016, 03:24 AM
Thanks Bob, spot on. I'm sure I hit this one previously but had forgotten it was associated with the #. I recently defined a new SQL View and had left these in.