|
|
|
Forum Newbie
Group: Forum Members
Last Login: 1/12/2010 12:43:39 PM
Posts: 7,
Visits: 16
|
|
Hi,
I am creating a report that prints the Workorder Item Scheduled User rows, when some of the rows have NULL Start and Stop dates.
However, they always print as 01/01/0001 12:00:00 AM.
I tried setting "Process Null Values" to Suppress, but still they show. I also tried adding a formatting rule, but I couldn't figure out the proper condition expression.
Can you let me know how to suppress printing the start and stop dates if they are null?
Thanks
|
|
|
|
|
AyaNova Sales & Support
Group: Administrators
Last Login: 2 days ago @ 7:34:22 AM
Posts: 2,190,
Visits: 5,029
|
|
| Good morning I would assume probably an "if" statement would be used - something like: if (label.text = "01/01/0001 12:00:00 AM") { labelxx.visible = false; } - Joyce
- AyaNova Sales & Technical Support
- http://www.ayanova.com
|
|
|
|
|
AyaNova Sales & Support
Group: Administrators
Last Login: 2 days ago @ 7:34:22 AM
Posts: 2,190,
Visits: 5,029
|
|
| For example, in the sample Dispatching Report template, if I had a workorder item with three scheduled techs, and one of them had no Service Start Date/Time nor Stop Date/Time, the report would look like this for the Service Start Date/Time datafield: 
But if I edited the BeforePrint script for that field with the following (as on my computer it displays as 1/1/0001 12:00:00 AM - whereas yours might be different) : if (xrTableCell16 == "1/1/0001 12:00:00 AM") { xrTableCell16.Visible = false; } else xrTableCell16.Visible = true; 
Then when the Service Start Date/Time equals 1/1/0001 12:00:00 AM, then that field is not visible, otherwise it is: 
- AyaNova Sales & Technical Support
- http://www.ayanova.com
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 1/12/2010 12:43:39 PM
Posts: 7,
Visits: 16
|
|
|
|
|
Posted 8/13/2009 7:59:07 PM
Post Attachments 
