Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kss444

    Fast report slow viewer

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

    Fast report slow viewer

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

    Running a crystal report

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

    Running a crystal report

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

    Summing

    I figured it out. Ordinary Programmer
  6. kss444

    Summing

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

    Summing

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

    another regex needed

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

    another regex needed

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

    another regex needed

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

    another regex needed

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

    another regex needed

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

    another regex needed

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

    RegEx help

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

    RegEx help

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

    RegEx help

    I have this pattern objRegExp.Pattern = "[^<>/?&{};#-_]+" I need help to add [A-Za-z] to it. Everything I've tried so far has not worked. Thanks, KS Ordinary Programmer
  17. kss444

    Rounding or truncation issue

    sorry, but these are end users who are putting these excel files together, so sometimes you will see numbers like 134.914 and they will upload this another developer did the *100)/100 to just get 2 decimal places. Ordinary Programmer
  18. kss444

    Rounding or truncation issue

    Thanks but this did not work. Here is what I've tried. Dim payment payment = 134.42 '134.425 Dim payment2 payment2 = 134.42 '134.425 Dim payment3 payment3 = 134.42 '134.425 Dim payment4 payment4 = "134.42" '134.425 Dim payment5 dim payment6 payment6 = 134.421 dim payment7 payment7 =...
  19. kss444

    Rounding or truncation issue

    here is a sample page of my issue. dim payment payment = 134.42 payment = int(payment * 100)/100 Response.Write("<BR>" & payment) 'The result is 134.41?? dim payment payment = 134.421 payment = int(payment * 100)/100 'result is 134.42 The first way is what I have and need to use, also people...
  20. kss444

    I have 2 databases my web app connects two, do I need to combine them

    in your C:\Windows\Microsoft.NET\Framework\v2.0.50727 folder should be some sql scripts that you can run on your DB to get all the membership tables. Ordinary Programmer

Part and Inventory Search

Back
Top