OK so I have been reading up on this. Currently using CR 2008 and server is XI R2. I used an alternative to HasValue() and replaced the statement with IsNull() now that I am passing this in the report to the server it completely ignores this and makes the report non-interactive in CV 2008. Any thoughts as to what i am doing wrong?
If IsNull({?Course Parameter}) or {?Course Parameter} = '' Then
True
Else
{courses.course_key} = {?Course Parameter}
this is saved under Saved Data Selection.
If IsNull({?Course Parameter}) or {?Course Parameter} = '' Then
True
Else
{courses.course_key} = {?Course Parameter}
this is saved under Saved Data Selection.