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 TouchToneTommy 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. snazzyCrunch

    Creative CGI Minds Needed!!

    Hi all, Here's my dilemna: We have a performance agent tool on our production servers. The agent is called Openview Performance Agent by HP. We know how to extract the data from the command line locally on each server. We would like to create a webpage on a central webserver that allows user...
  2. snazzyCrunch

    syslogd question

    Does anyone know how to turn the logging on for the facility and priority of the syslogd? The current style of my syslog output file "/var/log/messages" is: Apr 4 17:08:46 mrtg_server httpd: httpd shutdown succeeded I would like the priority to display in the syslog as well...
  3. snazzyCrunch

    Date Period 'Yesterday' question

    I am using CR8.5. I have a report automatically running every night b/n 02:00 and 02:30 AM. I would like the report to only report on data with Yesterday's timestamp. I tried the formula: not({myField.DATETIME} in AllDaysToYesterday) Also, data does not get written to the db until around...
  4. snazzyCrunch

    Question with a cummulative formula problem.

    I am using CR8.5. I have an ODBC connection to a performance DB that houses info in the following format.... DATETIME | SERVERNAME | TOTAL_ANONYMOUS_USERS The column TOTAL_ANONYMOUS_USERS is a cummulative field. Thus, it is always a GRAND_TOTAL of how many anonymous users have ever been on...
  5. snazzyCrunch

    Using Crystal Arrays/Split Function

    Hi, i'm using CR8.5. I have a formula named @custName. the fields in the database sometimes contain extra characters I don't want to display. i'm trying to use the split function to split the field with a delimiter of " ", and take the first field. Here's my code (using Crystal...
  6. snazzyCrunch

    SQL statement based off of Parameter

    I have a fairly simple question about setting the SQL select statement based of a parameter value. These are my two cases: 1. {?REQCustomer} = "ALL" then I would like to execute the follwing SQL stmt... Select * from DB where fieldName like '%string%'[\code] 2. {?REQCustomer} =...
  7. snazzyCrunch

    ASP page automatic export type for PDF?

    Does anyone know what the ExportType is for the PDF format? I have an ASP setup which allows the user to pick which format they want the report automatically exported to. I found these on the Crystal Decisions Knowledge Base: Char Separated Values, 7 Comma Separated Values, 5 Crystal Report...
  8. snazzyCrunch

    Problem Exporting report to Excel from an ASP page...

    I have a report that is called via an ASP page. The report excepts one parameter field, which is a DateTime range value. Here is the code I use: set session("ParamCollection") = Session("oRpt").Parameterfields set Param1 = session("ParamCollection").Item(1)...
  9. snazzyCrunch

    Horizontal Bar Graph Question

    I have a 3-D horizontal bar graph that graphs a percentage (0 to 100%). I would like to create a vertical red line at 98% (or mathematically correct, at x=98). Thus, the reader could see very easily if the bars were above or below 98%. Thanks in advance!!
  10. snazzyCrunch

    SmartViewerHTMLPage.asp Question??

    I am building an ASP site running on IIS 5.0. Through this site folks are able to select various form fields and run a report (Crystal Enterprise, report was created in CR8.5). One of the options for the end-user is to pick the Viewer they would like: (I did this b/c some folks don't like using...
  11. snazzyCrunch

    PARAMETER FIELD VALUE IS NOT RANGE

    I received this message when trying to pass a date range value to a report from an ASP page. Here's the snippet of code.... set session("ParamCollection") = Session ("oRpt").Parameterfields set Param1 = session("ParamCollection").Item(1) ParamValue =...
  12. snazzyCrunch

    <b>HELP!!! Parameter field value is not range.</b>

    I received this message when trying to pass a date range value to a report from an ASP page. Here's the snippet of code.... set session("ParamCollection") = Session ("oRpt").Parameterfields set Param1 =...
  13. snazzyCrunch

    How to customize color of bars...

    Is there anyway to customize what the color of a bar will be? For ex: If Value > 90, then Green else if (Value = 90 ) then Yellow, else (Red) Has anyone tried this before? I'm using Crystal 8.5. If anyone has any ideas that this will be greatly appreciated, thanks!
  14. snazzyCrunch

    Hi, I have setup a Win2k server

    Hi, I have setup a Win2k server box running IIS 5.0 with Crystal 8.5 and Enterprise 8.0. I can easily link to these reports thru a normal &quot;<a href....>&quot; HTML link. However, putting my db UID and PASSWORD in the URL is not an option. The users that are supposed to have the password...

Part and Inventory Search

Back
Top