Recent content by roboninja

The exact error is "Undefined function 'REPLACE' in expression." Here's the SQL statement: UPDATE Ind_Construction_Costs SET PriceIndConstrCost1 = REPLACE(PriceIndConstrCost1, ".5-", ".50-")

Hmmm, I am using Access 2000, but when I put REPLACE in a SQL statement, it gives me an undefined procedure error. I might just end up doing it in SQL Server.

I am used to using SQL Server, and the REPLACE function to replace characters in a string. What is an equivalent function in Access? I can't seem to find one. Thanks.

CR 8.5 has a DHTML viewer option, so users don't acutally use a viewer control, but see a DHTML page. The CR Page Server handles all of the conversion.

Thanks. I think I found the problem. Even though the DSN was pointing directly to a specific database, it was prefixing the database name to the table names. The database name was different at the client site, so I removed the database names from the table locations, and it seems to work on a...

Everything seems to be the same in both databases. I tried explicitly setting the connection property of the Crystal Report OCX, but that did not solve the problem. I'm totally out of ideas.

Everything worls fine on a client when SQL Server 7.0 is still the back end. I'm pretty sure it is the transition from 7.0 to 6.5. I haven't been able to find any info on Crystal's or MS's sites.

I developed some reports using a CR8.0/SQL Server 7.0 platform for viewing in a VB 6 project. The reports work fine on the development machine, but the client is using SQL Server 6.5 When a user clicks the menu option (or button) to view a report, nothing happens; no error, but no report...

I have an ASP page with a list of cutomers. I have placed a hyperlink on the Customer ID field of the table to call the Crystal Report about that customer. My hyperlink is like this: <a href=&quot;cust.rpt?init=actx&PROMPT0=<%=rs(&quot;CustID&quot;)%>&quot;> CustID is the value for the...

That is for one ID, and the Section Names are not dynamic (there are only 4 possibilities, set via a separate front end). I will need to show all the values for each of the 4 sections, for a specific ID (along with info from other tables).

Separately by SectionName Ex: Taxes Sales -------------------------- valLow valLow valHigh valHigh valAvg valAvg Section Names are stored in the DB

The report will only be for one record (or ID). I realize that the pick list is static, and that should be fine. Hope that helps.

I have a DB with the follwoing structure: valLow valHigh valAvg SectionName ID ID and SectionName are a compound primary key. I need to show the 3 values for each section separately, for the ID selected when the user opens the report (from a pick list). Any info on this would be greatly...

I have a DB that has as structure like this: valLow valHigh valAvg SectionName ID The sectionName field desribes different groups of expenses for each person (ie rent, taxes, etc.) and is a string (this is a compound primary key of ID and SectionName). I want the user to pick a person to view...