Post New Web Links

SSRS 2008 SP1 - Enabling "My Reports" allows users delete reports in folders they should not be able

Posted By: Posted Date: September 02, 2010 Points: 0 Category :Sql Server

Issue: Users that have “My Reports” SSRS Role assigned to them can delete reports in other “shared” folders. My understanding was that they will be able to do the tasks specified only in the “My Reports” workspace not everywhere. I have “My Reports” enabled via SSMS. Users have “My Reports” role assigned to them at the root level. My SSRS Role “My Reports” has only the following tasks assigned: 1. View Reports 2. Manage reports 3. View Folders 4. Manage Folders To test, I'm using Development version of SQL Server 2008 SP1. Thanks in advance, Martina

View Complete Post

More Related Resource Links

Schedule reports with integrated authentication SSRS 2008

Hi All, Having an issue with SSRS 2008 at the moment, trying to setup subscriptions. Our system is configured so that any one of 10 users can login to the SSRS website using their windows domain account, and then launch report builder to design and save reports. This all works very well, however, they have a problem when trying to setup subscriptions - the famous "Subscriptions cannot be created because the credentials used to run the report are not stored....." What the message says is true - the credentials are not stored as they are supplied by the user when they login to report builder. Is the /any/ workaround at all that doesn't involve storing the credentials? It seems totally crazy that they cannot be prompted for them when setting up the subscription. For this application its 100% essential to make the user provide their credentials when running reports, because they each see a filtered subset of the data in the report model (this is controlled DB side depeding on the login account), so their domain account needs to be passed to SQL server to enable this filtering to work. If we saved their credentials then they would see all the data..and thats nasty. The only workaround I can come up with would be to create a separate datasource for each user and upload a separate model, but thats really nasty to be hones

Where are the 2008 SSRS sample reports?

All the CodePlex 2008 links now go to the 2008R2 examples. Are the 2008 report samples still around somewhere?

SSRS 2008- redirect to /Reports virtual directory?

We have just configured a new SQL Server Reporting Services 2008 server. So far, everything is going well, with the exception of one thing: we want anyone who hits the root of the webserver to be redirected to the /Reports virtual directory. So, if the user enters http://servername.domain.com/ it would redirect to http://servername.domain.com/reports.ÃÂ In SSRS 2005, it was easy to configure IIS to do this, but with SSRS 2008, I cannot figure out how to make this change. Help?

Are there workarounds for SSRS 2008 Reports that have issues in SSRS 2008 R2

We have some SSRS 2008 reports which have a few issues in SSRS 2008 R2: - Page Numbering: Our reports use [PageNumber] of [TotalPages] however, in R2 [Total Pages] only relates to a particular section. Do we really need to update every single report in design mode to use [OverallTotalPages]? Is there a workaround? - Report Rendering: Each page of a report is only rendered when each new page of the report is requested. How do we prevent this is R2? - Missing Data: If we run a report that should have 50 pages of data, not all pages are shown when viewing the report. For example, only 2 pages might show. However, if we export to PDF the whole 50 pages are exported. Does anyone know why this is happening? Looking for patches, workarounds, etc. Hoping that we don't need to upgrade desktops to R2 and edit hundreds of reports to fix these issues. Thanks, Howie999

SSRS 2008 Against OLAP Cube reports rendering slow in IE 6 and IE8

We have SSAS cube built on SQL Server 2008 that has multiple parameters that have a default vault on running of all. The first time we run the report it renders the report in less than 30 seconds, but when we change one value on the data cube pull the reports can take up to 5 mins to run. If I do the same report in Firefox 3.6 it renders the report in 30 seconds. I have change changing the cache size in the IE explorer and ave the latest .net frame work on the computer. What would be causing this issue? The company upgrade from SSRS, SSIS, SSAS, SQL 2005 to 2008. Please advice, this is very annoying for our business end users. Thanks for your help in advance.

Deploying SSRS Reports from Visual Studio 2010 to Report Manager 2008

Our Report server is using Report Manager 2008. Previously I would load reports to it that I created via BIDS. Now I have to use VS 2010. I see that I can build and deploy reports there. Can I send it from VS 2010 to the REport manager 2008 on the other machine? I should add that now i have to develop on laptop only before i was on the server.

If not what are my options? I recall that vs 2005 objects were not taken in Report manager 2008.

SSRS 2008: Multiple Sub-Reports with conditional visibility in one List control

MainReport: a List containing two Sub-Reports. The data of the List only has two rows. Set the visibility of the sub-report based on the data.

SubReport1: a textbox showing "Sub Report 1"

SubReport2: a textbox showing "Sub Report 2"

I expect to see SubReport1 in Page 1 and SubReport2 in Page 2.

But I only see SubReport1 in Page 1 and Page 2 is a blank page.

These reports work in SSRS 2005, but not in SSRS 2008.

Thanks.

Report Definition:

MainReport.rdl:

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner

SSRS 2008 - email subscription - 7 minute delay between two reports emailed out (normally less than

We have a report subscription that emails out through a 3rd / separate smtp server.

I was watching the progress on the report server subscription page (where it shows executing, x of y completed, 0 errors) and noticed a long pause between updates about half way through the subscription.

It sends out around 500 emails and email 475 of 500 was still on screen after a few minutes (it hadn't ticket up to 476, or 479, etc...)

So I quer

Is SSRS 2008 capable enough to be a solution for generating really huge reports?

Hi All,

I have been doing performance analysis for SSRS 2008 for some really huge reports that return between 1 to 5 million records (with single user) and reports that return 100K to 200K records with multiple users. I have observed lot of issues which made me to think that may be SSRS 2008 is not good enough for such a huge reports even less good if there is a multiple users scenario for those big reports(though I wanted to use it). Please go through my points and share your views on this.

Before putting up the points I would like to mention my configuration, Windows Server 2003 Enterprise Edition R2 SP2 64 bit (totally dedicated to SSRS reports as the data source for these reports was SQL Server 2005 Enterprise Edition), Microsoft Reporting Services 2008 R2 64 bit, 8 CPU, 8 GB RAM and the reports are simple tabular reports which are fetching the data from a single table (no joins)

Authenticated, when deploying the reports(SSRS 2008) to a sharepoint site

I created reports in SSRS 2008 for a sharepoint list. But when I tried to deploy it to the report library I used to get an authentication pop-up box again and again. I used all the username and password. But no luck. Does any one knows how to overcome this situation.

ssrs 2008 reports Datasource error in Test server..

Hi ,

i Have upgraded my Reports from Report server VS 2005 to VS 2008 .

My reports works fine in local, development & test server.

After Ugrading to 2008 it works fine in local server & devlopement serverr.

When i deployed to Test server i am trying to access my reports i am getting below errors,

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors ..

i checked the Datasource conncetion properties..its pointing to correct Test database only..

My reports are windows integrated...

Now it works in srs 2005 developement & test server. For same properties it works in dev server, it doesn't works in srs 2008 test server.

Why? Can anyone give me some idea...?

Unable to deploy reports from VS 2008 to SSRS 2008

I have a server that has SQL 2005 and SQL 2008 installed. At one point, I was able to deploy reports from VS 2008 to SQL 2008, but can no longer do so. Any ideas what could have changed that prevents the deployment? Should I remove SQL 2005, as it's not being used on this particular server?

How to delete "Users Folders" from the Home...

Hello, all. I recently had to rebuild my Reports Server. Luckily I had all reports, data sources saved in a Viz Studio project so I just redeployed. My question is how do I delete this annoying "Users Folders" link from the Home folder. Clicking the "Users Folders" link, I see additional folders of the few users I have. I'd like to delete the Users Folders link altogether from the Home folder. However when I attempt to delete a folder or multi select and delete all of them, I get an error "The permissions granted to user 'SAWS\rhall' are insufficient for performing this operation. (rsAccessDenied)". I believe I am an Administrator on this server...or at least I should be. Can anyone help?

Thanks in advance folks,
Roz <

merging reports ssrs 2008

how can i display barchart and linechart in a single report by using ssrs 2008

Reports referencing .NET Framework 4.0 fail to upload to SSRS 2008

We are running SSRS 2008 on a 64-bit Windows Server 2008 SP2

When attempting to deploy a report containing a reference to a .NET Framework 4.0 assembly via the Report Manager, we get an error.

For example, when deploying a report referencing System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089, we get the following error:

Error while loading code module: ‘System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089’. Details: Could not load file or assembly 'System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified. (rsErrorLoadingCodeModule)

The same report deploys correctly in a development environment (Windows 7 64-bit, SSRS 2008).

The Win2k8 server has .NET Framework 4.0 installed and is fully patched.

Is there a strategy for troubleshooting this issue?

Thanks!

David

How to use ssrs gauge in my reports? Please provide some example as the description on MSDN is too l

Hi could any one provide an example of using the gauge in ssrs reports. I have a reqirement to show in one of my reports. Thanks a lot in advance.

Multiple reports straight to pdf (SSRS 2008)

Hello, I have successfully written code to generate a server report straight to a pdf document. I did this using Report.Render(...) and then writing the result with Response.BinaryWrite. This works fine. The thing I would like to do now is this: On the webpage the user sees a tree with about 20-30 reports on it. I would like the user be able to select which reports he wants to see (using the tree check boxes) and then when he hits print one pdf document is generated with all the selected reports on it. Any suggestions? Thanks.


Categories:

ASP.Net	Windows Application	.NET Framework	C#	VB.Net	ADO.Net
Sql Server	SharePoint	Silverlight	Others	All

Hall of Fame Twitter Terms of Service Privacy Policy Contact Us Archives Tell A Friend