Search results for query: *

Ian - you are officially a hero to my lettings manager now - it worked.! THanks for a swift reply. Regards, Adrian

Hi. Using Crystal XI I have a string address field that contains some street names and some street names with house numbers e.g 123 Example Street 123 Example Two Street Example Three Street 123 Street Example Street I need to be able to trim this to be show only the street name (i.e. no...

That simlpe huh! I feel really dumb now. Thanks - it worked. BW, A

Hi Gordon Has taken me a little while to get back to this. I am pleased to say this has worked. The final thing I need to do is to display the final RT amount as a closing balance. The manual running total is in the detail section, the reset is in group header two, and the closing balance is...

Hi - this looks good and sounds like it should work. I am not in office today or Weds, so I'll check Thurs and let you know how I get on. Thanks for the swift reply! BW, Ade

Dear all I am using CRXI on a SQL2005 db. I am attempting to produce a tenant rent statement that should show th eopening balance, credit and debit transactions with a running total and a closing balance. The opening balance is fine and is a field called opening_bal. This works for the...

I have discovered an overflow table containing remaing text and concatenated the two fields!

Hi - I am sure there is a VERY simple solution to this, but I am getting v. frustrated. Have read many threads around this but am none the wiser. I have a string field that is limited to 255 characters. When the field is inserted in to the report it displays the 255 characters. However, when I...

Dear all I am working with CR XI on a SQL database. I have a Rent account name field which if is a joint tenancy will contain either and '&' or the word 'and' e.g. Mr and Mrs X or Mr & Mrs X. Where the tenancy is a sole tenancy it will only be Mr X or Mrs X. I have grouped my report by...

I found the following very useful and solved the problem. the CR memories are coming back now! thread767-1133866

Hi all CR XI SQL Server I have a report with group header 1a of lead applicant name. Group header 1b contains 5 subreports, each pulling in information about different areas of work and is linked by USER_ID - Testing has shown the data is correct. I want to be able to suppress 1a (name) if...

Thanks for your replies. My director has authorised the purchase of CR Server so problem resolved. My IT development team will deal with user passwords as well so no headache for me now! Regards, Ade

Hi. I have designed a number of CR's with CR XI - we need to be able to distribute the reports to end users who do not have CR installed on their machines. I am not in a position to purchase CR Server at this present time. The data for the reports is held on a server based at a 3rd party site...

Thanks Crowley16 - NZ worked perfectly. One day I'll get the hang of this! Ade

Hi I have what is a simple quey but I am struggling with syntax in Access - I dont use it much as most of my work is in Crystal Reports. I have a text field in a table that is a value list combo-box containing the sub-programme of a research project - Change Management, E-Health etc. It is...

Thanks Golom. I used Expr3: IIf([Add on]=Yes,([Expr2]+[Add on cost]),[Expr2]) in the end. managed to figure out a bit more of access! Ade [thumbsup]

Thanks Remou but no joy! The expression looks like this: Expr3: If( [Add on]=TRUE) then ( [1st FY]+[2nd FY]+[3rd FY]+[4th FY]+[5th FY]+[6th FY]+[7th FY]+[Extension cost]+[Add on cost]) else [Expr2] [Expr 2]is the sum of the fields without the add on cost. The message I am getting is '...you...

Hi. Am new to Access and do not know it very well - am much more comfortable with Crystal Reports! I am sure that this is a VERY basic request, but I am lost. I have searched through other posts but cannot really find what I am looking for. Am using A2K and need to build an expression. All...

Hi CR 8.5 Oracle I have a sales report (which has worked for 2+ years when I first designed it and was proficcient with crystal!!!) but have now been asked to make changes to it to incorporate sales data for the same time period for each of the previous 3 years. THe report layout is: Group...

Thanks for your help guys. Have got this to work now! Ade