Search results for query: *

I need to run a query on my database that measures the difference between two datetime values. Submitted and Resolved. This is reasonably simple enough with a datediff function. The problem comes as have I factor in core working hours and week days. Our core hours are Monday - Friday 9:00 -...

I have a report with a number of groups & sub groups. Project - Value Testing Exercise - Service Value Tested So for each project we have a number of value testing exercises and for each value testing exercise a number of services are value tested. For some projects there is more...

I have a report where I need to display certain fields depending on criteria applicable to the project. If the project has benchmarking applied to it I need to display only the benchmarking fields. If a project has market testing applied to it I need to display only the market testing fields...

I'm struggling with a chart in crystal. I need to count the number of projects in a prescribed sector however the chart returns the value in £. I want to change the number format but the Number tab in the Chart - General Dialogue is greyed out. Does anyone have any suggestion sas to how I can...

I hope someone can help me with a formatting problem. The data from the fields of the view I am using is collated from a number of other fields so that it is formatted in report as follows: Shareholder Details Company1<br>null%<br>From: &nbsp;<br>To: Present<br>|Company2<br>null%<br>From...

I know this is quite simple and I've done it before but I'm not getting much success. I have several currency fields in a database I am reporting on. the values are in £m. So at the moment I have the data field and an "m" in a text object. This doesn't look so good where ther is no value in...