Topic: Specimen Details
I'm trying to produce a report including the specimen details (for our local museum) but cannot see where the "Specimen Location" field is in the report layout can anyone help?
Craig
Staffordshire Ecological Record
The technical forum of the NBN Trust for use by the Network. It includes discussions and announcements on the NBN Atlas, Recorder 6 and Indicia |
You are not logged in. Please login or register.
Forum → How Do I... & Other Questions → Specimen Details
I'm trying to produce a report including the specimen details (for our local museum) but cannot see where the "Specimen Location" field is in the report layout can anyone help?
Craig
Hi
Specimen Location isn't there. The following SQL will add it.
Mike
DELETE FROM REPORT_FIELD WHERE REPORT_FIELD_KEY = 'NBNSYS0000000167'
DELETE FROM REPORT_ATTRIBUTE WHERE REPORT_ATTRIBUTE_KEY = 'NBNSYS0000000167'
INSERT INTO REPORT_ATTRIBUTE (REPORT_ATTRIBUTE_KEY, ITEM_NAME, ITEM_GROUP, SOURCE_TABLE,
ATTRIBUTE_SQL, REPORT_JOIN_KEY,REPORT_WHERE_KEY,
ENTERED_BY, ENTRY_DATE,SYSTEM_SUPPLIED_DATA)
VALUES ('NBNSYS0000000167','Specimen Location', 'Taxon', 'TAXON',
'#REPORT_OUTPUT.[Specimen Location] = SPECIMEN.LOCATION',
'NBNSYS0000000024', 'NBNSYS0000000000', 'TESTDATA00000001',getdate(),1)
INSERT INTO REPORT_FIELD (REPORT_FIELD_KEY, ENTERED_BY, REPORT_ATTRIBUTE_KEY,
FIELD_ITEM_NAME,FIELD_TYPE,FIELD_SIZE,ENTRY_DATE,SYSTEM_SUPPLIED_DATA)
VALUES ('NBNSYS0000000167','TESTDATA00000001', 'NBNSYS0000000167','Specimen Location',
'varchar', 100,Getdate(),1)
Forum → How Do I... & Other Questions → Specimen Details
Powered by PunBB 1.4.6, supported by Informer Technologies, Inc.