Managing enormous number of SSRS reports

  • Silly question - what do you do if you have a huge number of reports in SSRS and users need to be able to find them? Can you search by keyword or something to find a report? I was wondering if you could add keywords to the XML file, but that would most likely corrupt it. So how do you handle that? It's one thing if you have 20 reports, another if you have several hundred.

  • pietlinden - Wednesday, January 9, 2019 5:10 PM

    Silly question - what do you do if you have a huge number of reports in SSRS and users need to be able to find them? Can you search by keyword or something to find a report? I was wondering if you could add keywords to the XML file, but that would most likely corrupt it. So how do you handle that? It's one thing if you have 20 reports, another if you have several hundred.

    Not sure after the fact. When deploying reports, organize the folder structure on the report server so you don't end up with several hundred reports in a single folder. 
    Search works on descriptions which would be an option rather than trying to find safe attributes to use for keywords in the xml.

    Sue

  • If you are using the web interface for ssrs, there is a search box on the main page.  Just type in a partial name of a report and it will bring up all instances of it.

  • Oh, okay. Thanks! I'll have a play with it and see how I make out.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply