Recent content by MAT2001

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

ABOVE MESSAGE SHOULD READ If record has taken up odd number of lines insert a blank! sorry!

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