Recent content by rier

I hope someone can help!? I am attempting to extract information from within a text string/field. CR claims 'Blob field or memo field cannot be used in a formula'. Is there an alternative approach that anyone knows of? The following is an example of information held in a text field, and I...

dgillz, You're solved the problem!. I was using Maximum ({SmartPointStatus.OrderStatus}="D" rather than Maximum ({SmartPointStatus.OrderStatus},{Customers.ID})="D" Thanks very much for you help and super-speedy response Richard

I'm grouped the report by the customerID. The details section shows each customer record with the corresponding status, i.e, 'A', 'D', etc Thanks Richard

Can anyone help with the following please? Scenario: A customer has various records within one table and each record has a alphanumerical status, i.e, 'A', 'P', etc. I wish to generate a report where the highest status value for the customer is 'D'. Ideally, I would like to say something like...

Ngolem You're right to suspect that the data given in my example is always this neat, actual records in the accounts table would be more: CustomerID Credit Debit Date InvNo 1000000020 NULL 20.00 01/05/2002 50123 1000000020 10.00 NULL 03/05/2002 50123 1000000976...

Can anyone help? I have an accounts table which contains both credit and debits. The history for one customer might look something like: CustomerID Type Amount Date 1000000020 Debit 20.00 01/05/2002 1000000020 Credit 20.00 03/05/2002 1000000020 Debit 50.00 03/05/2002...

Naith, Unfortunately, a 'sample' representative isn't good enough in this instance, but thank you very much for the support you have given me Richard

Naith Thank you very much for your quick response but It doesn't appear to have resolved my problem. Based upon what you have said, the 'InRange' formula works fine, the problem is that the 'BeforeRange' and 'AfterRange' remain at zero. It seems that the date-range parameter has already...

I want to count those customers who do not fall within a parameter range. I have set up a date parameter range and from that, obtain a count of customers who's details were entered during that period. My problem is that I want to be able to: 1) count the customers entered upto the...

Thanks Snedwan, but a little too involved - I basically have a sql script I call from CR using an ADO connection and I just want to be able to pass a date range Anyone else know how to go about this? Thanks Richard

Have you considered using subreports?

Can anyone help? I have an SQL script which I am connecting to using the ADO method. What I want to do is to be able to enter a date range via a Parameter and parse this to the sql script, Does anyone know how to achieve this? Thanks Richard

dgillz Thanks very much for your help - works lovely Richard

Can anyone help? If I create a range parameter and I want 'my selections' to appear as a list on the report, how would I go about this? i.e, I select 'Jan, Feb, April' from my parameter selector, on the report I would then like to see the 3 selected Thanks Richard

Saving a Crystal Report in Excel format, the '£' shows as a '$' (dollar!), does anyone know how to overcome this issue? Thanks Richard