Hide 'New Subscription' in the explorer bar

Hello

We do not want the end users to know of the subscription capability. How do we hide 'New Subscription' link for a report.

Thanks

InderSunny,

You can edit your Browser role and remove the capabilties of the user - Report Directory/Properties/Security should get you going.

Ham

|||

In the security tab only following roles are available

Browser

May view folders, reports and subscribe to reports.

Content Manager

May manage content in the Report Server. This includes folders, reports and resources.

My Reports

May publish reports and linked reports; manage folders, reports and resources in a users My Reports folder.

Publisher

May publish reports and linked reports to the Report Server.

Report Builder

May view report definitions.

Which one should be selected so that the user is only able to view folders and reports and not subscription.

|||

indersunny,

Click on the Browser and you will get : - Assign the approciate security.

elect one or more tasks to assign to the role.

Task

Description

Consume reports

Reads report definitions

Create linked reports

Create linked reports and publish them to a report server folder.

Manage all subscriptions

View, modify, and delete any subscription regardless of who owns the subscription.

Manage data sources

Create and delete shared data source items; and modify data source properties.

Manage folders

Create, view and delete folders; and view and modify folder properties.

Manage individual subscriptions

Each user can create, view, modify and delete subscriptions that he or she owns.

Manage models

Create, view, and delete models; and view and modify model properties.

Manage report history

Create, view, and delete report history snapshots; and modify report history properties.

Manage reports

Create, view, and delete reports; and modify report properties.

Manage resources

Create, modify and delete resources, and view and modify resource properties.

Set security for individual items

View and modify security settings for reports, folders, resources, and shared data sources.

View data sources

View shared data source items in the folder hierarchy; and view data source properties.

View folders

View folder items in the folder hierarchy; and view folder properties.

View models

View models in the folder hierarchy, use models as data sources for a report, and run queries against the model to retrieve data.

View reports

View reports and linked reports in the folder hierarchy; view report history snapshots and report properties.

View resources

View resources in the folder hierarchy; and view resource properties.

Ham

|||

InderSunny,

Can you mark my post as answer so our solution will be found by others who are looking for the same solution?

Thanks,

Ham

Hem! Query Problem

I may not be using this right, so if I am not, be gentle

Im in Visual Basic Express, I went to the database explorer and right clicked on my table thats in the database and selected new query.

I noticed Query1 at the top, anyhow I laid out my query like I wanted, and went to save

Guess What, I couldnot find a save but, all I found was save all.

I did choose that, but I cannot find the query now.

Started a another query and I noticed ,Query2, so it had to have saved it, but where?

Is this not the right approach?

Very Confused at this point

Davids Learning

hi,

AFAIK, the "Save All" button is there for all other type of activities (vb/c# code) but not for the query itself..

the query you want to save can obviously not be saved on the SQL Server instance you are connected to as only procedures, views, udfs can be saved in the database metadata and not a "free text" query..

actually my thought is you should be prompted to save the query to a txt/sql file, but it seems not to be the case... perhaps you can try asking in VS2005 forum, but my thinking is the "free text" query can not be saved at all, as the "Save selected item" is grayed out..

regards

|||

Andrea is correct. The New Query functionality is used to allow you to run ad hoc queries against your database. I'm guessing that what you're actually looking for is the ability to save a new object in your database that you can later use in you application.

To do this, you would add the type of object that you want to add to your database, for example, for a simple select statement, you would add a new View. On the Data menu, point to Add New and then click View. Once you create your select statement, you will notcie that the Save Selected Item is available and when clicked you will have the oportunity to name your new View. The new View will show up in the View folder of your database.

Hope this helps.

Mike