Hi TMS users

I have written a couple of SSRS reports for our internal users to explore our collection which I would like to share if anyone can use these. The first is a tag cloud based on the count of ThesXrefs.ID and Terms and using a sample from Jason Thomas, Making a tag cloud with SSRS rich text  (http://www.sqljason.com/2012/03/making-tag-cloud-with-ssrs-rich-text.html). The second is a map using the geo data in the TMSThes.dbo.TermMasterGeo converted to SQL Geography data. Both drill through to a report with more detailed object information and an image.

We do not have TMS 2014 yet and these are published to our internal report server. To use then in TMS2014 I think you would need to add the TMSUserID parameter and also adjust the DataSource and query statement (I have put selections on the ThesXrefTypes and the ObjectStatusID to return a smaller dataset). If you are interested in trying these out please let me know and I can send the RDL file and links to some of the references that I found useful in developing these.
[cid:image001.jpg@01D0C47F.9AF088D0]

[cid:image003.jpg@01D0C47F.9AF088D0]

Kind regards, Sally

Sally Fletcher
Manager Registration

Australian National Maritime Museum
Darling Harbour
2 Murray Street  NSW  2000
+61292983726  +61418438273
www.anmm.gov.au<http://www.anmm.gov.au>

[http://www.anmm.gov.au/~/media/Media/icons/banner.jpg]<http://www.anmm.gov.au>

Join: eNewsletter<http://www.anmm.gov.au/get-involved/share-and-connect>


[social media icons]
*********************************************************************************

The Australian National Maritime Museum acknowledges the Gadigal people the traditional custodians of the land and waters on which we work.
We also acknowledge all traditional custodians of the lands and waters throughout Australia and pay our respects to them and their cultures; and to elders both past and present.

This transmission is intended only for the use of the addressee and may contain confidential or legally privileged information.
If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited and may incur severe penalties.
If you have received this transmission in error, please notify us immediately by telephone on 02 9298 3777 and delete all copies of this transmission together with any attachments.

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.