Find where a field has been used in a report 2

[Simon9999]

Hi

i am using CRXi.

Does anyone know if there is a function in crystal to trace where a field has been used in a report.

I have a field with a tick on it so know it is in use but cannot find it anywhere and was wondering if there is a simple way of showing what other formulae, groups, select expert it is used?

Thanks

Simon

 

[IanWaterman]

Go to export scroll down to report definition.

This creates a text file which you can search for your field name and pinpoint its use.

Ian

 

[Simon9999]

Thanks

I have tried this and a pop up box comes up saying preparing to install... and then it disappears and nothing happens.

Any ideas?

 

[IanWaterman]

Is your operating system NT.

For some reason its does not work on NT, no idea why. Can you open report on an XP machine.

Alternatively, try having your CR installtaion disk to hand, it may need to install another component.

Ian

 

[Simon9999]

No I am on XP. Does it need to be installed seperstely as it does not ask for me to insert any disks etc?

 

[Madawc]

Another trick is to modify the field so it will fail during a run. Divide by zero, for instance. Then you will see where it was used.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[IanWaterman]

Not usually, its part of the standard installation.

Try opening on another XP machine and see if Report definition works.

Madawc's suggestion only works for Formula and parameters etc.

Failing this save report with a new name, remove table from report (not a good idea unless its an end table in a link). Report will then complain everytime it encounters an unknown field in a formula or condition. Should eventually find the dubious field.

Ian

 

[rheard]

Eveytime we have 'lost' a field, it nearly always turns up in the sorting expert...

 

[IanWaterman]

Perhaps that is the first place you should look ;-)