Recent content by rafeman

Brilliant, worked a treat. Thanks to you both

Hi All, I have an address field with data such as Sheldruck House : Billericay : Essex I want to replace the ':' with carriage returns. I'm sure this is simple but how do I do it? I've tried update PL_ACCOUNTS set SUADDRESS = REPLACE(':',char(10),CHAR(13)) But its not correct. Thanks

Hi George, Sorry I haven't replied sooner, been busy. Thanks very much, that appears to work after a minor tweak below; SELECT PT_PRIMARY 'InvoiceID', PT_HEADER_REF, PT_NETT, PT_VAT, PT_GROSS, isnull(SU_USRCHAR1,'') Approver1, isnull(SU_USRCHAR2,'') Approver2, isnull(SU_USRCHAR5,'')...

Hi all, I have a query below which returns a list of invoices from the PL_TRANSATIONS table. This was fine but I now need a field from the detail line tavle SL_PL_NL_DETAIL. I've added this in but I onviously now get mutiple rows where the invoice is multi lined. I need to amend the query so it...

Thanks guys, the follwoing gave me what I needed; with MyData as (select ROW_NUMBER() OVER(PARTITION BY DHH_ORDER_NO ORDER BY DHH_DELIVERYNOTE_NO DESC) AS 'RowNum' ,CAST(DHH_ORDER_NO AS float) AS DHH_ORDER_NO , DHH_DELIVERYNOTE_NO from SYS_DEL_HISTORY_HEADER where DHH_ORIGIN in ('SOO') and...

I have the following SQL query that gives me the data I need. However, I need to transpose the rows into columns. Ie. Instead of using union to put them all together I need each query as a separate column. One row per order number. select * from ( select ROW_NUMBER() OVER(PARTITION BY...

Hi All, I'm probably missing something simple here... My report has a column Product Trend Maximum Values Product trend is a sub report for reasons I won't bore you with. Maximum values is a formula using data in product trend. I have created a shared variable called Total in the...

Hi All, I was wondering if any of you have any issues running Crystal reports which contain subreports on Windows 7. One of my users has intermittent problems with the report crashing but it only occurs on Windows 7 and reports with subreport. I've not experienced this with Crystal 2008...

thanks for your replies. Will try adding a table

Hi, I have a report that is needed which gives the summary of sales for each month. In crystal you can do this by grouping by the date field then tick 'The section will be printed for each month'. My issue is the report needs to also show the months where there is no sales. The transaction...

thank you both. Will take a look ASAP

Hi, hopefully I can explain this correctly. I have a transaction table that stores budgets such as below; 01/07/10 - £1500 01/08/10 - £800 The user runs the report and has a parameter called 'SelectWeekEndDate'. Their weeks always start with the last Sunday of the week. So if they select a...

Hi, I know you cannot mask dates in parameters but can put a start / end date in for a range of values. I need the user to only be able to select the last sunday of every week. Is this possible or do I have to put a warning on the report if this isn't selected? Thanks

Hi there, can somebody show me how to get the data and explain the technique to do the following; I have one table Table A PRIMARY PARENT_PRIMARY NAME 1 0 Sales 2 1 Food Sales 3 0 Cost of Sales 4 1...

In fact, just tried it and it works! Thank you again