Search results for query: *

thats great. thanks very much! [smile2]

on a test dataset i have created a tbl (testaddress) containing two fields Client_Ref and AddLocality from another table (CR_Clients). I have updated the addlocality values in CR_CLIENTS to Null and now i am trying to put the addlocality back into CR_CLIENTS using the stored data in TestAddress...

using SQL database and crystal 9

when using In in sql i still get the error as above: The text, ntext, or image data type cannot be selected as DISTINCT.

unable to do: and exists ( select * from CR_History Hist where HIST.HistoryType_Ref = 'F' and HIST.HistoryCategory_Ref in ['0','1','2','3'] and HIST.CLient_ref = CR_HISTORY.CLient_ref )

I get the following error from query analyser: Server: Msg 8163, Level 16, State 4, Line 1 The text, ntext, or image data type cannot be selected as DISTINCT.

That is correct. Yes for every client ref i only want to see where the Category = D and at least one other Category of 0-5 for that client. As in AINDJ00 is the sample data.

Many Thanks for all your help. It hasnt given me exactly what I want but I can use the data from the result set. ;-)

no there is no group selection in the report. I used to select all the F Type Histories: {CR_HISTORY.HistoryType_Ref} = "F" and {CR_HISTORY.HistoryCategory_Ref} = "D" I then tried the 2 selections below to get the report to show those records where D and another is recorded...

Client_Ref HistoryType HistoryCategory DateStart ZIMAS00 F 6 8-Jul-04 ZIMAS00 F 5 8-Jul-04 ZIMAN00 F 8 25-Feb-05 ZIMAN00 F 7 27-Jan-05 ZIMAN00 F...

yes i want the report to show me where history category matched D for definate and any others ie 0-9A-Z.

Both HistoryType and HitsoryCategory are Char 1.

HistoryCategory_Ref is coded as 0-9 and A-Z. I want to be able to show for all those client records where history insert 'D' is record. where any other HistoryCaregory is recorded also. The HistoryCategory field is a string.

Thanks. I have tried {CR_HISTORY.HistoryType_Ref} = 'F' and {CR_HISTORY.HistoryCategory_Ref} in ['D', '0','1','2','3'] and I still only get the D records returned. I do not get the record that has D and 0.

This is returning a null dataset. I know it should return one at least as I have a record that contains FD and F1. What is wrong with the formula? In my dataset I need all history categories D and where there is also 0 or 1 or 2 etc. HELP! ;-) {CR_HISTORY.HistoryType_Ref} = 'F' and...

using crystal RAS through a web database application for users to run reports. Is there a way to get a text tip to appear when the user hovers over the report before clicking to run???

Thank you that has worked just how I wanted it to.

I have created the following formula to try and get multiple parameters selected to show: if (join({?area},", ")) = "2" then "Bournemouth" else if (join({?area},", ")) = "3" then "Poole" else if (join({?area},", ")) = "51" then "Beaminster" else if (join({?area},", ")) = "52" then "Bridport"...

I have set up a parameter field to allow users to select more than one value for the report, they could have up to 6. I want to be able to display the values they have included in their report on the front page. I have tried adding the parameter to display on the front page but it only picks...

Just put square brackets round to look like:{CR_CLIENTS.Postcode} like "BH1*" and not (left({CR_CLIENTS.Postcode},4) in...