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: *

  1. snazzyCrunch

    ASP page automatic export type for PDF?

    What's was the error before the '5 Concurrent Limit' error?
  2. snazzyCrunch

    Local 'HP ITO Account' password change

    Is this a Windows node?
  3. 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...
  4. 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...
  5. 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...
  6. snazzyCrunch

    <b>Critical report access problem</b>

    Did your DB just become password protected?
  7. 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...
  8. snazzyCrunch

    Using Crystal Arrays/Split Function

    Thanks synapsevampire and JoeCrystal, Quick question to synapsevampire. Just so I understand this fully, does the function inStr return the first index of the occuring "string". left(trim({Customer Name}),instr(trim({Customer Name})," ")) So in the above line you are...
  9. 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...
  10. snazzyCrunch

    ASP page automatic export type for PDF?

    Thanks, Oliver. Although I posted this awhile and had to use a dirty workaround this will be very helpful in the future. You say you found this from "their ASP sample code". Do you mind looking thru the original posting and seeing if any other export types are not listed. It is...
  11. snazzyCrunch

    SQL statement based off of Parameter

    Big thanks SMPhillips!! it's working like a charm! :)
  12. 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} =...
  13. snazzyCrunch

    Bar Chart Colors based on group or field?

    There is a workaround that I use based off of numbers. Say I want to use a bar graph to represent my class of 30 students and their respective averages. I want all grades 90 and above to be represented by a green bar and all other represented by a red bar. I create two formula fields: 1...
  14. snazzyCrunch

    ASP page automatic export type for PDF?

    The funny thing is I can export using the ActiveX Viewer OR Java Viewer. However, I am setting up an ASP page which allows the user to select the export format and then it is automatically exported for them. Thanks.
  15. snazzyCrunch

    How do I pass database logon information?

    This works great for me. I use this within an asp page. '================================================================== ' WORKING WITH SETLOGONINFO ' ' The datasource here is called "Automation". It is a System ' Datasource, and points to the "pubs" database, which is...
  16. 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...
  17. 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)...
  18. snazzyCrunch

    Crystal Reports 8.5

    If you are running Crystal Enterprise already, and your web server is up as well, then just place your .rpt file somewhere in your web root directory. Next point your browser like so: http://www.domainname.com/directory/folder/whatever/file.rpt This will kick off Crystal Report Viewer and...
  19. 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!!

Part and Inventory Search

Back
Top