Loading
search-img

KarlJ asked a question.

May 14, 2018 at 7:00 AM
Crystal Reporting and SNOW

Does anyone know if SNOW Inventory and SLM can be queried with Crystal Reports?

I have some rather complex reporting requirements to the business stakeholders, and something like Crystal would be ideal.  Just curious if anyone else in the SNOW community has already done this, and if so, where there any specific challenges to overcome?  I dont really want to go down the road of exporting huge flat files from SNOW, which CRW queries.  I would prefer direct connection with the db datasource. 

Thanks

karl

  • 7 answers
  • 79 views

  • Community Manager (Flexera Software)

    Hi Karl,   Yes, this is possible. Snow Inventory and SLM are using an SQL database which can be queried by Crystal Reports. Ask your database administrator to create a database read account and use this in the connection setup in Cristal Reports.   If SLM is installed on a hosted platform it might be a little bit more difficult. The hosting provided probably do not allow you to query the database. What you can try is exporting the data to Excel and setup the Cristal Reports connection this this Excel file.   Kind regards, Jeroen
    Expand Post

    • KarlJ

      Thanks Jeroen, I'm already setup with a db account and have a connection with CRW.  I guess the silly question is how the tables are linked.  Is there some sort of db schematic/data dictionary that shows the linked tables, and how they are linked (indexes, keys,  etc.) Thanks karl

      • Community Manager (Flexera Software)

        Hi Karl,   I don’t have an ERD from our SLM and Inventory database. You can try to log a support ticket and ask for it but I’m not sure if they are allowed to share this.   If I’m not mistaking when setup the connection in Crystal Reports and load the tables it automatically creates the relations based on the primary and foreign keys. This should give you most of the requested information.   Kind regards, Jeroen
        Expand Post

        • KarlJ

          Thanks Jeroen, Yes, the ERD would be ideal - a description of how the table hang together.   I'll try to see if I can dig one of these up. Thanks

  • iankimble

    Hi Karl, tbh it's very simple and easy to understand - just start looking at the views and you'll quickly be able to work it out (or a dba can). there is a clientid field that is used to link between the tables. I don't use crystal reports but have ssrs reports that pull all sorts from the databases

    • KarlJ

      Thanks Ian, Yes indeed, looking at the various views is making sense.  I'm still rummaging through and trying to find which views (or tables) contain custom fields I had added in SLM...!!! Karl 

      • iankimble

        I think from memory this is where you will need to go straight to a table as don't think there is a view for it dbo.tblcustomfield

+1.800.374.4353
CONTACT SALES SUPPORT HUB FLEXERA REVENERA
© 2026 Flexera. All rights reserved.
Privacy policy Terms and conditions Revenera Community Help
Loading
Crystal Reporting and SNOW