Recent content by Jhankins

Thanks for all your help.. and yes it worked... Cheers to you Vongrunt

I am just trying to see if the current sales value has moved up a level (levels are at $1000 intervals) .. say. data example id Name Current Sales Max Past Sales 1 bill $2333 $2400 2 Jan $3400 $2400 3 Fred $11250 $10123 I would want to return the 2 & 3...

I have two columns and need to compare if the new sales value has increased to the next level.. example will explain better: Current Value Max Value Achieved 2400 2600 since $2K has been hit dnt count 3210 2500 Count 10500 11200 Count I...

I have worked it out.. If anyone requires the answer please let me know.

Is there anyway of copying a worksheet in a activex script ? I have been trying for a while but with no luck, I cant seem to find any help on the subject, if anyone has done it could you let me know.' Cheers

Hello, Each month I have a query to generate monthly data. I want to be able to export in to a new sheet each month i.e Sept - 2004 for month of Sept. I want to do this via DTS so there is no manual process. I can creat the new sheet in the workbook but how do I get the data to copy on this...

I have written a Activex DTS package, but times out with 2 different errors. Sometimes I get the query timeout after about 30 sec's else it timesout after 5 minutes. Even if I execute it on the server I get the same problem. I have tried using the connection string time out properties but still...

I am using CE9 and have a report that has 180 items in the parameters pick list. When viewing via the Intranet frontend it only 52 shows up. But when i go into the mangement interface I can see all of them .. Anyone else had this prob. Cheers,

How do you run a method from JScript I can do it when I put a button on the webpage but how do you just run a method without having to use a button Thanks Works below with a button but trying to run a method call RefreshData <SCRIPT language="JScript"> function starttimer() {...

How do you run a method from JScript I can do it when I put a button on the webpage but how do you just run a method without having to use a button Thanks Works below with a button but trying to run a method call RefreshData <SCRIPT language="JScript"> function starttimer() {...

I wish to automate a report to export to HTML. In the list of available options (format) I cannot see HTML, Is it possible to do?? Cheers,

Is there anyway of turning off the status bar when using URL commands? So you just display the report and nothing else. http://testserver/viewrpt.cwr?ID=14398&apsuser=administrator&apspassword=&apsauthtype=secEnterprise

Hello, I have a sheet like x y z 1 2 2 2 3 3 I wish to export columns y and z (i.e range) to a new excel spreadsheet with the user able to pick a filename and location via a sheet button function any idea's

they are week 1 and week 2 i.e 15 - 21 as week 1 and 22 - 28 as week 2

I have the following data: Client Details id Name Phone 1 Test Name 1234567 Transaction Data id Date payment 1 15/03/2004 $10 1 21/03/2004 $15 1 22/03/2004 $5 1 28/03/2004 $20 I wish the data to come out...