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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.