Recent content by kss444

No, I modify the report in Crystal 2008, then move the file to a network share that has all of our reports that Avanits uses then a user of Avantis will run the report every morning. There are about 5 different people that run the report ever morning. The report use to run in 2 minutes, but...

Hello All, I am using crystal 2008. I have spent the last few day's trying to speed up my report in the viewer. I have sped the report up greatly when working in Crystal's IDE. But when I add the report to our 3rd party application it's like the previewer is slow to show the report. I have...

The 3rd party app is Avantis. Yes the report does have subreports and grouping but it's not optimized to use any printer. the script runs fast in ssms, and the report takes about 2 mintues sometimes less, but when using the viewer from Avantis the report takes 5 minutes, sometime with in a...

Hello, we are using crystal 8. If I install just the runtime files on someones pc will they be able to double click on a report and run it? We have a situation where we have a 3rd party application that currently will load the report, but it takes 5-7 minutes, and I can run the report in 2...

I figured it out. Ordinary Programmer

My detail results are in a table, but i've also noticed that the cells are not keeping my format. My amounts fields are resetting to text. Not sure why. Ordinary Programmer

I am trying to do a simple sum of an amount column, but I can't seem to get it. In my query the fully qualified field name is mc.INVTAX.TaxAmount_amt and I alias this with "as 'Tax Amount' In ssrs I have a textbox that I want to create an expresion for the SUM. And I have...

Sorry PHV, but I have tried all those formats FormatNumber, CDBL, int, CCur but it rounds down by 1 penny. But I think this will work. Dim objRegExp, outputStr, myMatches Set objRegExp = New Regexp 'LogEvent "val= " & strtoCur, false, false, false objRegExp.IgnoreCase = True...

Also this is vbscript in a classic asp page. Ordinary Programmer

strCurFormat = Fix(100*CDbl(strtoCur))/100 does not work it takes my value 134.42 and converts it to 134.41. That value is coming from an excel file the cell is formated as a number, but the format can be anything. These are users who are just doing cut and paste and importing files, so we have...

One more thing if someone can help. I am using this pattern ^[-+]?\d*(\.\d{1,2})? now I need to account for a ,. ex. 3,000 Thanks again everyone. Ordinary Programmer

I ended up using instead. objRegExp.Pattern = "^[-+]?\d+(\.\d{2})?" Set myMatches = objRegExp.Execute(strtoCur) strCurFormat = myMatches.Item(0) Ordinary Programmer

Hello all, I am needing a regex script/pattern to format a number to 2 decimal places so: 123.44 will be 123.44 123.445 will be 123.44 I do not want rounding of any type. Thanks, KS Ordinary Programmer

Got it. I think this will work just fine. objRegExp.Pattern = "[^0-9]+" Beating my head over something simple :) Ordinary Programmer

Also the special char above and any alphas can be anywhere in the string. 568U94# I am wanting to take my string and remove all alphas and special characters. In the above pattern I have an ^ not sure if I need this. Thanks again. Ordinary Programmer