1

Topic: First date - last date report

I need a report that gives year first recorded and year last recorded for a list of species in a Rucksack. Is this possible either with an existing report that can be modified or a new report? The columns would need to be Taxonomic Group..species..first year... last year...number of records. As per the attached file. Any help most appreciated.

Bob Marsh
Doncaster LRC
Coleoptera recorder for YNU

2

Re: First date - last date report

Hi

Try the attached and see how close this gets you to what you need. If it is close then it can be adapted from there. It runs from System Supplied Report/Taxon Restricted Reports/Rucksack Report - Rk3.

Post's attachments

JNCC_Rk3_Taxon_Years.xml 2.89 kb, 1 downloads since 2021-02-16 

You don't have the permssions to download the attachments of this post.
Mike Weideli
Littlefield Consultancy - IT Consultants

3

Re: First date - last date report

Hi Mike - thanks for that - it seems to work fine with a rucksack. Is it possible to tweak it so that there is a column at the end with number of records?? Such that columns are Scientific Name, Authority, First Year, Last Year, number of records??

Bob Marsh
Doncaster LRC
Coleoptera recorder for YNU

4

Re: First date - last date report

Hi

This adds a record count. It runs but needs checking.

Post's attachments

JNCC_Rk3_Taxon_Years.xml 3.41 kb, 2 downloads since 2021-02-19 

You don't have the permssions to download the attachments of this post.
Mike Weideli
Littlefield Consultancy - IT Consultants

5

Re: First date - last date report

Works fine Mike - many thanks for the work you have done on this.................

Bob Marsh
Doncaster LRC
Coleoptera recorder for YNU