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 dencom 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: honorbum
  • Content: Threads
  • Order by date
  1. honorbum

    Building a chart based on a formula

    I have a field which is basically a percentage formula off of two other running total fields - ({rtfield1}/{rtfield2})*100. I want to build a line chart off the percentage field. The report has two grouping levels as well - one, the customer and two, the month. All three fields reside in the...
  2. honorbum

    Referring to a Group Running Total for a Line Chart

    I have a field which is basically a percentage formula off of two other running total fields - ({rtfield1}/{rtfield2})*100. I want to build a line chart off the percentage field. The report has two grouping levels as well - one, the customer and two, the month. All three fields reside in the...
  3. honorbum

    Query order in Crystal

    Quick question - does anyone know what the processing order is for the report criteria formulas? Is is Top-Down or Bottom-Up?
  4. honorbum

    Querying an Excel file within the Server

    I have a report which needs to query an excel file as well as a database to run. Does anyone know how/where I would put the excel file on the server (Crystal Server 2008) in order to run the report from the CMC? I have tried adding it to the same folder the report but I know I need to indicate...
  5. honorbum

    Idle Sessions on Server using Crystal Server 2008

    Can someone tell me where the setting is to terminate idle login sessions in the CMC? Using 2008 server on Windows. If someone logs in and then does not log out but rather 'x's" out of the window, the session remains connected and occupies a license spot. Is there somewhere to set a terminate...
  6. honorbum

    Crystal Server 2008 - Deleting a user

    In the CMC, I've deleted a user (no longer shows in user list) however I can still login using those credentials and if I try to recreate that user, it says the user object already exists under the same name. Does anyone know how to truly delete a user in the server?
  7. honorbum

    Data comes into Report with "_b" for a space

    We are in the middle of setting up Crystal Reports 2008 and using it to pull data from a ticketing database for export into excel. When we run the report the blank spaces between words appear as an "underscore b" (_b). We're using Mysql 5.0 ODBC connection. Can someone tell me what is causing...
  8. honorbum

    Outlook - email templates

    Is there a way to design templates in Outlook 2007? We send out literally hundreds of emails a week which are basically the same with some small changes in information. If we could work off of templates, this could turn into a huge time savings for us.
  9. honorbum

    Formula for pulling multiple values from one cell

    I have a dilemma. I have a cell containing multiple values separated by commas, for instance 12345,m349t,987v4 I need to pull these values out and list them separately. Any suggestions?
  10. honorbum

    Most Frequent Text Value in Excel

    I am trying to figure out how to look at a column of City names and in a cell, display the City name which occurs most often. Only formula I can find is "Mode" which will only give the most frequent "number" that occurs and not text.
  11. honorbum

    Hyperlinking via a picture in flash

    We are just learning Flash MX (not much experience with any flash). We are trying to use a pic to hyperlink to another www.com site but the rollover layer prevents linking more than one pic off one page. (Basically what is happening is we are adding the hyperlink to the rollover layer and not...
  12. honorbum

    Linking a Visio drawing/shapes to Access database?

    I'm trying to link Visio shapes to an Access database so a process flowchart will be drawn based on the database fields. Is this possible?
  13. honorbum

    Setting Date Parameter in an Excel Database Query

    I'm pulling data from an Oracle server (Remedy) via an Excel Database Query. I'm trying to set a criteria paramenter based on a date field in Remedy so the person accessing the report can be prompted to enter a "Start Date" and "End Date" of the date range of data. So far everything I've...
  14. honorbum

    Pulling report for next 24 hours

    New to Crystal - need a formula for pulling reports based on a date/time field in Remedy for the next 24 hours or from 6am to 6am next day. Please help!

Part and Inventory Search

Back
Top