Forgot password? | Forgot username? | Register

Making fields available for reports

Making fields available for reports

John's post and Christelle's response reminded me of a question I have:

I sometimes find that a field is not available in the Field Properties box when I try to add it to a report (for example, CatObjectType in our Catalog module.) If I remember correctly, this is because each field needs an attribute set before it appears as available. Can this attribute also be set in the Registry? Or must it be set by KE/Axiell staff?

Other such fields include LatPreferredCentroidLatitude, LatPreferredCentroidLongitude, LatPreferredCentroidLatDec and LatPreferredCentroidLongDec in the Localities module.

I know I can directly edit the Registry entry for a report in order to include such a field, but adding it to the list of available fields would of course be more straightforward.

Thanks,
Tom Trombone
AMNH Ornithology

Edited by: Thomas Trombone - 17-Jul-15 01:43:20

Thomas Trombone
Data Manager, Ornithology
useravatar
Offline
54 Posts
Male  Website 
Administrator has disabled public posting. Please login or register in order to proceed.

Re: Making fields available for reports

In the past when this has happened it was because the back-end programming was incorrect (typo or other error).  The column was either mislabeled in EMu Report Properties or missing entirely.  In other words, the first thing I'd do is ask KE/Axiell to look into it.

You might want to use the TITLE registry entry to cause the missing field to appear. 

Bill

Edited by: Bill Mertz - 17-Jul-15 03:04:08

Bill Mertz
Database Manager
useravatar
Offline
22 Posts
Male  Website 
Administrator has disabled public posting. Please login or register in order to proceed.

Re: Making fields available for reports

Hi Tom,

You might find the the "Reportable" registry entry will make those fields available.  You can find more information in the online EMu Help under: Alphabetical list of EMu Registry entries: N-Z.

Edited by: - 21-Jul-15 14:13:42

Administrator has disabled public posting. Please login or register in order to proceed.

Re: Making fields available for reports

Thanks, Deb! As it happens we are running an older version of EMu (quite a bit older: 4.0.03) that doesn't seem to support this Registry entry.

We had been holding off on upgrading until other departments here at AMNH implement EMu, but recently we decided to move ahead with an upgrade of our live environment in the near future. Consequently we just upgraded our test environment last week, and I see that the test client does support the Reportable entry. I will take a look at this entry in test and see if I can use it address the question in my first post.

Tom Trombone
AMNH Ornithology

Thomas Trombone
Data Manager, Ornithology
useravatar
Offline
54 Posts
Male  Website 
Administrator has disabled public posting. Please login or register in order to proceed.

Re: Making fields available for reports

Hi Tom,

Good luck with the upgrade.  I don't know enough about the changes between 4.0 and 4.3 to know for sure, but it is possible that the fields you want to report were made "reportable" between versions, so it might be worth checking the report fields or talking with your local support rep, as well.

Just a thought.

Regards,
Deb

Administrator has disabled public posting. Please login or register in order to proceed.
There are 0 guests and 0 other users also viewing this topic

Board Info

Board Stats
 
Total Topics:
601
Total Polls:
0
Total Posts:
1362
Posts today:
2
User Info
 
Total Users:
816
Newest User:
Gregory Brown
Members Online:
2
Guests Online:
179