Changing The Temporary Folder Being Used By Reporting Services

Dec 19, 2007

Hi everyone!

I have a problem regarding the generation of report using SSRS (SQL Server Reporting Services). As I've read from other forums, the said service need access to the Windows temp folder, which by default, is found in C:WINDOWSTemp. The said path is found in either the TMP or the TEMP environment variable.This means that there should be sufficient access to this folder, in order for SSRS to properly generate the report. The problem is that my client, for security reasons, does not want to grant special rights to this folder, using the ASP.NET account. Is there any way that we can change location of the temporary folder being used by SSRS without having to change the value of the TMP and TEMP environment variables? thanks in advance

View 1 Replies


ADVERTISEMENT

Reporting Services :: Cache A Temporary Copy Of Report

Jan 19, 2011

I have a report whose parameters are limited by the user who is logged in. Ex. if a user had full access they would see all 100 hospitals in our hospital parameter, if another user had limited access they might only see 5 - this will vary largely on who is logged in. The data source that drives these parameters are set as follows:

Credentials stored securely in the report server, username and password are entered and Impersonate the authenticated user after a connection has been made to the data source is checked.I now want to cache this report for X minutes. So I goto Properties/Execution and select 'Cache a temporary copy of the report. Expire copy of report after a number of minutes'.

Applying this gives me the error: Credentials used to run this report are not stored.

View 6 Replies View Related

Reporting Services :: Cannot Modify Folder Permissions

May 21, 2014

We have a SQL 2012 SSRS instance. We need to modify the permissions on one of the reporting folders. I went to the Security setting of the folder, clicked "New role assignment", then entered a group name into the box and selected desired permission ("Browser" in this case).

However this always fails with the same error: "The user or group name 'BUILTINBUILTIN' is not recognized. (rsUnknownUserName)"

I always get the same error no matter if I enter user or group, domain or local. And it always says BUILTINBUILTIN. I've tried changing the SSRS service account to a domain account (it was a local one), but that didn't work.

View 3 Replies View Related

Reporting Services :: SSRS Using A Shared Folder

Sep 4, 2015

I am trying to create a basic report in SSRS, with 6 columns but then we receive an excel spreadsheet with different account numbers daily and I am requested to create a report based on those account numbers. so how can I create a shared folder for the users to drop their excel spreadsheet  there and make my SSRS only filter the result set based only on those account numbers?

View 5 Replies View Related

Reporting Services :: Navigate To Report In Different Folder

Sep 14, 2015

I have multiple reports, in multiple folders, that have fields in them and those fields are set to Navigate to the same report. I'd like to store a single copy of the report being navigated to in one hidden folder.

Example
Report "Inventory Value" in folder Accounting has the Item Number field set to navigate to the report "Item Details"stored in folder Linked Reports
Paths
//ReportServer/Accounting/Inventory_Value
//ReportServer/Linked_Reports/Item_Details

Is there a way to do this?

View 5 Replies View Related

Reporting Services :: Change Home Folder Name?

Oct 1, 2015

Can we change the name of the "Home" folder to something else?  We have 15-20 instances of SSRS, and it would be real useful if I could display an instance name vs. "Home".

View 4 Replies View Related

Sql Server Reporting Services(folder.aspx)

Mar 27, 2008

Hello All,

I would like to edit the Folder.aspx, or mainpage.aspx file in sql server reporting services.
for example instead of showing sql server reporting services on the top of the folder.aspx page, shows Testing ...

Thanks
Mona

View 3 Replies View Related

Reporting Services :: User Folder In SSRS 2012

Jul 13, 2015

There's a new SSRS 2012 environment which was setup with My Reports folder to each user enabled. I know I'm supposed to see a Users Folder in the Report Manager root, I'm setup as a system administrator (under Site Settings) and also have content manager rights in the root directory and I still don't see the "Users Folders" ...the only way I can see that is if they give me admin rights in the server SSRS is installed. What am I missing here, is this supposed to be like that?

View 5 Replies View Related

Reporting Services :: Migrate Single SSRS Report Folder

Jul 30, 2015

I have old sql server 2008 with reporting service and new one 2012 version and I need to move single report folder from old server to new server. Is there any tool or script can make that possible.

View 5 Replies View Related

Reporting Services :: Access To Only One Folder Among 10 Folders On Home Page?

Sep 10, 2015

I want to give the permission to a user to view only one folder among 10 folders on Home page of report server. I don't want that user to view other folder than his/Her Own folder on report server home page.

I went through the below URL but it didn't work.

[URL]

View 10 Replies View Related

Reporting Services :: Data Source Account And Folder Access

Apr 28, 2015

I have a question about ssrs security. In report manager I have set a list of users as browsers, and the builtin administrators are content manager in the parent folder where reports are. A user that is not an administrator and neither a user I added, has access to reports.

I'm thinking this person is having access because the data source of the reports use a administrator account to connect to the analysis services  using the option Credentials stored securely in the report server with the 2 checkboxes marked (use as windows credentials when connecting to the data source and impersonate the authenticated user).

I simply marked this option because SSRS is in 1 server and SSAS in other and I think kerberos need to be configured and I haven't looked into it, but I think the report access is separated from the data source.

View 2 Replies View Related

Reporting Services :: How To Make New Directory (folder) In Which To Save New SSRS Report

Sep 17, 2015

When I go to Save As Report it doesn't allow me to create a new directory (folder)

Here is where the directory (folder) needs to be created: gdgdb01preportserverProduction.

Where can I create this directory (folder)?

View 4 Replies View Related

Reporting Services 2005 - Giving Access To All AD-users For A Specific Folder

Jan 21, 2008

I am in a project where we are using a vanillla Reporting Services 2005 with the builtin report portal. No sharepoint integration yet.

We have successful deployments where we limit access to different folders based on AD-accounts and groups. In this particular case I have a folder for which I would like to allow access to all AD-users within the entire company.


So basically I know how to limit access but I don't know how to enable access for everyone. Is there a simple way to do it? I have googled and search mshelp but I couldn't find anything. I will admit to the search being quite quick but as usual time is short.

View 1 Replies View Related

Changing How Reporting Services Looks.

May 7, 2008

Is there a way to change the main reporting services looks. For example, can i change the font? Can I add a logo? Change the color?

View 1 Replies View Related

Changing The Currency With Reporting Services

Sep 27, 2007



Hi,

I am formatting a currency field within reporting services using an expression. However i get the $ sign. I need the £ sign. How can i change this?

Thanks

David

View 1 Replies View Related

Reporting Services :: RDLs Present In SSRS Folder Path But Not Visible In Report Viewer URL?

Jun 9, 2015

I have an issue as to where only some reports are visible within Report Viewer url. But if I navigate to the path of the rdl's there are many more present that should be visible through Report Viewer. The client was recently upgraded, and I seem to have all out of box roles and permission levels yet can only see some of those reports, as if some were manually copied to this folder location at a later point and perhaps some user job needs to be run to reflect import those additional rdl's?

View 2 Replies View Related

Reporting Services :: SSRS - Auto Generate Multiple PDF Files And Save Into Window Folder?

Jul 15, 2015

We have the following requirement :

1. In daily basis auto loop through each item in the invoice table.

2. passing invoice number into a Summary SSRS report as parameter.

3. Auto download ALL generated PDF reports into a window folder with a special file name format i.e. <INVOICE_NO>_<DATE>.pdf

how to achieve this via SSRS, Store Procedure or Power Shell?

View 4 Replies View Related

Reporting Services :: Unable To Show Images From Folder By Reading Path From Database In SSRS Report

Apr 28, 2015

Basically i have 3 images capacity per record in my asp.net application. In there i am saving the image path with record id in database and image in my application folder.

Now i am creating SSRS Report in Report builder . In there i have taken one image control to show the images. In the Image properties in report builder i have chosen database under the select the image source field. then inside use this field i have chosen image url and in use this MIME Type i have selected image/jpeg. Now i have saved this report in report server folder.

Now while calling in .net web from through report viewer control. It is opening the report but wont showing the image.

View 2 Replies View Related

Reporting Services :: Changing Date Format In SSRS

Nov 5, 2015

Fields!TaskStartDate.Value &  Fields!TaskName.Value & Fields!StatusForExecutiveReporting.Value & Fields!NotesForExecutiveReport.Value

This is my expression in a cell.when i run my report  task start date value is something like the:

01/25/2015 8:00:00AM.

I want this date to be in this form: jan 2015

View 3 Replies View Related

Changing Cube Dimension Filter Via Reporting Services

Apr 27, 2007

Hi all

sorry im new with using Reporting Services and even more inexperienced with using cubes.

My situation is as follows. I perform dynamic grouping (user selects the view via a parameter) Depending on the view selected, I need to change the dimension filter in the dataset.. Is this possible ?


Regards,
Neil

View 5 Replies View Related

Changing To Design View Of A Reporting Services Report File

Nov 13, 2007

When I am working on an Integrations Services project and I open a Reporting Services file, it displays it in the Code view. Is there a way to display it in the Design view? Or do I have to close the project and open up a Reporting Services project?

Fred

View 1 Replies View Related

Integration Services :: SSIS WMI Event Watcher Check For New Folder In Existing Folder

Jul 2, 2015

I know a WMI event watcher can be used to watch for a new file being added to a folder. However, I need to check for new folders being added to an existing folder. I haven't been able to find a post on doing this. Is there a way in WQL to check for a new folder being added instead of a new file? I've used SQL for years, but am new to SSIS.

View 2 Replies View Related

Reporting Services :: Changing Credential Used For SSRS Data Source Programmatically

Jun 15, 2015

I am looking command (cmd/powershell/c#) for setting/updating credential for SSRS data source.

View 2 Replies View Related

Error Received In Sql Server Reporting Services Configuration Tool When Changing Encryption Key.

Nov 6, 2007

I've SQL Server Reporting Services 2005 configured on my system, but now I'm NOT Able to start the report server. I get this error on http://<serverurl>/Reports/Home.aspx:

The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) (rsRPCError) Get Online Help

The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled)
Key not valid for use in specified state. (Exception from HRESULT: 0x8009000B)

I don't want to loose any data. Please help me resolving this error.

FYI, I've modified the SQL Reporting Services account LogOnAs info, in Properties of "SQL Server Reporting Services (MSSQLSERVER)" Service, in Windows Service Managment.

Earlier I had .useraccount as username, I modified it to domainnameuseraccount. And then suddenlt everything broke for reporting server.

View 4 Replies View Related

Reporting Services :: Open URL In SSRS Report In New Window While URLs Keep Changing In Every Record

Jun 29, 2015

I want to be able to open URLs in a new window in my SSRS report, and the URLs keep changing in every record. The problem is these links are not the only things present in the record, and there is other data present. I keep seeing examples where they are considering only a link to be present in the record with no other data.

Also the data in the record includes HTML tags and I checked the option that says "HTML - Interpret HTML tags as styles" on the placeholder properties window.

Example of data in the record:
Hello! Welcome to google, the most used search engine.
Click on www.google.com to go the website

So when I click on the www.google.com URL, it should open in a new window. 

View 2 Replies View Related

Reporting Services :: Set Data Source In Report Manager For Whole Folder Rather Than Each Report?

Aug 28, 2015

I have few reports under different folders in Report Manager. Is there a way to set the data source for the whole folder rather than each report individually? There is also a folder where reports generate dynamically. Since the report project doesn't exist anymore, I can't set the data source through code. How can I set the data source for the whole folder?

View 7 Replies View Related

Changing The Default Drive And Folder For DB's

Nov 21, 2006

Hi;I feel like an idiot to be asking this,but how do I change the default drive and folderin which new databases are created?I've been looking all over Server Mgmt Studio,and I can't find anything. I'm thinking that someonecan tell me this off the top of their heads,or slip me a link to a web page.Thanks, 

View 2 Replies View Related

Changing Folder For Databases To Reside In?

Aug 11, 2005

Can I change the folder that the databases reside in for my installation of SQL Server?  I would like to have them in a folder on another drive, but I can't seem to find where the path is configured.Any help is appreciated.

View 4 Replies View Related

Changing HOME Folder Per User

Jun 18, 2007

I am wondering how I could do the following -

Right now the default folder is Home, what if I have two users User1 and User2, my folder structure is the following -
Home/User1
Home/User2

I want each user to only have access to their folder. That is easy to do.

Once both users have proper access to their folders they still don't have access to Home folder. In Report Builder when I do 'open file' it defaults to Home folder so I get an error. How can I specify the home folder to be User1 for that user and User2 for the second user? I know I can give them both browsing permissions to Home but it's not very elegant.

There must be a way to programmatically change the folder as soon as proper user logs in. Anyone knows how to do that?

Thanks.

View 9 Replies View Related

SQL Server 2008 :: Changing Alt Snapshot Folder For Merge Replication?

Sep 22, 2015

I have a merge replication. Currently works fine. Publisher & Distributor are on the same server. I need to change the location of the alternate folder for the snapshot files.

I’ll probably just change it through the GUI, but would I use sp_changedistpublisher or sp_changemergepublication if I were scripting everything?

My real concern is the subscribers. Do I have to ‘tell’ the subscribers where the alt folder has been changed to? Do I just run sp_changemergepullsubscription on the subscribers?

View 1 Replies View Related

Reporting Services :: Parsing SSRS Config File And Dynamically Changing File Path Of Config File In Code

Sep 2, 2015

Currently have a single hard coded file path to the SSRS config file which parses the file and provides the reporting services web service url.  My question is how would i run this same query against 100s of servers that may or may not share the same file path as the one hard coded ?

Is there a way to query the registry to find the location of the config file of any server ? which could be on D, E, F, H, etc. 

I know I can string together the address followed by "reports" and named instance if needed, but some instances may not have used the default virtual directory name (Reports).

Am I going about this the hard way ? Is there a location where the web service url exists in a table ? I could not locate anything in the Reporting service database. Basically need to inventory all of my reporting services url's.

View 2 Replies View Related

Migrate From 32bit 2000 Reporting Services To 2005 64bit Reporting Services

Mar 22, 2008



Hello,

I am trying to migrate my reports from SQL server 2000 reporting services 32bit to 2005 64bit. I am following the migration steps that MS specified.
Restored my Reportserver and ReportserverTempDB databases
Then I was using the configure Report services to upgrade these databases but I always end up getting the follwoing exception when I run the upgrade on the "Database Setup" configuration for 'ReportServerTempDB' database
System.Data.SqlClient.SqlException: Could not locate entry in sysdatabases for database 'ReportServerTempDBTempDB'. No entry found with that name. Make sure that the name is entered correctly.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script)
at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)

It's driving me crazy, why is it looking for 'ReportServerTempDBTempDB' in the catalog instead of 'ReportServerTempDB'?
Is it possible to migrate from 32bit to 64bit?

Any help is appreciated

View 1 Replies View Related

Cannot Add A New Folder Under A Reporting Server Project

Apr 11, 2007

Hello,



I was just wondering why is there no option to add a new folder under a reporting server project. I have a reports project and under it i would like to add subfolders like Daily and Weekly just to make it more organized. I understand that during deployment, we can specify to which folder we want the report(s) to be deployed, but what is the reason behind not having an option to add a new folder?



Thanks,
maui

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved