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 -...

Thanks for your patience

The structure of the data is: Project - Value Testing Exercise - Service Value Tested I want to, if possible, keep the project and all its related data together. If the data goes into more that one page, I want to ensure that there's a page break only after a group. At the moment...

Is there any way of using formulas to keep one group with it's parent group unless they go over the page or to insert a page break to minimise the white space.

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...

Thanks that worked a treat

I know I'm being a bit dim but I am bit of a newbie to crystal. Could you give me an example of the syntax or the formula you'd use to suppress a field conditionally or suppress a group conditionally. Thanks

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...

It's a count on project name, so it shouldn't be returning the value as currency at all really. I'm a bit baffled as to why is won't allow me to use number tab though.

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...

Thanks that worked well.

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...

This is a report from a SQL database and using formula editor. If the filed is blank of the database I want it to be blank on the report so we can see where we need to add data. I don't want a rogue "m" where there is not data as it looks untidy. Thanks for your help

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...