Search results for query: *

Hi All Hopefully a quick one for someone but driving me nuts! I have an excel table that I need to compare a row against the row above it. If the row matches exactly I need to colour BOTH rows GREEN If the values in A, B and C match but NOT D then I need to colour both lines in RED. I have...

Hi all Have a report which data has duplicates in that I need supressed. I have a formula (@qty) in the details section and in the section expert area to suppress I have the formula below. //This formula suppresses the Details line //when there are duplicate values contained in the fields...

Hi All A little help needed if possible? I have a stocktake and data is being pushed into an excel sheet. Problem is that I need to be able to compare columns A, B and D between a row and the row underneath it - if they all match then put "Match" in an adjacent cell. Some sample data below, any...

Hi ALl Been on this for a day or so now and going around in circles so hope someone can advise? I have a report where in the detail line I have a formula named "@f_qty" - this holds a formula as below: if {SL_TRANSACTIONS.ST_TRANTYPE} = 'CRN' then {ORD_DETAIL.OD_QTYINVD}*-1 else...

Hi all I have an ip400 system with 6424D+ handsets. Just added a new handset and all works ok, however when anyone tries to transfer a call by pressing the transfer button then pressing their shortcut button on the right it does not connect. If they however press the transfer button and dial...

Hi All Trying to show percentages for products within a group. In the screenshot below in the "A" section I need to see what percentage that product sales is of the total group sales. Also need to see in "B" the group percentage to all total sales. Can anyone help? Think I'm struggling at the...

Hi All Is it possible to divide a formula by a summary? I have a running total named: @selectiononlygrandtotal I need to divide that by a summary named: sum of @curryearsum Is this possible?

Hi All I have a report which shows all our customers spends by month by year. I have used the group sort expert to only show the top 100 (Top N) and it works great. However, on the totals it shows me the totals of ALL the customers, problem is that I need the totals for just the top 100 shown -...

Hi all any help would be amazing as this is simple but driving me nuts I have 2 x worksheets in one excel document. I want to compare data in column D on sheet1 to data column A on sheet2. If they match i want the value on sheet2 column B to be inserted to where this formula is. Please help! :)

Hi All Hopefully a quick one. I have an Excel workbook with two sheets (Sheet1 and sheet2) I need to compare data in column A on both sheets and colour the cells in sheet2 if they are found in sheet1. Hope this makes sense Thanks

Hi All I have a query i am trying to amend slightly but having difficulties. The query is below, i have a field of STK_PHYSICAL which is highlighted. I also have a field named FREETYPE8 (Highlighted) which i need to show the words "LOW" if the STK_PHYSICAL is less than 6. Any help really...

Hi All I have a query i am trying to amend slightly but having difficulties. The query is below, i have a field of STK_PHYSICAL which is highlighted. I also have a field named FREETYPE8 (Highlighted) which i need to show the words "LOW" if the STK_PHYSICAL is less than 6. Any help really would...

Hiya I need to sort some data and have built a query but need to get it right as this wont work. Can someone see where i am going wrong? Think the issue is where i have put the "where POD_QTYRESERVED>0" is the wrong place as if i delete it the query works ok. Thanks as always Select...

Hi Guys I have a field which hold 2 or 3 lines of address. I need to get each line in its own field in crystal. For the top line i have used: replace({mytable.myfield},chr(40)," ") and this works ok For the next line i tried the formula below to show all after the carriage return but it goes...

Hi guys looking to upgrade our existing sql server 2005x32 to sql server 2005x64. Our existing sqlserver is running on an ESX vmware machine which is 32bit (Not sure why they done this as the main OS on th emachine is 64bit. Will i have to upgrade the ESX to 64bit or should i be able to simply...

hi everyone. I have a query below and need to add a condition in but stuck where to add it. Query below: SELECT dbo.STK_STOCK.STKCODE, '' AS Spare, dbo.STK_STOCK.STKNAME, '' AS UnitOfMeasure, '' AS UnitOfSales, dbo.STK_STOCK.STK_BASEPRICE...

Hi ALL I have a query which i need to add a new aggregate in but going around in circles on where to add it in the query. The query is below: SELECT dbo.SL_ACCOUNTS.CUCODE, dbo.SL_ACCOUNTS.CUCODE AS HeadOfficeAccount, dbo.SL_ACCOUNTS.CUNAME...

Hi Guys Having a headache with this one and really could do with some guidance. I have the script below: SELECT dbo.STK_STOCK.STKCODE, '' AS Spare, dbo.STK_STOCK.STKNAME, '' AS UnitOfMeasure, '' AS UnitOfSales, dbo.STK_STOCK.STK_BASEPRICE...

Hi I am trying to sort a grouping out but cant get the syntax right for the CAST function. Below is what i'm trying to convert but keep getting the error "Column 'dbo.SL_ACCOUNTS.CU_NOTES' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY...

Hi All I have a n error message when running the script below, it states "Msg 102, Level 15, State 1, Line 27 Incorrect syntax near ','." Can anyone point me in the right direction please as this is my first time grouping? Many thanks SELECT dbo.SL_ACCOUNTS.CUCODE, dbo.SL_ACCOUNTS.CUCODE...