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

Publishing a project with different folders within Expand / Collapse
Author
Message
Posted Tuesday, April 15, 2008 5:00 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, August 15, 2013 7:58 AM
Points: 423, Visits: 635
Hello again,

Still getting my head round Reporting Services. Managed to publish it to our reporting server via visual studio but I have no idea how you publish the reports within a project to different folders.

In the project properties it asks for...

StartItem main.rdl

Overwrite Data Sources True
Target Data Source Folder OurDept/Data Management/Data Quality Report/Data Sources
Target Report Folder OurDept/Data Management/Data Quality Report/

So everything goes here when I deploy. However I have lots of reports and for example I want

OurDept/Data Management/Data Quality Report/main.rdl
OurDept/Data Management/Data Quality Report/ManagementReps/TotalNumbers.rdl
OurDept/Data Management/Data Quality Report/ServiceReps/Service_reps.rdl

Ect. Is it possible to to this? I can move them about and add folders in Report Manager but when I deploy from Visual studio they just all get deployed to the top level again.

Debbie

Post #484868
Posted Wednesday, April 16, 2008 3:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 5, 2009 3:06 PM
Points: 8, Visits: 87
Hi Debbie,

From what I've read I don't think this is possible. You can set the target folder from the report properties as you've already discovered. And it's possible to have multiple configurations set up (eg I have my Debug profile publish to all the reports to an In Progress folder that only I have access to and my Production profile publishes all the reports to the public folder). But from what I can gather it's not possible to publish reports to multiple folders from within a single project.
I've dealt with this by having separate projects for different groups - a Rent Accounting project, a General Management project, a Maintenance project etc. But this doesn't allow for any fine control over report destination and I still have to manually move some of the reports after deploying.

Hope this helps,
John
Post #485502
Posted Wednesday, April 16, 2008 4:01 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, August 15, 2013 7:58 AM
Points: 423, Visits: 635
Ahhhh, I had a feeling this was going to be the case.

Im going to get round it now by havng a main report which contains links to the other reports which Im going to hide. I think thats the best bet to keep things simple.

Thanks for that!

Debbie
Post #485516
Posted Thursday, April 17, 2008 3:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 15, 2013 8:02 AM
Points: 8, Visits: 37
Debbie,

I would not recommend hiding the reports since sometimes users want to go directly to a report rather than having to navigate via a summary report.

I would recommend scripting your reporting hierarchy using the Reporting Services Scripter tool that can be downloaded from here:

http://www.sqldbatips.com/showarticle.asp?ID=62

This tool basically automates many of the tasks required to maintiain SSRS site and uses the object model by creating an executable to perform repetitive tasks.

You can refactor the generated code to create routines to create reporting hierarchy and one for uploading reports to that report hierarchy. Unfortunately, this can not be done via Visual Studio; however, once set up this is easy to maintain.

Hope that helps.

Post #486247
Posted Friday, April 18, 2008 2:21 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, August 15, 2013 7:58 AM
Points: 423, Visits: 635
Thanks for that but thats way beyond my capabilities at the moment.
Post #486963
Posted Friday, April 18, 2008 7:50 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:32 AM
Points: 7,161, Visits: 15,650
Create a subproject...put the other reports in there. The project seems to hold the publishing folder.

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Post #487202
Posted Friday, April 18, 2008 9:51 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, August 15, 2013 7:58 AM
Points: 423, Visits: 635
I think I may have to go down that route after the problems I have had today. I was creating a top level report to navigate down to each sub report but it causes issues with lower level parameters.

Ill have a think as to the navigation and set up seperate projects.

Im guessing this means I can have a project of DATA QUALITY REPORT

and a sub project of SERVICE REPORTS?

I havent tried making sub projects yet, is it fairly straighforward?

Debbie
Post #487331
Posted Wednesday, March 21, 2012 4:35 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 25, 2012 9:41 AM
Points: 1, Visits: 12
Creating a top level project solution is easy if you have your source control well structured.

Create a new Report Project - this will create an empty or dummy project (which you will later remove)

Add Each of your other projects (assuming you have groups your reports by folder)

Remove the dummy project and save your solution.

This way you will be able to manage the whole reporting solution as a true heirarchy with each project having its own respective publishing parameters.

It also allows other team member to work with individual report projects concurrently.

Hope this helps
Post #1270550
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse