Removing My Reports Folders

Apr 24, 2008

I am the administrator for our Reporting Services environment. I was researching the functionality of the My Reports feature of Reporting Services 2005. I enabled the My Reports feature and SSRS created folders to accomodate this feature. I then experimented with linked reports.

Now I want to undo this feature. I turned off the My Reports feature but the folders remain. The Report Manager refuses to delete them. I found their entries in the ReportServer.Catalog table but don't want to just delete them.

Does anyone know how to remove these folders from the Report Manager?

Gordy

View 1 Replies

Deploy Reports To Specific Folders

Jan 29, 2007

Hi, I am a new user for RS so this might be a very dump question for some of the advanced users here.

I am using SQL 2005 RS and was wondering how I can deploy reports to specific folders that I created on the Reports page. I do know that I can go to Properties to move the reports to different folders. But the problem I have is when I deploy the reports from VS 2005 ( I created the reports using VS 2005) they were deployed back to the old/root folder. How can I change the 'deploy-to' destination folder for the reports in VS 2005?

Many Thanks,

Casey

View 6 Replies View Related

Drill Through To Reports Located In Multiple Folders

Feb 28, 2008

Report A contains a textbox that should navigate to Report B using the Jump To option. Report A and Report B are located in separated folders on the Reporting Server.

SSRS looks for the rdl file within the same folder when using the Jump To option. Is there away to navigate to a report located in a different folder on the same server?

Thanks

View 1 Replies View Related

Restrict Users To View Reports And Also Folders In Report Manager

May 6, 2008

Hi,

I would like to restrict users to allow to view related reports only...
like i have 2 users..with 4 reports

1 user can see only two reports
2 user can see only another two reports

how can i do this by SSRS???
Can i do by using Configure item-level role definitions in seetings link..
or is thr any another way to do this?

Pls reply back

Regards,
Maruthi..

View 4 Replies View Related

SQL Server 2008 :: Delete Folders / Sub Folders Older Than N No Of Days

Jul 30, 2015

If I run the below command, it clean up the files inside the folders but unable to clean up the folder and sub-folders older than 30 days. xp_ cmd shell ' forfiles -p "D:abcd" -s -m *.* -d -30 -c "cmd /c del /Q @path"'

View 4 Replies View Related

Removing Deployed Reports

Jul 31, 2007

Hi All,
I deployed many reports in sql server 2005 reporting services. I want to remove some of the unnecessary reports. How to remove those reports?

thank you

thanks,
Muniappan Kandasamy

View 1 Replies View Related

T-SQL (SS2K8) :: Function To Create Folders (and Sub Folders)

Jun 5, 2014

I'm using sp_OACreate in a scalar function to create a folder if it doesn't exist, and it works fine if you're asking it to create a single folder. For instance: C:Newfolder

It creates "Newfolder"

However, if I try to ask it to create C:NewfolderNewsubfolder

It doesn't work

Here's the code:

DECLARE @Exists int, @ObjFile int, @ObjFileSystem int, @Folder nvarchar(500) = 'C:',
@Action tinyint = 1 --(0 to check if folder exists, 1 to actually create it)

EXEC dbo.sp_OACreate 'Scripting.FileSystemObject', @ObjFileSystem OUT
EXEC dbo.sp_OAMethod @ObjFileSystem, 'FolderExists', @Exists OUT, @Folder

[Code] .....

View 1 Replies View Related

Two (2) App_Data Folders?

Apr 25, 2007

I loaded an application to my server with the app_data folder intact in the application folder which is a sub folder of the root web.
Through my host enableing SQL somehow a second App_Data folder has been created in the root of the web and the db has been duplicated. Without a doubt this is causing a problem with the application not running correctly. The application is the asp.net membership app which is trying to read and write to the .mdf file.
Can we simply delete the App_data folder in the the root web or will this rebuild itself? Or do we need to edit the web config files?
How / Why did this happen?
Server is running Win2k with SQL Express 2005
TRU

View 2 Replies View Related

How To Add Folders In SQL 2005

Jun 13, 2007

does anyone have idea How to add folders in SQL 2005
thanks in advance

View 12 Replies View Related

Two MDF Files With Same Name In Different Folders

Apr 25, 2015

Is it OK to have two mdf files with the same name placed in different folders and attached with different names.

Example:
DATADB1Hotel.mdf attached as hotel1
DATADB2Hotel.mdf attached as hotel2

View 6 Replies View Related

How To Enumerate IS Folders ?

Dec 5, 2007

Hi All,

I need to get access to stored packages. To do so I use
Microsoft.SqlServer.Dts.Runtime.Application class.
There are methods: Application.FolderExistsOnDtsServer, Application.FolderExistsOnSqlServer
but I need to enumerate existed folders.
Are there something like: Application.GetFolders(String ParentFolderName) ?
I have searched in doc but there is not any useful except:

"To verify that the folder was created, the following Transact-SQL query selects all packages stored in the File System folder of the Stored Packages package store.

select * from sysdtspackages90 "

It is not suitable for me because I don't have permissions to access database

Thanks,
Sergiy

View 3 Replies View Related

Deploying To Sub Folders

Feb 21, 2008

hi all

using sqlserver 2005 Reporting Services

When I go to deploy

my main folder = Reports
my sub folder = reAct or Managers Reports or Onboarding etc

how do I deploy directly to the sub-folders?

thanks
jewel

View 13 Replies View Related

Dynamically Name Folders

Feb 12, 2007

Apologies in advance for the newbie question. I'm new to Integration Services and am trying to build my first project.

I want to dynamically create folders based on the results of a stored procedure. The resultset is limited to one column but can contain multiple rows. (It returns a list of 8-character strings representing dates.) This returned value needs to be combined with the path where the new folders should be created.

Can someone point me in the right direction? I've run the stored procedure and put the resultset into a RecordSet Destination that uses a variable of type Object. (At least, I think I've done it correctly.) But I have not been able to figure out how to access this data to actually create the folders.

Thanks for the help,

Chris

View 3 Replies View Related

SQl Dbase Query From Different Folders

Feb 4, 2008

HI, I have a Dbase Database stored in several subfolders. I allready made my connection with a sqldatasource and a gridview, and all works fine when i do a query with the tables in to root folder. The problem is when I try to include tables from the subfolders, the compiler send me a syntax error in the FROM Clausule
I Allready try this.
SELECT products.id, products.descri, condition.discount from products, clientscondition where products.line=condition.line
SELECT producst.id, products.descri, clientscondition.discount from products, clientscondition where products.line=condition.line
SELECT products.id, products.descri, condition.discount from products, condition in 'clients' where products.line=condition.line
SELECT producst.id, products.descri, clientscondition.discount from products, 'clients'.condition where products.line=condition.line
And many other different combinations. I would like to be helped if you know the correct syntax or a link where i can consult the syntax for VB.net and dbase with several folders
Another option a tried is having a query from 2 different datasources, but I don´t know how to make a reference to the 2 sqldatassources in a new one to be linked to the gridview

View 7 Replies View Related

Hide Folders In Report Mng

May 12, 2008

Hi All,

I would like to control user access to my Report Manager.In detail,I would like to hide some report folders from certain users when they access the Report Manager.Some of the users are not suppose to see certain folders on the report manager,and some users are suppose to see all report folders.

How can I do this?.Where should I include this settings?

View 4 Replies View Related

Databases In Separate Folders?

Mar 15, 2006

In Enterprise Manager, is there a way to group Databases into Separate folders?

View 6 Replies View Related

Deleting Folders Using SQL Triggers

Jun 24, 2007

I need to delete the empty subfolders under my "uploads" folder

how can i perform that using triggers

i need to delete old records in database and the folders associated with them, i've used triggers to delete the records before 180 days, but i don't know how to remove the folders associated with each folder.

note:
name of folders is the same as record number

is that possible?

View 1 Replies View Related

Restricting Access To Certain Folders?

Jan 6, 2007

Hi all,

I have a user who I only want to provide access to a single folder within
RS2005. I don't seem to be able todo this, they can either see everything or
nothing at all.

What am I missing? Any help much appreciated.

Kind regards
Tarun

View 10 Replies View Related

Can You Create Folders Under Databases In SMS

Aug 20, 2006

I see under databases in the object explorer of SQL Server Management Studio that there are two sub-folders: System Databases and Database Snapshots.

Is there a way to create other folders here? It would be nice to be able to group the various databases (ex. Samples).

tia

View 1 Replies View Related

Granting Permission To Folders

Feb 12, 2008

Within my Report Manager, I have several folders, and I would like these folders to be only visible to certain users and groups. In the Active Directory I have DOMAINGroupName1. If I add this group to the folder I want them to have access to with a Browser role, when they open Report Manager they do not see the folder at all. Then I added the same group to the HOME folder also, but again they could not see their folder when they opened the Report Manager. If I add the Users of this group individually (DOMAINUser1, DOMAINUser2 etc) then they can see the folder and run reports just fine. This is not an ideal solution as groups will change over time and I don't want to have to keep adding and deleting members. Anyone got any ideas why they can't see their folder?
Thanks!

View 4 Replies View Related

How To Suft Through MSDB Folders?

Feb 7, 2007

Hi everyone,

Primary platform is Framework 2.0.

My target now is to know programatically how many folder exists under MSDB folder as well as its names.

How to accomplish this?

Thanks in advance and regards,

View 3 Replies View Related

Adding Folders Under The Solution

Jul 5, 2007

In RS, can one add a folder under the Reports folder? I don't see where I can do this. We work with many different state's and we would like to organize reports by state.

Thanks for the information.

View 4 Replies View Related

ReportServer Folders And Deployment

Oct 28, 2007

I am making changes to a report and believe I am correctly deploying it to an ssrs report folder per the messages I get back from vs.net.

Question is, how can I see what folders are available? and where? At some point I knew or was able to do this, and think it was through SQL server since I can't see them through IIS and they don't appear to be real file system folders.

Also, I'm trying to figure out why parameter default value changes i make don't seem to deploy or overwrite??, while cosmetic (color for example) changes do when I deploy. I am selecting the option overwritedatasource in the project.

If I navigate to the reportserver I see the folder in question.

http://myreopertserveriphere/reportserver

Thanks for any help or information!

View 7 Replies View Related

Skipped Folders When Backing Up SQL To Tape.

Jun 28, 2002

Can someone please help in in understanding what I have done wrong. My company is using Backup Exec 7.3 as it's back up application. I have built a server, installed SQL, Built an database and added logins. I am backing up my database and Transact Log Files to specific folders on my partioned drive. Why when I run the backup ups, It backs up everything EXCEPT for my SQL folders. It seems to Skipp all SQL Folders. Please Help, I need to have this funtion working properly. What have I done wrong or what do I need to do to make this stop. Does this perhaps have something to dwil Here is an example of the backup Message in Backup Exec that I am recieving:

Media Name: "DIFF"
Backup of "FEPTESTE$ "
Backup set #41 on storage media #1
Backup set description: "Daily 6"
Backup Type: DIFFERENTIAL - Changed Files
Backup started on 6/28/02 at 12:36:21 AM.
The item Microsoft SQL ServerDataMSSQLDataTESTDB_Data.MDF in use - skipped.
The item Microsoft SQL ServerDataMSSQLDatamaster.mdf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDatamastlog.ldf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDatamodel.mdf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDatamodellog.ldf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDatamsdbdata.mdf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDatamsdblog.ldf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDataorthwnd.ldf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDataorthwnd.mdf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDatapubs.mdf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDatapubs_log.ldf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDataempdb.mdf in use - skipped.
The item Microsoft SQL ServerDataMSSQLDataemplog.ldf in use - skipped.
The item Microsoft SQL ServerDataMSSQLLOGTEST_Log.LDF in use - skipped.

Backup completed on 6/28/02 at 12:37:11 AM.
Backed up 48 files in 24 directories.
14 items were skipped.
Processed 23,876,604 bytes in 50 seconds.
Throughput rate: 27.3 MB/min

View 1 Replies View Related

How To Give Permissinon To Folders In SSRS

Mar 26, 2008

Hi,

I have one query in sql server reporting services securities.

In ssrs i have folders like(Custom reports, testreports,...). these folders are having reports. In this i want to give permissions to folders means if i gave permission to user1 to access the custom reports folder then he is able to access to that folder only and he is not able to access to any other foldes. How to give permissions to folders.

Pls any one help me on this.

Thanks
Ravuri

View 3 Replies View Related

Create Folders In Object Explorer - Wish...

May 4, 2007

Here's one thing that I'd like to see come out in some version of the SQL Server Management Studio...
The ability to create folders under the database node so that databases can be grouped on one server.

We have over 100 databases on our development server and these are created by a range of consultants and developers and even support staff as needed.

Being able to group the databases by product, etc would be a nice touch since we have client databases that don't fit naming conventions etc.

Multiple instances are another way around this but are expensive and resource hungry - we develop and support models, not use them for transactions too much.

Yes there are 'better' ways such as setting security correctly but we are too busy working and not maintaining.

Folders or database groups would be a nice touch.

Cheers

View 1 Replies View Related

Hiding Folders And List View

Jul 9, 2007

Hello I have a few questions hoping someone can help

Any way to hide a report completely ? ie data source folders, subreports called from hyperlinks etc

Anyway off hiding the List view and restrict the user from selecting list view ?

Anyway off customising the reporting services top area which is in yellow and black ie put a logo in this area ?

thanks

View 2 Replies View Related

File System And MSDB Folders Gone

Jul 27, 2007

This is terrible thing to happed at 4:30 pm on Friday!
I was working yesterday on some of deployment packages using file system (by the way, my msdb can not expand )
and just an hour ago I wanted to try some parent child deployment using file system.
but,
The only two folders I see in Integration services are Running Packages and Stored Packages. Nothing under those ones...
I have checked default location for File System (C:Program FilesMicrosoft SQL Server90DTSPackages) and there are three packages there but these do not show in IServices.
And another question, if I execute package by double clicking on .dstx file should that make it show under File System?

thanks

View 6 Replies View Related

Copy Folders And Files To Different Location

May 15, 2007

I have a situation from where I need to loop through different folders and files in these folders. After processing these files, I need to archive these folders to different location.

e.g., C:MainFolderMar01 ==> Multiple files in Mar01 folder

C:MainFolderMar02 ==> Multiple files in Mar02 folder

Does any one know the best way to do this in SSIS?

Thanks in advance.

BC

View 1 Replies View Related

How To Deploy Reporting Services Into Different Folders

Aug 29, 2006

Hi,

can i deploy reporting services rdl files into different folders in RS?

will it be able to create the folders by itself or do i need to create them beforehand?

thanks for any answers.

-

HY

View 7 Replies View Related

Adding Folders In The Solution Explorer?

Oct 27, 2006

Hi..
Isn�t it possible to create sub folders in the solution explorer??
I have it hard time to create a decent structure inside the SSIS Package folder, since I have like 30 packages in my project. Is it just me being silly or cannot this be done?

Have a nice day
/Erik

View 2 Replies View Related

How To Change Default Backup Destination To The Other Folders ?

Aug 4, 2007

By default,when I would like to back up any database by SSMS.
default destination on disk will be C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackup every time
Although I everytime change it to my backup folder.

Please let me know how to change it.

View 1 Replies View Related

Integration Services :: FOR EACH LOOP Traversing Folders But Don't Want It To

Jun 17, 2015

I have a simple FOR EACH loop who's task is to go to a folder, find all .zip files and then extract them to a directory of my choosing. I only want this step to extract files in a particular (root) directory.

What is happening is after the step extracts the main file to the specified output directory, it then goes to the next directory and extracts the files in THAT directory - even though I do NOT have "traverse subfolders" selected.

What is going on here? This has never happened before - at least when I was developing these packages with SQL 2008 R2...

View 5 Replies View Related