What is in a field?

[PerrinA]

I need to include a field in my report, but am unsure of what it's called. I know the data values that will be in the field. There are over three hundered fields for me to search through. Is there any way I can find the field I'm looking for?
-Jason

 

[dgillz]

Unless you have some technical documents from the developer that tell you this, and unless your field names make some kind of sense, this is not easy. A couple of things you can do are:

1) On the field explorer, make sure the far upper right icon is depressed. This will show you not only the name of the field, but the data type and length of the field, while you are in the field explorer. This should allow you to narrow the choices down.

2) Also while in the field explorer, right click on the field in question and select "Browse data" this will show you the actual values in the database for that field. This may be helpful.

Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[synapsevampire]

Drop every field into the report, then export some reasonable quantity or rows that would assuredly have your known results to Excel or some other format.

Now use a conventional Ctrl-F search.

<shrug>

Beats clicking on 350 fields...

You could also just open the table from within Excel (or another application) directly and do the same thing.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com