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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by elead

  1. elead

    CodeMod Help

    I need help to modify the code below so that after 5 minutes of refreshing itself using this logic it forwards to another web page--Thanks <script> <!-- //enter refresh time in "minutes:seconds" Minutes should range from 0 to inifinity. Seconds should range from 0 to 59 var limit="0:10" if...
  2. elead

    Page Refresher

    Don't know JS but I am looking for a snippet to accomplish the following task: I have two web pages. The first page I want to load, let the viewer see it for 30 seconds then be redirected to the second page. Once the second page is diplayed It needs to refresh itself (postback) every 20 seconds...
  3. elead

    Cannot view report via web??

    We are running Microsoft Windows 2000 Server with Crystal 8.0 installed on it. The web and page server services are running, however when trying to view a report via the web the browser tries to download the report instead of viewing it---any ideas?? thanks
  4. elead

    Parameter problem

    I am receiving an error message from crystal saying &quot;a string is required here when I try to run my report&quot; Datebase is MSSQL any ideas?? thanks Here is the code {results.accountno} = {?AccountNo} and {results.termcd} = &quot;SA&quot; and {results.LCDATE} in {?ReportStart} to...
  5. elead

    Date Parameter Error

    I am receiving an error message from crystal saying &quot;a string is required here when I try to run my report&quot; Datebase is MSSQL any ideas?? thanks Here is the code {results.accountno} = {?AccountNo} and {results.termcd} = &quot;SA&quot; and {results.LCDATE} in {?ReportStart} to...
  6. elead

    Parameter problem

    I am sending in 2 parameters to a report that should be picked up as date but the report is squawking for a string in lieu of date, is there a setting somewhere in CR that I missed somewhere The dbfield type is MSSQL Datetime The parameters are {?DateStart}--Date {?DateEnd}--Date thanks
  7. elead

    Conditional Format BGColor in Formula

    I need a pointer. I have the following formula planted in a group footer. IIf({tblAutoRaw.dtAction}={?ReportStart}+1 AND {tblAutoRaw.szTermCode} <> &quot;TR&quot;,{tblAutoRaw.nCount},0) What I want to do is make the background lightgrey if it falls on a Saturday or Sunday? Thanks
  8. elead

    Prints double quantity selected??

    I have a few reports that when the user selects to print more than 1 copy it prints like: If 2 copies selected it prints 4, If 4 Then 8 etc. Is there a patch or setting for this? We're running version 8 Thanks
  9. elead

    Group Record Suppress

    I have 2 groups on the report Date, ID I want to suppress all except the minimum value for the record If {tblCallTrak.LCTime} > Minimum({tblCallTrak.LCTime}) Then True This supresses all the records except the minimum, how to I apply this criteria to the records in each group??
  10. elead

    Hyperlink Help

    I need some help with a hyperlink field I have a field (szFilePath) that holds a relative path to a file on the harddrive . The field type is hyperlink I want to open the file in the hyperlink from a form in access The value showing on the form from the database is like...
  11. elead

    Stored Procedure Error--Help

    I moved a report from a server running CR 8.5 to a server running CR 8.0 The page that calls the report uses the following for the Stored Proc and now it's erroring out..my guess is the rdc .dll is a bit different...can anyone tell me what the correct syntax for version 8.0 would be as I am in...
  12. elead

    Stored Procedure Prompts

    I have created a simple report based on a MSSQL stored procedure. When I feed it the two parameters it needs via the web site it prompts for the dbLogin then the two parameters from a crystal interface? I am connecting to the db Via System DSN And feeding the the paramters like this...
  13. elead

    Calculate Report Value

    Below is a calculated field formula from a crystal report. I need to accomplish the same thin in Access. I was wondering if someone could show how it would be constructed in an MSAccess report calculation--Thanks If {tblAgentTotals.Total_HFPCT} >= 0.275 And {tblAgentTotals.Total_HFPCT}...
  14. elead

    Apply Formula to TopN in group

    dgillz, thanks for all the help thus far but I am getting nowhere. How about if I save the report with the data and send it to you that way you can see what I'm doing wrong? thanks

Part and Inventory Search

Back
Top