Iโve tried filtering a report using the Condition Expression Builder. The objective is to look at last monthโs appointments. However the expression builder will not show the right data slice. Even with the right slice selected in Table name, the columns it presents for picking in Expression Builder belong to another table.
Even if I attempt a dereference it tells me thereโs no such column as โAppt Dateโ. Also attempted to add a File Name Prefix such as concatenate(โAppt for theโ," ",MONTH([Appt Date])-1) which also returns that itโs unable to find the Column. If I try just a simple insert of the column name this also fails with same error. However Expression builder parses it happily.
Please post a screenshot demonstrating this.
Reordered as you wouldnt see it natively. Left is the Report Windo showing selected slice. Right is the resultant Expression Query Builder that shows columns from Client List table. Bottom what it should show.
That image makes no sense to me.
@Steve can I reach you by mail? As Iโm new, the forum wont permit me now to add any more images to this post!
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |