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...
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...
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...
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????
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.