Hi,
I need to show any jobs which are on hold but I want them removed when their status changes to in progress, so am guessing it would be a if-and-statement?
I have journal entries which show job number, date and time of the journal entries and a series of descriptions. The descriptions I am interested in are the ones that say ON HOLD. I want these jobs to show if they have not been put back into production.
{journals.jobnumber} {Journals.datetime} {journals.description}
123456 09/09/2011 9.09am ON HOLD
123456 09/09/2011 9.30am IN PROGRESS
234512 09/09/2011 9.32am ON HOLD
457593 09/09/2011 9.45am ON HOLD
So based on the example, I have 3 jobs which have been placed on hold, however of those, job 123456 has been placed back into production, so does not need to appear on the report.
I thought I could have something like
@Restarted
if {@On Hold} = "On Hold" and
if {Journals.Description} like "*In Progress"
then "restart"
However I think my syntax is out as I get an error "The keyword 'then' is missing"
What is the proper syntax etc to use for an if-and-then statement?
(Am using CR2008 & SQL database)
Thanks
Joanne
I need to show any jobs which are on hold but I want them removed when their status changes to in progress, so am guessing it would be a if-and-statement?
I have journal entries which show job number, date and time of the journal entries and a series of descriptions. The descriptions I am interested in are the ones that say ON HOLD. I want these jobs to show if they have not been put back into production.
{journals.jobnumber} {Journals.datetime} {journals.description}
123456 09/09/2011 9.09am ON HOLD
123456 09/09/2011 9.30am IN PROGRESS
234512 09/09/2011 9.32am ON HOLD
457593 09/09/2011 9.45am ON HOLD
So based on the example, I have 3 jobs which have been placed on hold, however of those, job 123456 has been placed back into production, so does not need to appear on the report.
I thought I could have something like
@Restarted
if {@On Hold} = "On Hold" and
if {Journals.Description} like "*In Progress"
then "restart"
However I think my syntax is out as I get an error "The keyword 'then' is missing"
What is the proper syntax etc to use for an if-and-then statement?
(Am using CR2008 & SQL database)
Thanks
Joanne