Hello
I'm struggling with a parameter, can aybody offer any advice please?
I have two parameters on a report but i want to be have the option to leave one blank, after looking at a report i've inherited i've got to here:
{SRS_URA.URA_APID} = {SRS_IOI.IOI_APID} and
if not (hasvalue({?Student ID:})) then true
else {SRS_URA.URA_APID} = {?Student ID:} and
{SRS_CAP.CAP_APID} = {SRS_IOI.IOI_APID} and
{SRS_CAP.CAP_AYRC} = {SRS_IOI.IOI_AYRC} and
{SRS_USA.USA_APID} = {SRS_IOI.IOI_APID} and
{SRS_CAP.CAP_MCRC} = {SRS_IOI.IOI_MCRC} and
{SRS_IOI.IOI_IODD} = {?Applicant Day:}
basically I want to be able to leave Student ID blank and run it just based on Applicant Day.
any help would be appreciated.
Thanks