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.
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...
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...
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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.