Search results for query: *

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

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

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

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

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

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

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

Hi Am having problems with SQL syntax (see thread149-1010570 fro details). Expression is: (SELECT AKA."MEDIA_CODE" FROM SALES_ITEM AKA WHERE AKA."SALES_DOCUMENT_NUM" = SALES_ITEM."SALES_DOCUMENT_NUM" and AKA."SALES_ITEM_NUM" = 1) All the information I hvae regarding the datasource is...

Hi Am using CR8.5 and SQL2000. I am trying to write a report extracting infomration from a sales database. I wish to group data by Group 1 - media code (a 3 figure code assigned to a customer group type) and specific to a mail order campaign e.g. Winter 2004 or Spring 2005, on the first...

Hi Have not been using Crystal for 2 plus years, so seem to have forgotten a lot! I have inherited a report that details the discounts applied to sales orders in grouped by order source e.g. Mail, telephone, Web CR 8.5 I have 4 groups: Grp 1: Order Source (suppressed) Grp 2: Discount Code...