Recent content by pork1977

To complete this thread, I found there was no easy way to do what I wanted, I came up with the below script though so thought I'd post here to help others. I'm sure there's lots of ugly things in this script which more experienced guys will notice, like duplication of parts which might not...

Edited a section: (see below) so "\\servername\releases\example folder" was something like "ftp://username:password@ftp.example.com/example folder"

Hi there, I'm wondering if this is possible... I'm hoping to use this as part of a custom action within an InstallShield solution if so. So at the moment I have the following vbscript which basically does 2 things for me... The first part looks at a folder path on the network and then gets the...

Not to worry, managed to do what I wanted to in the end with a little bit more research. Ended up like this: (put up incase anyone was interested, and for my own reference! although this is a cut down version of what I ended up) strPSExec = "C:\psexec.exe" strMSI = "C:\MyMSI.msi" strAdminUser =...

Hi, Wondered if somebody could kindly fix this up for me? All I'm tryinng to do is push out a MSI using the PsExec tool remotley to other servers on the network. I currently have it working as I need to in a batch file but need to convert this to a vbscript and my knowledge with vbscript isn't...

OK, it does work correctly! I was just mis counting some numbers somewhere. Thanks alot for the help, the code will be useful for similiar reports. Regards, Paul

+20 gives me nothing! but +1 gives me the correct groups. Numbers don't tally up with what I expected though. I'll have a look through the CR help section to see if I can get to the bottom of it, thank you for your help. Paul

OK I will do that, would you mind explaining the formula and how it works?

OK, click on the link below to see a screenshot of what I done so far. http://pork.andym.co.uk/ This is showing any call that has got the "Forwarded to Group HARMONI ITS" in it. It show's way more in the Harmoni ITS group obviously because that's where you'd expect to see them but it also...

OK, so I tried the first formula you gave and it seems to come back with thousands of records, infact if I let it go Crystal normally crashes out because so many! I have put a sum on it but not sure why it's happening. The description field isn't a field that can be browsed through Crystal...

Thanks for your comment lbass, the description field is chosen from a list so you can't put what you want as this is the groups you can assign calls to so they always stay the same. I'll try what you say tomorrow when back in the office and see if it works but previously I had tried the...

That's great, I wasn't expecting that! I'll try it when I get back in the office tomorrow and will let you know the outcome Regards, Paul

Hi all, I have a problem with a crosstab report, the below show's an example of how it should look. Dec 06 Jan 07 ADASTRA 7 4 DEVELOPMENT 1 4 HELPDESK 22 34 IT SUPPORT 3 1 LOCAL IT 1 0 The numbers relate to the number of...

Well, just thought I'd let you know that I've worked around the problem by just deciding to do... DateDiff ("s", {Incident.Open Date & Time}, {Incident.Close Date & Time}) Unfortunatly it keeps the stoppage times in the results by doing it this way but is ok for the time being. It seems to be...

Silly me, just thought, the format of the @diff formula will need to be in 'Number' format as couldn't have the difference being in a date format! Still working on it...