Search results for query: *

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

Guys Thank you very much - easy when you know how! Richard

I hope someone can help If I group by a field in a table and some of the entries are NULL, then this has an impact on a percentage rating. i.e, 2,016 0.00% A 7,675 13.11% C 216 0.37% D 24,057 41.08% K 1 0.00% P 26,601 45.43% X 6...

Have you tried setting the location? i.e, Via the toolbar, sellect 'Database', then 'Set Location'. You will see a dialog box listing the tables in use, but more importantly (for you), at the base of the dialog you will see 'Server Name:xxxxxxx'. To change, select the 'Set Location' button...

Can anyone help? I have an ADO connection and the beginning of the SQL is as follows... declare @fromdate as datetime declare @todate as datetime set @fromdate = 'Jan 01 2002 00:00:00AM' set @todate = 'Jan 30 2002 00:00:00AM' SELECT count(*) as groupcount, CustomerGroup.ID...

Stanfa Perfect. Incidently, I also found a workaround. Initially I had a Group1 based upon the CustomerID and put various fields in the details section. This is why I ended up with more than one record per customer. By moving the fields from the details section to the Group1 section and...