Hi there,
I have read that you cannot have a forumal as a paramter so I wondered what a work aroudn would be. I have a field that is featured in two tables;

1. {vwSPPlannedSession.ConsultantCode}
2. {vwSPActualSession.ConsultantCode}

Sometimes the Actual code is not completed and in this case I need to seek out the Planned code. If Actual code exists then it is fine to use that.

In a formula this is easy:

IF ISNULL({vwSPActualSession.ConsultantCode}) THEN {vwSPPlannedSession.ConsultantCode} 

ELSE {vwSPActualSession.ConsultantCode} 

But how do I put this logic into a report to query this as a parameter?



Edited by skinfreak - 25 Apr 2012 at 3:33am