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

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

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

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

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

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

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

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

I have a report that is grouped by a CustomerID. The details show two records relating to that customer, but I only want to show the record with the minimum(date)! I know I should know the answer, but can anyone help please? Thanks Richard

I need to set up a Parameter Field(PF) that offers a selection from a table. i.e, I have a [NAMES] table and when the report is opened the PF offers me a list of the names in that table - if I added a name, this would be reflected in the list the PF would offer. At present, I have set up the...

I have two tables. One holds customer information, the other, a table that has the following; CustomerID Status 1001046 A 1001047 D 1001047 P 1001047 D 1001048 D 1001048 D 1001049 P etc... I need to isolate only those...

I have two tables where one stores DATE,CREDIT and the other stores DATE,DEBIT. I am trying to create a UNION where the result is one table that details the combined information. I can acheive the above using SQL server with the following query: SELECT distinct AccountCredits.Date...