Hello Tierra,

The National Museum of Asian Art (and other Smithsonian museums) use SQL Server Reporting Services (SSRS) in addition to Crystal Reports XI. 

It TMS I call these "spreadsheet" reports, because they are designed to be exported as Excel docs for all sorts of purposes. People love having images included in spreadsheets, too.

If you can write SQL queries, you can create SSRS reports!

Jeffrey Smith
Registrar for Collections Information
[log in to unmask]
O: 202.633.0348
C: 202-340-4896
 


-----Original Message-----
From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Tierra Marie Deacon
Sent: Wednesday, July 17, 2024 11:37 AM
To: ListServ tmsusers <[log in to unmask]>
Subject: Updating TMS and Crystal Reports

Hello, 

We are embarking on updating our TMS 2018, and our even older Crystal Reports and looking towards TMS collections and considering the best options for reports. 

Would anyone be willing to share their experience with moving from windows based TMS to TMS Collections? Any hints, tips, tricks, or insights would be deeply appreciated and greatly welcomed! 

Looking at other reports' software options, our IT Director encouraged us to look into Power Bi from Microsoft (SQL Based). Has anyone use Power Bi with TMS before? Is there a SQL system your institution uses other than Crystal Reports that you find valuable? 

Thank you for sharing your insights and knowledge!

Best, 
Tierra

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.

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.