Forum — Report to show multiple determinations

Re: Report to show multiple determinations

null@example.com (FNRCinfoassist) — Thu, 04 Aug 2022 14:48:58 +0000

Thank you so much Andy, that has been really useful. Very much appreciate your time and effort with this. Thanks again.
Mhairi

Re: Report to show multiple determinations

null@example.com (AndyFoy) — Thu, 21 Jul 2022 13:29:28 +0000

Hi Mhairi
Attached is a report that will hopefully do what you need, if not let me know and I can adapt it. It doesn't appear in the Reports menu, only by right-clicking on a report and selecting Quick Report -> GiGL -> GiGL_MultipleTaxonDesignations.
Andy

Re: Report to show multiple determinations

null@example.com (FNRCinfoassist) — Wed, 20 Jul 2022 10:21:49 +0000

That would be brilliant Andy, thank you very much. I shall park this just now till I hear from you.
Thanks again,
Mhairi

Re: Report to show multiple determinations

null@example.com (AndyFoy) — Wed, 20 Jul 2022 10:18:27 +0000

Hi Mhairi
I think I can create a report that will show what you need. Just give me a few days to find some time to write and test it.
Andy

Re: Report to show multiple determinations

null@example.com (FNRCinfoassist) — Tue, 19 Jul 2022 08:59:20 +0000

Hello Andy and thank you for responding. It is the latter I am after. So far I have identified a few determinations that don't make any sense at all eg. Ground ivy being changed to Weasel? I suspect that this error is related to species that were originally recorded on another version of Recorder or was an associated species on another version of recorder and has somehow managed to become the preferred determination on an unrelated record. A report that lists species records with multiple determinations that would allow me to see the original determination and recorder and the later determination and determiner would give me something to start with. I am having difficulty trying to figure out how this happened, so need to determine the size of the problem in the first instance. It is older, historical records that this has happened to but the preferred determination is by more recent recorders so the dates don't make sense.
I am sorry I am a bit rambling, my first day back this week and I am trying to get my head round this.
Many thanks for your help
Mhairi

Re: Report to show multiple determinations

null@example.com (AndyFoy) — Mon, 18 Jul 2022 14:05:38 +0000

I'm not aware of an existing report but I don't think it would be too tricky to create one. Do you just want to know which occurrences have multiple determinations (and how many determinations) or do you want to see the individual determinations?

If the latter would the following columns be appropriate:

SurveyName
EventDate
SampleDate
LocationName
Location
TaxonName
CommonName
Determiner
DeterminerRole
DeterminerType

Andy

PS Could you add your name to your posts (FNCRinfoassist doesn't give any clues). It's always nice to know who we are taking to :).

Report to show multiple determinations

null@example.com (FNRCinfoassist) — Thu, 14 Jul 2022 13:14:19 +0000

We have come across a problem in our database and want to try to quantify it. A report showing the multiple determinations of each record within a survey would be really useful as a starting point. Is there a report like that available, this problem only exists when there are multiple determinations. Any help appreciated.