Showing posts with label builder. Show all posts
Showing posts with label builder. Show all posts

Friday, March 30, 2012

Named query not appearing in report builder

I'm having a heck of a time with named queries. At this point I just want a proof of concept in my DSV. I have a bunch of tables added to the DSV, and I would like to add a named query to it so the user can pick from the name query in report builder. What has to be done to make it appear in the report builder?

Nevermind. I didn't realize that the report model definition had to be refreshed.

Saturday, February 25, 2012

My Report feature

Currently - our Reporting Services site is setup so that all Domain Users can access it. We are starting to use Report Builder now. I have enabled the My Reports folder feature that that creates a user folder for anyone that logs onto the site. Is there a way to just create the user folders for certain people?

Yes. You do not have to use the "My Reports" function at all. Just create a folder for each user under the Home folder and then assign them at least browser rights to that folder. Also, be sure they have browser rights to the Home folder or they will not be able to see their own folder as this follows a hierachial structure.