Search results for query: *

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

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

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

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

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

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

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

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

Thanks

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??

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

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

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

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}...

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

Actually, I have 80 employees. I want all 80 on the report but only want to apply a $10 bonus to the top 5 with the highest count of xx in the footer...does that make sense?? thanks

I am looking for a way to single out a TopN of records within a group and apply a formula to them. I have one group and a sum of records for each employee in the group footer I need to apply a bonus of 'XX' to the top 5 employees thanks

I need a pointer on correctly summing up a count within a group footer I have one group on the report (szAgentCode) Here is the formula (cntTRASurveys)for the count: IIf({tblRaw.lcdate}=DateAdd(&quot;d&quot;,2,{?ReportStart}) AND {tblRaw.termcd}='SA',1,0) When I insert a subtotal in the group...

Here is the SQL Query--The only parameters it takes is ReportStart and ReportStop It is a left join where tblCCCompany.szCompany=tblRaw.Account ****************************************************** SELECT tblCCCompany.szCompany, tblCCCompany.lGroupID, tblRaw.account, tblRaw.termcd...

I am having a time with a join and could use some help. First the db is MSSQL 7.0. Two tables, Customer, Customer Data. I have the customer table left joined to the customer data table by account. In my report I have one group which is customer.account I am displaying all the customers along...