Search results for query: *

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

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

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

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

Hi, I have the following trigger set up. All its designed to do is after an insert into the PL_TRANSACTION table it copys data from the PT_BATCH_REF field into PT_INTERNAL_REF. However my issue is at present it updates all rows with this information. I want to to only effect the inserted row. I...

Hi, I have the following table PRIMARY DATE GROUP 1 10/08/08 Residential 2 12/08/08 Self Build 3 10/08/08 Self Build 4 11/08/08 Domestic 5 09/08/08 Residential The user wants a report as following; Parameter (Date) Qty Tasks Qty...

Sorry for my ignorance buy i'm relatively new to triggers. I want to create what I believe is a simple trigger. I have a table called ACCOUNTS with the following fields ACCNT, BSORT, BACCOUNT, BNAME, USER. I have another table called BANKCHGS. What i'm trying to achieve is when the...

Hi, we have just installed a new server on Windows 2003 with a workgroup, no domain. If my laptop is connected to the LAN and I tried to find the server by its name (DPS2) it cannot find it, I have to use the IP Address. However, if I VPN in to my server from home it finds the server by name...

I have a Zoom X6 Wireless router that works perfectly well for 2 laptops and 2 pcs in my home network. As soon as I try to add WEP security I get limited conenctivity message and hte internet will not work. The machines all connect but cannot receive the DHCP settings. The WEP is accepted. My...

Hi, I've come across a really weird crashing error when using crystal on one particular report. Bascially the report previews fine, runs fine, but will not save. If I modify it and try to save it crashes crystal. It has been tried on different machines and CR9 & CR11. It is only specific to...

I have recently received a new latop with Vista, SQL Express as opposed to XP and MSDE that I had previously. Since installing Crystal V11 and using the SQL Native Client I cannot connect to the databases on there. When adding a new connection only the master database exists. I can view the...

Hi, Is it possible to have a calculation within a view? E.g. SQLView Date Amount 13/03/07 £100 13/03/07 £1000 I would like a manually calculated field in the view for VAT. E.g. Date Amount VAT 13/03/07 £100 £17.50 13/03/07 £1000 £117.50 Is there a way of doing...

Hi, I have lots of Windows VPN connections created for remote support on some software. Recently one of my clients asked me to use Cisco to connect to them. After installing this the Windows no longer work. They connect but will not authenticate the username and password. My questions are...

Dear All, I have a report in the following structure; Order No. Route Route OTY Order QTY 9 PRE 5 10 9 BRIQ 5 10 1 PRE 8 8 3 BRIQ 9 9 6 PRE 2 15 6...

This may or not be possible, but here we go; I have a SQL table as such; SchoolNo Notes Date 1000 Visited 01/09/06 1021 Not interested 10/06/06 1021 Now interested 11/06/06 1000 Spoke to teacher 10/07/06...