Recent content by markcobb

Sorry, I forgot to add that this is not for one record but for a multitude of records, therefore the top 1 etc would be fine against one Incident but not against many. Any other ideas

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.

Sorry to appear daft...but I am not sure I understand. Are you saying I should use these formulas on the Date field or the Total field

Not sure if this helps but doesnt a crosstab require some information even a zero to work, if you remove the 0 then no data at all will be returned

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

Thats the one Naith, Many many thanks for all your help.

Yes I have tested in CR first. Refreshing the report etc each time I have changed the DB etc, and each time I have then refreshed the report and tried in EPortfolio. So to recap. I have added this to the report header WhilePrintingRecords; NumberVar Zero; If...

OK, I have added another count({Contract_PaymentDate.adcurrency}) and it returns the value of 1, which is correct and in accordance with the report. I then change the data in the db so that the Report criteria was not met (i.e. I changed the date) and the report now does not bring back...

Naith, OK this now does not error out everytime I try and run the report. I have placed the formula in the report header and when data is returned it show a 0.00 i.e 1 row returned. However when I run this where the row count is = 0 the report does not fall over it just returns a blank report...

Contemporary alos do a software item that does the things below.

OK, I have copied this into the report header If DistinctCount ({Contract_PaymentDate.adcurrency}) < 1 Then 1/0 Else 0 Whereby the {Contract_PaymentDate.adcurrency}) is required in the Database. The report runs off of the proviso that the Payment_Date = Current Date and this has been added...

Naith, I cant seem to get this to run as it always falls over with the divide by zero error regardless if the count is > 1 or < 1. I have tried putting it into a formula and into the record selection.

Many thanks for that, I will give this a go now and see what happens.

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