Search results for query: *

Please help, I have a table called Incident, these Incidens then have an Audit Table to show when the last call etc was made. These are denoted by a Worknoteid, what I want to do is create a view that only returns the second to last and the last value from this table. E.G Incident 1234 has 5...

Is there any way of applying your own custom colors to a Bar chart in Crystal, so that if I had 5 different reports with 5 grapsh each showing 10 Customers and Cust 1 was blue, Cuist 2 was Red etc. Instead I find Crystal using all sorts of funny colors.

I am trying to create a report where by I have a Start Date and a Total Value fields. The Start Date denotes the Contract Start Date and I want to spread this evenly over a 12 month period. For example I want to have a Contract that starts on 01/03/2002 and ends on 28/02/2003 for £10000.00...

I am trying to create a report that will only mail to personnel when the report returns >= 1 row of data. By this I mean that the report may not have an instance for a number of day and then 5 in one day, on that one day the report shgould be sent out. I have tried creating files using sql by...

Hello all, I have a problem trying to get a date diff out of Crystal. In essense I have Support calls, these calls have and Insert Date, these calls are then responded to and create an Audit Date. All ok so far. The next thing is that these calls have different SLA's, say one might be from...

I am trying to build a report that relies on a Part Numbers. The user requires a Parameter field so that they can select either one part number, all part numbers or a range of part numbers, so far so good. However, they also want the ability to enter in the Parameter field something like JH*...

Does anyone know how to set up a calender type function in CR 8.5. I want to write a crosstab with the this months dates e.g. 01/07/2002 to 31/07/2002 and have registered under these a count against each day when a certain incident happens. Please help

Can anyone help me. I am trying to find a way to automatically update a picklist in version 8.5 of Crystal reports. I have, so far, created a schedules job on the SQL box to allow the data to be written to a text file, this runs every hour, however it does not update the report when a user...