Reference Unbound Field

I have a crystal report that I would like to reference the field in a formula.  How can this be done?
I have already tried {myfield} does not work
LVL 1
H-SCAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
What do you mean the field in a formula?

Do you mean a variable you declared?
If so create another formula and copy the declaration then put the formula onto the report.

mlmcc
0
H-SCAuthor Commented:
Sorry I meant a field.  So I have an unbound field on my report called last_name and I also have another field that has a formula.  All I need to do is reference last_name field within the formula.  When I save the formula it errors and reads that the last_name field does not exist
0
James0628Commented:
There isn't really "binding" in CR reports, so "unbound field" doesn't really mean anything.

 All you should need to do is go into the formula editor, find that field in the Field Explorer and double-click on it to insert it in the formula.  The field name does have to be entered in a certain format (basically, {table/whatever name.field name} ), so if you were typing the field name in by hand, you may not have known the correct format.  Using the Field Explorer gives you the correct format, and removes any chance for typos.

 James
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

H-SCAuthor Commented:
James,
Many thanks, so even if the field is "unbound" not connected to any table; I would need  
{table/whatever name.field name}.  When I look at the field in the explorer and double click it does not add it.  It just prompts me for save or not to save.
0
mlmccCommented:
Double clicking a field does not add it to the report.  You have to drag it onto the report.

If it is not bound to a table there won't be a table.fieldname for it.

mlmcc
0
James0628Commented:
Well, the field has to be included in the datasource somewhere, but if you can see it in the list of fields, then it's included.

 When I mentioned double-clicking the field, I was talking about when you're in the formula editor.  If that's where you were and you got a prompt about saving the formula, then you were probably clicking on a formula or something to the left of the formula editor pane.  The list of fields included in the report and the datasource is in another pane, probably above the editor pane (I think those panes can be rearranged, so your placement might be different).  In the formula editor view, it may be referred to as the Field Tree.  You would double-click on a field in that list to insert the field in the formula.

 James
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
H-SCAuthor Commented:
All,
Would it be ok if I split the points.  I have actually learned quite a bit about all of this!
0
James0628Commented:
It's fine with me.

 James
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.