Recent content by rewob65

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

Ian You have saved me weeks of work. I changed the name via the alias then update it through the database connection and it works. The company I pay £2,000 for support was not able to help except virually saying rewrite the report. Thank you Ian

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

Not sure if this is closed, but I have the same problem, and the workround will take me hours, so I was wondering if there is a solution. If I can downgrade the report to v10 and still run it on CRS may be another thought for a workround, but not an ideal solution. By the way if you use...

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

Version 9.00.066.000 The View is :- CREATE VIEW ME AS SELECT "SUND__B6Price_Table"."PTABPrice_Table_No", "SUND__B6Price_Table"."DESCDescription" FROM "SUND__B6Price_Table" "SUND__B6Price_Table" ORDER BY "SUND__B6Price_Table"."PTABPrice_Table_No and the error shows first a load of text...

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

The work here is absolutely brilliant, by all three of you. I am just posting here so that I can pick it up tomorrow as I will work on ther average, as I think I am trying to do something similar to you Ed. It this is the wrong etiquete please tell me but don't shoot me!

I am using pervasive 9, but I think it appears I do not have the skills to do this. Broadly I am sorting by a second pass record and there appears to be no easy way around it. I will have to export to Excel and sort from there which does not take long. I had been aiming to get crystal...