1

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

Craig Slawson
Staffordshire Ecological Record

2

Re: Specimen Details

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)

Mike Weideli