1 Topic by PhilippaTomlinson

  • PhilippaTomlinson
  • PhilippaTomlinson
  • Veteran
  • Offline
  • From: Isle of Man
  • Registered: 18-11-2010
  • Posts: 52

Topic: Supplied Report T1 Records for Decades

Hi,
This is a very useful report for looking at a whole taxon group by decade. But having upgraded to Recorder 6.22 it no longer includes the records for the current decade. The 2010-2019 column remains blank and although the taxa which have only been recorded over the last four years are listed, no number is given in the row for these species.
Has anyone corrected this please?
many thanks and Happy New Recorder6 year!
Philippa

Dr Philippa Tomlinson
Biological Records Manager
Manx Biological Recording Partnership

PhilippaTomlinson's Website

2 Reply by PhilippaTomlinson (edited by PhilippaTomlinson 18-02-2015 13:02:03)

  • PhilippaTomlinson
  • PhilippaTomlinson
  • Veteran
  • Offline
  • From: Isle of Man
  • Registered: 18-11-2010
  • Posts: 52

Re: Supplied Report T1 Records for Decades

I have corrected the xml file on my system, there was just one digit wrong. Here is the correct version attached.

Post's attachments

JNCC_T1_Taxon.xml 7.6 kb, 8 downloads since 2015-02-18 

You don't have the permssions to download the attachments of this post.
Dr Philippa Tomlinson
Biological Records Manager
Manx Biological Recording Partnership

PhilippaTomlinson's Website

3 Reply by Gordon Barker

  • Gordon Barker
  • Veteran
  • Offline
  • Registered: 15-05-2006
  • Posts: 344

Re: Supplied Report T1 Records for Decades

I had to make another change to get it to work for me. There are two points in the original where "SUM(CASE WHEN DECADE=210 THEN QTY END) AS [2010-2019]" appears and your version is changed to "SUM(CASE WHEN DECADE=201 THEN QTY END) AS [2010-2019]"  for only the first of those. To get it to work properly in all cases you need to change the second one as well, I think.

Gordon Barker
Biological Survey Data Manager
National Trust