Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Report Manager organization Expand / Collapse
Author
Message
Posted Monday, March 10, 2014 8:13 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, July 18, 2014 6:09 AM
Points: 532, Visits: 447
Hi Everyone,

Just curious as to how you organize your reports on the server.

1. By report type
2. By department/functional area of your company
3. something else, and if so please provide a bit if detail.

Right now, I have my reports pretty much organized by functional area, but am looking for ideas that might make more sense.

Best,

Dave
Post #1549246
Posted Monday, March 10, 2014 8:54 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:22 PM
Points: 11,148, Visits: 12,889
The 2 things I'd look at when designing the SSRS folder structure is:

1. Making navigation easier for users
2. Making managing security easier for me.

In my experience those 2 items typically mean setting it up based on department/functional area the best way to set it up.




Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1549285
Posted Monday, March 10, 2014 9:35 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, June 8, 2014 11:25 PM
Points: 25, Visits: 35
Hi I Jack, I got small requirement pls help me out and i can send you the details, please let me know how to add image here..thanks
Post #1549305
Posted Monday, March 10, 2014 9:47 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:22 PM
Points: 11,148, Visits: 12,889
To add images you can use the IFCode's (img tag or the Insert Image button at the top of the editor) if the image is something you can provide a link to, or you can just add images as attachments to your post using the post options below the text entry window.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1549322
Posted Monday, March 10, 2014 9:49 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, June 8, 2014 11:25 PM
Points: 25, Visits: 35
Jack, I have done it..thanks for your reply..!! i have recently added new post, Please help me out thanks
Post #1549326
Posted Tuesday, March 11, 2014 8:29 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, July 18, 2014 6:09 AM
Points: 532, Visits: 447
Jack,

Thank you for your insight. That makes sense.

Dave
Post #1549781
Posted Tuesday, March 11, 2014 9:10 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:22 PM
Points: 11,148, Visits: 12,889
Glad that seemed to help. I'm surprised no one else had anything to share about this.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1549804
Posted Tuesday, March 11, 2014 9:26 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 9:18 AM
Points: 2,998, Visits: 3,162
OK - I'll jump in Jack.

Like you, to make managing security easier, we organise the folders / reports on business area so that the HR reports are in their own folder and finance ones in their own area etc.

Folders are accessed by AD group membership, so when there is a new starter in a team, they are put in the right AD groups and can then see the reports they need to.


-------------------------------
Posting Data Etiquette - Jeff Moden
Smart way to ask a question

There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
Post #1549812
Posted Wednesday, March 12, 2014 1:19 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Sunday, July 13, 2014 1:57 PM
Points: 72, Visits: 441
YMMV but I usually organize my reports by function.

I also create reports that act as menus to help users find and access reports that pertain to the function. I hide all the subreports and main reports and just display the report menu. This is useful for those users who don't know about the "show details" option and helps steer them away from running subreports that need parameters passed from another report.

I am able to manage the security easily because in my small company a user is either able to see all the reports in a given function (folder) or they're not.
Post #1550404
Posted Wednesday, March 26, 2014 6:33 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, July 18, 2014 6:09 AM
Points: 532, Visits: 447
Thank you very much, everyone! I appreciate your feedback on this!
Post #1554914
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse