Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Problem with Report Manager

Author  Topic 

AdamWest
Constraint Violating Yak Guru

360 Posts

Posted - 2009-07-16 : 21:23:57
I have a problem deploying the correct object.

Report Manager asks to attach a file.
I have a Report with a Report1.RDL, a Subchart.RDL. and ChartLegend.RDL

I don't know how to get them to all get uploaded to the Reports Manager.

One is fine but how to make them some kind of group for uploading?

AdamWest
Constraint Violating Yak Guru

360 Posts

Posted - 2009-07-17 : 10:05:29
I got them to load by putting them in one folder. But it looks silly. The user has to remember to click on Report1 and not click on Chart.

What I am missing here? How to load this in such a way that it looks like a normal menu item?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-07-17 : 14:19:08
why dont you merge them all in a single report and display if data for them are the same?
Go to Top of Page

AdamWest
Constraint Violating Yak Guru

360 Posts

Posted - 2009-07-17 : 14:35:51
They are one report but there are separate parts. For example, I made my own chart legend because I didnt see one. This is a second RDL but part of the project.

When I preview from the project it is fine but in Report Manager I have to include this second part in that folder there.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-07-17 : 14:39:52
then what you need is to create a separate rdls with subreports which calls each of current 3 rdls. then deploy and give this link to user
Go to Top of Page

bsivel
Starting Member

8 Posts

Posted - 2009-07-23 : 12:09:35
Batman,

Just hide the subreports in the list and include them in the main report.

To hide a report in the report manager list, go to the properties tab and check "Hide in List View"

bsivel

Brian Sivel
Go to Top of Page

Adam West
Constraint Violating Yak Guru

261 Posts

Posted - 2009-07-23 : 15:21:15
Brian, I don't want to hide the entire thing. I just want to display one entity and not all the RDL's and etc. that make up the project. WHat I do is, create a folder, then I upload files. I upload them all Else it won't run.

this one project has a few subreports- all of these appear in the Report Manager folder. I would like to see only one object appear. I can't grasp what is the issue. Being new to this system I just don't know alot of stuff about it.


CRSSsproca.sql !NEW 7/22/2009 10:16 AM TESTSERVER\OK
DataSource1.rds !NEW 7/22/2009 10:16 AM TESTSERVER\OK

Report Project16.rptproj !NEW 7/22/2009 10:16 AM TESTSERVER\OK

Report1 !NEW 7/22/2009 10:16 AM TESTSERVER\OK

Report3 !NEW 7/22/2009 10:16 AM TESTSERVER\OK

Section3a !NEW 7/22/2009 10:17 AM TESTSERVER\OK

Section3a.rdl.data !NEW 7/22/2009 10:17 AM TESTSERVER\OK

SubChart !NEW 7/22/2009 10:18 AM TESTSERVER\OK

SubChartLegend !NEW
Go to Top of Page

bsivel
Starting Member

8 Posts

Posted - 2009-08-06 : 13:05:04
While viewing the objects in Report Manager, click on a n object that you don't want visible. Open the object and click the properties tab. Check the HIDE IN LIST check box and save your changes. Do this for all Reports and other objects that you do not want report users to see.

If you want to see all objects - even those that are hidden, use the reportserver (http://<Servername>/ReportServer) or use Management Studio.

Brian

Brian Sivel
Go to Top of Page

Adam West
Constraint Violating Yak Guru

261 Posts

Posted - 2009-08-10 : 13:55:32
THanks Brian, that was it.
Go to Top of Page
   

- Advertisement -