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 Chriss Miller 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
  • Content: Threads
  • 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

    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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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}...
  9. 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...
  10. mrichey

    Find Uppercase in Excel

    Hello, I'm not a "natural" coder as most of you seem to be. I need to be able to determine if the first 3 charachers of each cell below are uppercase. Is there code that would do this for me? The list is actually quite long, this is a small subset. Thank you!!! TREAS02-FL-JAX Internet...
  11. mrichey

    Excel Macro for Copy and Paste

    I need to create a macro that will do the following (using relative referencing) 1) search for specific text string (<<) 2) copy the entire contents of that cell 3) move to the cell below and paste into a comment 4) search for next occurence of the string 5) etc. When I try it, of course it...
  12. mrichey

    Grid Lines Missing

    Crystal Reports Version 9.0 Database: Oracle I have a line chart across 3 months of data, grouped by date and time in 15 minute intervals. When I format the grid lines to show major gridlines by GROUP, there are no gridlines showing for the last few weeks of the period. Any thoughts...
  13. mrichey

    Published Reports Lost

    I'm opening another thread on this issue in relation to an issue I posted last week, as the problem has worsened and the circumstances have changed. Crystal Enterprise 9.0 Issue: Published reports disappearing from the CMC report folders. Initially thought it may be due to the fact that we...
  14. mrichey

    Lost Reports in CMC

    Crystal Enterprise 9.0 We're having an issue where reports are disappearing from their folders within the Cyrstal Management Console. Seems the common thread is that they're always reports that we've recently altered at the File Store instance level. This saves us a lot of time in that we...
  15. mrichey

    embedded object removal

    Stupid question I fear. I moved a field over the top of a text object so that it becamse one text object, with the field embedded. I can see that this would sometimes be useful, but how do I go about un-doing it? Separating the text label from the object? Thank you!
  16. mrichey

    Access Audit Trail

    I realized this question will be vague, but is how would you got about having Access auto-fill a field that show the name of the last user to update the record? Thank you.
  17. mrichey

    Blackberry -- Receiving Enterprise Attachments

    Has anyone ever had any luck receiving a Crystal Enterprise attachment on a Blackberry device? I can open most attachments, but if it comes from CE, whether it be a doc, xls, pdf, rtf, etc, it doesn't seem to recognize the format. Thanks!
  18. mrichey

    Quarter Hour Grouping on DateTime Field

    I need to adapt the formula shown below (provided by sysvampire) to break the time into 15 minute (quarter-hour) intervals. I know it should be easy given the formula provided, but what can I say? Thanks! Here's a formula for 1/2 hours for existing data...
  19. mrichey

    Pasting Into Text Box

    I have a report where I need to add some verbage. I created a text object and was hoping to be able to cut and paste from Word, into that text object. When I attempt that I get : --------------------------------------------------------- Version:1.0 StartHTML:0000000254 EndHTML:0000003191...
  20. mrichey

    Select Statement - Average of Max

    I'm using the statement below to pull out the MAX CPU reading fom the hourly tests for each day in August. Is there any way to alter the statement to see the average of the MAX's for each server in August? I'm using crystal reports and I'm having to insert an AVG summary on the...

Part and Inventory Search

Back
Top