Search results for query: *

I'm putting together a letter to send out to a group of customers. The customer's first name is in customers.firstname. How do I write a formula to print "Dear Dan" and then "Dear Molly" etc. I tried as follows "Hello" {customers.firstname} but I just end up with the customer's first...

I can access two fields in my database called status.ref and status.hat. They are free form fields in which you can type anything you want, numbers, text etc. If I have a new invoice opened and I never put anything into either one of those fields then Length({status.refno}) and...

Oh yeah, sorry. He had an old copy of version 6 and made the changes in there.

He put in some sort of cross-tab section in the report to accomodate the labor descriptions. It looks great now. He did a great job.

Thank you all for the help. Unfortunately we were getting fed up and we ended up hiring a consultant to take care of it. Thanks, dave

What I can tell you is the location of the various values for the fields in the database. According to the formulas in the default report... part description is in Printset.partdesc The quantity is in OrderList_1.qty, Sale is in OrderList_1.sale and the Extended is just some math it seems...

How would I go about verifying if the data is recorded over two lines? I don't have access to the database unless someone can tell me how to hack the password out of an MS Access database. I've tried other programs but they either say that there is no password or give me something that just...

Could i just put a special formula into Supress Blank Section for the Details Section in Section Expert?

I'm having a hard time even creating a blank report. I don't know the password for the database which is built using MS Access so I can't connect to it using Crystal Reports.

None of the fields have a check box next to Supress if Duplicated or Supress. There are no formulas in any of the X+2 boxes. Something else I want to mention is that there is a version of my report that includes the part number being printed in that blank spot underneath the name of the part...

Well I found Insert > Special Field > Record Number Field. Here's what it looks like. http://grace.speakeasy.net/~dorozco/images/screenshot6.jpg

I don't see a place to view the Field Explorer. Does version 6 have that feature?

Doesn't look like it made a difference at all.

My Report > Sort Records says the following. Report Fields has all the various database fields possible. The Sort Fields says "Group #1: Printset.seq - A" Sort Direction is grayed out with nothing selected.

Underlay Following Sections is not checked off. I will look into the sort order. I've actually played with that already but since you mention it I'll play with it some more.

It resulted in putting in an extra line on top of the one already being put in. What I don't get is that if I suppress @partqty, @partsale, and @partextended the extra spacing doesn't begin until the end of the labor description on the right side. If I continue to supress @labordesc and only...

Didn't work. Thanks though. Sigh. This is killing me.

Does this screenshot help at all?http://grace.speakeasy.net/~dorozco/images/screenshot5.jpg

trim(replace(replace({table.desc},chr(13),""),chr(10),"")) Will CR 6 support the use of trim like that? I ask because I don't see it listed like that in the Help File. I'll play with it in the meantime.

oops. http://grace.speakeasy.net/~dorozco/images/screenshot4.jpg Thanks for the help though. I'll play around with that trim formula.