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
I have already tried {myfield} does not work
ASKER
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
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
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
ASKER
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
All,
Would it be ok if I split the points. I have actually learned quite a bit about all of this!
Would it be ok if I split the points. I have actually learned quite a bit about all of this!
It's fine with me.
James
James
Do you mean a variable you declared?
If so create another formula and copy the declaration then put the formula onto the report.
mlmcc