I don't know where my formulas come from

[RSX02]

Hi
I'm in a report that it's not me who built it. I have formulas in my report that I know that it come from a table in my database. The thing is that in my formulas the only thing I see is for example ("sFax&quot.
sFax is a value in my table and not the name of the field. For each field1(where sFax is the field1) it have a field2 associated to it in this table.
For example the field2 for the sFax gonna be the text that I will display in the report. For example "Fax".
So does somebody have an idea where the formulas say in which table it have to take this data?
Thanks in advance

 

[synapsevampire]

A bit difficult to understand.

Try posting real example data, Crystal and database version information and expected output.

-k

 

[RSX02]

okay
In my Table (Tbl1) I have 2 fields (field1 and field2).
For example, this is the record in my table

Field1 Field2
sFax Fax
sOrder Order
sItem Item

In my Crystal report I have a formula with only this in it:
("sFax&quot(this is the field1) and when I preview my report I see Fax(this is the field2).
I wondering where it tell which table use. I know that it come from the Tbl1 but I don't know where it is specified.

My database is SQL and the version of my crystal is 8.5

 

[synapsevampire]

You can check what tables are being used by selection Database->Set Location, or by viewing the SQL as in Database->Show SQL Query

And you can write click any field and select browse data to see what's a field contains

I'm sorry, I really don't understand your question, and this:

("sFax&quot(this is the field1)

isn't Crystal syntax, so I'm unable to understand your requirement.

-k

 

[RSX02]

synapsevampire
what contain crystal is ("sFax&quot
The (This is the field1) is just to explain that sFax is the field1.
I'll try your suggestion and let you know

 

[RSX02]

Okay I think that maybe only my application does something like that so..forget it.
Thanks anyway.