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!

  • Congratulations SkipVought 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: *

  • Users: mrichey
  • Order by date
  1. mrichey

    Job Child Process Priority

    Is there any way to specify that a job child process is to take priority once it enters the queue. We have a report that has to run at at certain time due to database loads, it's scheduled to run as soon as those loads are completed, but it gets stuck in pending and is late getting out. Any...
  2. mrichey

    Job child process priority

    oops, don't know what I was thinking. Thanks for pointing that out. I have so many Crystal categories, I have to be careful. mark
  3. mrichey

    Job child process priority

    Is there any way to specify that a job child process is to take priority once it enters the queue. We have a report that has to run at at certain time due to database loads, it's scheduled to run as soon as those loads are completed, but it gets stuck in pending and is late getting out. Any...
  4. mrichey

    Launchpad Administrative Samples Not Found

    Thanks for the reply, but when I try that I get a "Page Not Found" error. I tried using both the server name and the actual IP address.
  5. mrichey

    Launchpad Administrative Samples Not Found

    I'm using CE version 9.0 and we're having a hard time finding the launchpad that includes the samples and documentation that are seen on the left side of the version 8 launchpad. When we go to launchpad, it simple opens up the login screen, not the screen where you can choose between CMC...
  6. mrichey

    Value based on text

    Hi, using Access 2000 and need to create a formula that calculates a value based on the text input. Maybe in a query, or in the table itself? Here's an example: Area Measurement Phase Value Network Device Up/Down Deployed 2.5 Network SNMP Alerts...
  7. mrichey

    Parse Specific Data From Memo Field/Crystal 9.0

    Hi Gramm, thanks for the reply. I got that far but, not being a programmer, can't determine how to get the subsequent occurences of Logical Disk as well.
  8. mrichey

    Parse Specific Data From Memo Field/Crystal 9.0

    Hi, using Crystal Version 9.0 against a P4 database. The data below is in a memo field. I need help creating a formula to parse only lines with "LogicalDisk" in the line. I need all data on the line all the way to the 15m. Example, for below would want to see this: e w2k_LogicalDisk...
  9. mrichey

    Parsing Memo Field/CR 9

    Thanks synapsevampire!! Apologies for not getting my requirements to you at the outset. I'll be more clear in future posts. Thanks for your patience and help. It has made a huge difference. Sincerely, MR
  10. mrichey

    Parsing Memo Field/CR 9

    Typo, my formula was brackets, but put parantheses in the email. My bad. Anyway, The new split formula with the chr(13) added gets this: {{["component", "open", "PROD REVIEW", {}, {}, "CHASON GRANT"]}, {["downtime start/downtime end", "closed", "PROD REVIEW", {}, {}, "CHASON GRANT"]}...
  11. mrichey

    Parsing Memo Field/CR 9

    Sysvampire, hope I'm not pushing my luck with you. One last question. Using the formula you provided me, this is the total output for one of the records: rca open PROD REVIEW 06/29/05 15:38 DEAN SKINNER Shannon - SA is tracking this ticket for completion of RCA cause type and...
  12. mrichey

    Parsing Memo Field/CR 9

    Sheez, like the PGA adverttisement says --- you guys are good! That works beautifully. It's like magic. Now how do output the other subsequent sections? You're right on with what I'm trying to do. I'll use the chr(13) later to enter the hard returns. We were just talking about what a...
  13. mrichey

    Parsing Memo Field/CR 9

    Help! At wits end trying to parse this without using code. I've tried LEFT, INSTR, INSTRREV, etc. but am getting nowwhere. Using Crystal 9 Need to break out all data between {[ and ]} and then break out the all between the next {[ and ]} and so on. In the following example that would return...
  14. mrichey

    Chart Data Label

    Thanks LB, That is an idea. Since I don't have to run this particularl report but once monthly that may not be too bad. Thanks!
  15. mrichey

    Chart Data Label

    Crystal Version 9.0 Is there any way to see only the "total" on a stacked bar chart? There are options for cumalative, absolute, and show total, but doens't appear to be any way to see the total only. I tried selecting one of the subtotals and formatting it to be transparent, but that changes...
  16. mrichey

    Shared Variable Problem

    Hi, I'm running Crytal Reports Ver 9 and am trying to pass a value from a subreport to the main report. I've created my formulas as shown: Main Report WhilePrintingRecords; Shared NumberVar Capacity SubReport WhilePrintingRecords; Shared NumberVar Capacity := Sum ({drivearray.array_capacity}...
  17. mrichey

    Macro to name a range

    Skip, when I paste this into a macro, I get a runtime error (13) Type Mismatch error on the "1RowPrev - r1 -1" line. Any suggestions! Thanks. Sub test() ' ' test Macro ' Macro recorded 4/24/2005 by Mark Richey ' Dim r1 As Range, r2 As Range, lRowPrev As Long Set r1 =...
  18. mrichey

    Macro to name a range

    Hi Skip, thanks for responding. The range will be dynamic. The process would be something like: 1. Find Collection 2. Using relative reference, move to cell above, copy the data (should always be the server name) 3. Select all data from the server name field (where cursor should now be) to the...
  19. mrichey

    Macro to name a range

    Using the example below, how can I create a macro to select everything from the server name in A1 (BOMDirector04) to B12(cell to right of "Done")and name the range selection to match the server name from A1? Thanks much for any suggestions!! A B BOMDirector04 Collection Monitor...
  20. mrichey

    Find Uppercase in Excel

    Thanks Ken! You're exactly right. I didn't need code. Apologies for posting to the wrong board, but much thanks for recognizing my need! Mark

Part and Inventory Search

Back
Top