Expression Builder

Question

I created a report function to find and return a graduation date. I only need to execute the function once per person.

The query returns all colleges a person attended, I only want to report the colleges they attended before their graduation date (or current date if they have not graduated).

I tried to create an expression in the "Print When Condition" CF did not like what I tried. I don't believe I'm referencing the return varible correctly.

We are on CF 9 and I have already spent too much time on this project.

Any and all help will be appreciated.

EddieLotter · Answer

You would be far better off writing your query in such a way as to return only the data you want to see in your report, rather than trying to get the report to ignore certain records in the result-set.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.