Search results for query: *

Tha backup table is was created by me today as a direct copy from the production table using the export data wizard in SQL Server 2000.

bborissov, The query you supplied returns no records.

Sorry, should have included that the front end application is down. I took a backup of the table & then performed the find & replace on the production table. When the numbers didn't match, I copied the backup into production & tried again. The results were the same.

Thank you for responding. The query I used for the test is the following... select sum(len(rtrim(Column))) as count from Table; Is there any other way to do it? Thanks for the help.

I am attempting to do a search & replace where every occurence of " (double quote) is replaced by ' (a single quote). I am using the code ... update Table set Column = replace(Column,'"','''') I am running a query to get the length of "Column" in every record both before & after the replace...

Sorry synapsevampire, I wasn't paying attention. I am using Crystal reports advanced edition version 9.2.0.448 and extracting from MS SQL server 2000. The report looks fine on the screen & exports to Adobe Acrobat just fine. It also exports to MS Excel fully formatted perfectly. I need it to...

In this case its not possible. subrptfld1, subrptfld2 & subrptfld3 are dollar amounts that are totalled for each record on the report.

I have a subreport showing as additional fields in the records being printed in a report. The info in the subreport is financial data (multiple lines) per one record. Example... field1 field2 field3 subrptfld1 subrptfld2 subrptfld3 subrptfld1 subrptfld2 subrptfld3...

lbass, Worked like a charm !! Thanks

I have a problem when I have 2 group footers. I need each group-footer-2 to invoke "new page after" unless it is the last group-footer-2 printed. When it is the last group-footer-2 I need the group-footer-1 to print on the same page and then invoke "new page after" (only in this case). FYI...

Found my own solution. In the calculation I was referencing other formula's. When i changed the reference to the actual calculation of the other formula, I was able to insert a summary.

I have a formula converting text to number and doing a calculation. I need to sum this calculation at the group level & crystal 9 doesn't let me. Seems that crystal is considering it text and wont let it be summed. How can It be done????