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
Is there a way to limit what user will see in Enterprise Manager? Iwould like them to only see there db's and not all them.
View 5 Replies View Related
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..
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 RelatedI'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] .....
Is there a way to easily list the tables/views that a view is using to get its data?
Thanks in advance,
Shawn
I accidently deleted the file that I was working on in notepad that had the tables and views that I created. Is there a way to retrieve a list and the code that I put in for the tables and views?
View 1 Replies View RelatedI need ssrs report which get job info from job table in list control and other one is jobid and workdate which also need to be group by and storeproc I am using for this report is as follow:
ALTER proc [dbo].[VRAJ_JobScheduleReport]
@JobID int = null, @StartDate varchar(25) = null, @EndDate varchar(25) = nullASSET
NOCOUNT ON SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON DECLARE @sql varchar(max);DECLARE @param varchar(max);DECLARE @where1 varchar(max);DECLARE
@where2 varchar(max);SET @param='';SET @where1='';SET @where2='';IF @JobID IS NOT NULL BEGIN
SET @param = @param + 'DECLARE @JobID int; SET @JobID=' + CAST(@JobID AS varchar(50)) + ';'; IF @where1 = ''
[Code] ...
I need ssrs report which get job info from job table in list control and other one is jobid and workdate which also need to be group by and storeproc I am using for this report is as follow:
ALTER proc [dbo].[VRAJ_JobScheduleReport]
@JobID int = null,
@StartDate varchar(25) = null,
@EndDate varchar(25) = null
AS
SET NOCOUNT ON
[Code] .....
When using Sql Server Enterprise Manager and viewing a Database / Tables section, most of the tables if not all have a create date of 11/5/2004.Except for one, DNN_Users, has a creation date of 7/10/2007What factor could have caused that create date to have changed?What factors go into the date being set on that column in the database design? Does the date get updated say if I were go go in and change a datatype in a table?
View 5 Replies View RelatedI need to install SSIS/SSRS in SSMS. I have connected the SharePoint list view to excel for reporting purpose but due to data size the performances is very slow in excel and now I would like to connect the SharePoint List to SSIS/SSRS
I have windows 8, 64 bit system
I have installed SQL Server Management studio 2012 but I am unable to enable the Integration and Reporting Services
May be I have missed to choose the option during installation.
I want to see all the fields list on the left side of report layout, you can drag a field and put it on the report.
Thank you very much.
I have a list of ClassID that is stored based on users multi select on a listview
For example ClassID might contain
301
302
303
304
Now I need to find InstructorID where classID matches all the value in the above list.
I am using this query
Code:
Dim assSQL = "Select InstructorID from ClassInstructors where ClassID = @P0"
For i = 1 To classIDs.Count - 1
assSQL &= " UNION Select InstructorID from ClassInstructors where ClassID = @P" & i.ToString
Next
[Code] ....
But the problem is the query is returning InstructorID where ClassID matches any of the ClassIDs. I want it to return Instructor ID where ClassID matches all of the ClassIDs in the string.
How to set default values for selection list navigator without using parametrized queries for data source view.
View 2 Replies View RelatedI 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
does anyone have idea How to add folders in SQL 2005
thanks in advance
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
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
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
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
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
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?
In Enterprise Manager, is there a way to group Databases into Separate folders?
View 6 Replies View RelatedI 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?
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
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
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!
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,
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.
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!
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
How can I hide or suppress the 0-values (zero) in a report?
View 8 Replies View RelatedCan 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
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