Now you have totally lost me. No currently my formula is developed to drop the data to the next line of same record and to grow accordingly. Will have to look at this. Very frustrating process. Thanks for your comments. :-(
Have a form that must have the details area an exact size. There are instances where data from a field will not fit into the box, so need it to have remander go into the next detailed section area. Using Crystal 8.5 and have figured out the VB script to determine if data will fit and if not...
Through some additional reseach came up with an idea that lead me to do the following replace command in Crystal Reports.
VDesc = Replace(ItemDesc, chr(13) & chr(10), " ")
Originally I had two replace lines in formula one for the chr(13) & another for chr(10), which did not work...
Thank you for all the help. I never did manage to get anything that could read the characters such that I could cut and paste the little black box. Through some additional reseach came up with an idea that lead me to do the following replace command in Crystal Reports.
VDesc =...
I am trying to create a formula in Crystal Reports 8.5 using Visual Basic.
Require the Text field to have all carriage returns removed, but have not been able to get the 'replace' command to work. Note that I browsed the data field while in Crystal and see the CR as little black boxes!
The...
I am trying to pass the text to a report without the CR and have not been able to remove the CR, as views as the little black box. Next stupid question - how did you display that little black box?
TY for your help! On to the next phase!
I am trying to create a formula in Crystal Reports 8.5 using Visual Basic.
Require the Text field to have all carriage returns removed, but have not been able to get the 'replace' command to work. Note that I browsed the data field while in Crystal and see the CR as little black boxes!
The...
We need to upgrade to Crystal Reports 8.0, and not sure which version we should go with. Is it better to go with Professional or Developer, and why?
Any feedback would be greatly appreciated, as need to upgrade ASAP to allow us to continue on with project.
TY in advance! :o)
Can someone show me how to do a SearchAndReplace to remove carriage returns in a field and replace with spaces. I have tried it, and have had no luck with formula.
Using Crystal 7.0 and have downloaded the uflrepl.exe update.
Wow thanks for all the suggestions! As a newbie I am still trying to figure this all out, and have limited programming skills. Will let you know how I do. Thanks for all your comments.
The field is set to grow(wrap) and can occur because of the lenght of the field data and/or linefeed characters embedded in the text being pulled from the SQL database. The SQL field is set as alpha/numeric and has ability to be 255 characters in length.
So I need a method of controlling the...
The field is set to grow, as the number of lines required per record will changed. Need to somehow tell it that if record has taken up odd number of pages to insert a blank!
Fairly new at Crystal Reports and need to ensure consistent placement of data on forms. Have a group header and details area where the records data grows. Need to be able to ensure that recoreds fill data down report two lines at a time, such that if the record takes up three lines the fourth...
Thanks for all your help did get me going in the right direction. Ended up adding line below in the formula field to determine last page of report, which allowed me to have unique ID numbers to be place on the page depending on if it was the cover page, item sheet(s), or summary sheet (last...
Thanks for the information. This does not quite solve my problem, as using PageFooter to create my footer for other pages. So this will still print unless I am able to supress for last page. I am fairly new at Crystal and trust me have learnt a lot from playing and reading this site. Great...
Thanks for the information. Have already updated the 4in1 VIA drivers, and still have same problem. Did the Windows 2000 Sp1. Is there any other updates that should be done to support the VIA chipset.
Thanks again for all your help!
Creating a report that has two sub-reports. Have sorted out headers and such, and having a problem with the footer on last page. Report setup such that there is only one cover page, multiple middle pages, and one last page. Have got cover page, and middle page footers working. What I need...
Here is the additional information. Thanks for helping with this.
It is a Socket 370. I have reverted back to Asus drivers 5.33. Although I have had the Detonator 6.31 installed. SP1 on Sever 2000 And the motherboard chipset is a VIA Hercules on a Asus CUVX 4 motherboard. The Video Card is an...
My W2K Server does a core dump everytime I access any extended features regarding the video card. Such as movies or games but runs fine otherwise. I have a Geforce2 MX by Asus and it works fine under ME. Can someone Help me?
I am running a 7.1.7 Driver from Nvidia(I think that is the Detonator...
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.