Search results for query: *

Hi I am trying to use the select expert to chose data that contains the word "docket" somewhere in the field. I assume i use the instr command but cannot make it work. Many thanks

Hi as our database HistQ3 and HistQ4 were full we migarated to two new tables Called "Lists" and "Products". I have been through the set database location and have updated the location, however this does not update the report it still looks to the old tables. Is there any way to make...

I am trying to count how many times someomne uses a piece of equipment each week. As the person can accidently scan in twice on a day I need to exclude the second scan of the day, but cannot seem to use running totals to stop this or use a counter. Exmaple Data where I want to find how many...

I have a dataset of :- tblClockingRecords.dteDate Thios returns the date and time. I want to change this to a number and expected "tonumber" to work but says that the remaining text does not seem to be part of the formula. Any ideas. I intend to concatenate this number when I can get it...

I have a printer which requires a password in printing preferences to print. Usually on add a printer I put this in for users. How do I do this for CRS 2008 as without this the printer purely warms up but does not print. I know I can do this as I managed printing on the old server however...

Hi I am trying to view with crystal viewer reports on the crystal report server, it may not be possible. To see crysal reports server I use the web site similar to below http://mywebsite:8080/businessobjects/enterprise115 It says in viewer it is not valid any ideas why?

On a speadsheet I have a row of say thirty numbers which I want to count numbers not equal to 0. Using count I can only count those including zero, I use count(b1:Z1). what should i sue? I am on Excel 2003 Thx

I am new to sql but pasted the sql from cystal into a pervasive sql command and it ran. I then made it into a view and it does not like the "order by". Does order by work in pervasive sql views or is there another way? Thanks

I hope this is the correct forum. We use Sophos pure message which works well except for Spam which is say:- "The good and bad followed by a hyperlink. OK I can put the phrase into the filter but tomorrow there phrase will change. Is there any tweek to make to Pure Message to stop this? Thanks

I have only used mssql, and would use a query like this:- select data1, data2,* from table1 which would show all data1 and data2 then all the rest of the table1 What should i use instead of the *? Also is there any source of different syntax than mssql, since as you see this is a basic...

Hi I am using Crystal XI, and can group sort on:- Sum ({HIST__Q4Contract_Poo.REJTRejects}, {IASE__I4Contract_Hea.ACCTCustomer_account}) and also on this. Sum ({HIST__Q4Contract_Poo.DELVDelivered_Qty}, {IASE__I4Contract_Hea.ACCTCustomer_account}) I am interested in sorting on this:- Sum...

I am trying to create a parameter, that will allow a schedule report of work done in a set week. On Monday, I want to know the work done from Last Sunday to next Saturday. On Tuesday. I want to know the work done from last Sunday to next Saturday. and so forth for the rest of the week. Thanks

I am trying to set up windows mobile and have a problem with the SSL. My computer domain is called workgroups.co.uk and the web address is mycompany.co.uk The SSL is registered as workgroups and hence there is an error as the windows mobile comes in via the web domain and rejects. Is there ny...

My exchange server is within a vpn. I want a treo 750 to collect emails without going through the vpn, what ports need to be opened plus can I use this to send emails

I am using MSQuery in Excel and want a criteria where the field is less than current date. i cannot find the sql criteria CurrentDate does not work Thanks

I have the follwoing data:- Details Sep06 4 Details Oct06 6 Details Nov)6 0 Group 0 (being the final data not a total) The numbers are the stock level for a stock line. What I want to do is supress the line at group level if the final stock figure is zero, how do I do...

I can easily email a pdf, however as i know the email address of each pdf and want to somehow link the file name of the pdf to the known email address and automatically email the pdf. Is this possible? Thanks

Hi I have a report where each month I have to re set up with a formala to look at data to see if it is in the range of the current month. i then have a history going back several years. I thought if I set a date I can make the formula take off 30 days 60 days etc. i would like the formaula...

Hi I am trying to link two databases one in MS SLQ and one in pervasive. I have found where I have a common key say:- A100 A200 in both databases, however one is a string of 20 and the other of 8. Is there anyway to return the data from both ie at the most basic have a report:- SQL...

Hi i have installed Crystal 8.5 on a 2003 windows Terminal Server. When exporting a report as the administrator it can see pdf as an option but users cannot. How goes Crystal know to use pdf etc and allow users to use a pdf output. Thanks