Passing Job Number to Service Manager Job Report
Posted: Fri Jan 19, 2018 4:58 pm
Hi
I have created my own Job Sheet which is working perfectly, but I am just unsure how to pass the current JobNo to the report. I looked at the standard Jiwa report but it is using a stored procedure, I have used a SQL query within the Crystal report as my data source.
Currently the report returns every Job Sheet, does anyone know how I can restrict it to the currently loaded Job Sheet?
Thanks in advance
Trevor
I have created my own Job Sheet which is working perfectly, but I am just unsure how to pass the current JobNo to the report. I looked at the standard Jiwa report but it is using a stored procedure, I have used a SQL query within the Crystal report as my data source.
Currently the report returns every Job Sheet, does anyone know how I can restrict it to the currently loaded Job Sheet?
Thanks in advance
Trevor