.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Configure DB connections in SSRS reports

Posted By:      Posted Date: October 11, 2010    Points: 0   Category :Sql Server


Is there a way to configure the DB conenctions in SSRS, like the way we do in SSIS. I am asking this, to take care of moving the code from development to production server,without manually changing the connection.

View Complete Post

More Related Resource Links

Can I configure the default isolation level for all my SSRS reports.


By default connections to SQL Server are made Read Committed. However in a lot of situation this can result on locking of other users when a big SSRS report is executing. Is there a way to configure my SSRS server that it will connect by default with isolation level Read Uncommited to the database.

At this moment you need to specify the transaction isolation level in every dataset of the report. This will result in problems of somebody forget to specify. By configuring this on server or connection level, you know for sure that all reports are executing with Read Uncommitted.

More information about this topic canbe found on my blog: http://www.keepitsimpleandfast.com/2010/11/bad-performance-and-lockings-occur-ad.html



Share Point integrated SSRS reports rendering when access from external site


Our client has a SharePoint (moss2007) site on Windows 2008, SQL2008 R2 Enterprise, and Reporting service is integrated with SharePoint

The authentication on the share point integration is set to windows, else the authentication for the SSAS datasource gives and error

The extranet zone ( forms) and intranet (Customer Forms) and default (Windows) zones are all access from inside the firewall and the reports render in each with no issues, as the datasources are configured to pass a sql username and password.

However, report rendering is a problem from the internet (external site), the following error is displayed:

An unexpected error occurred while connecting to the report server. Verify that the report server is avai

SSRS - Where are the Sharepoint Report Usage Reports provided by Microsoft



Microsoft provided 3 example reports for Sharepoint report usage. Does anyone know where they are located? I used them about 2 years ago.




Printing Issue in SSRS reports

Hi,   We developed around 70 ssrs reports for our new application.Its like,all the report names are mentioned in the left hand side and if we click it,.Net calls the SSRS reports and shows in the Right hand side.   The issue now is with the Printing.My client complains that they are not able to print the Reports properly.Some of the columns are moved to the next page,it seems.Reports are having different number of columns and we dont know how to resolve this issue.Should I use Landscape or Portrait?..If I give the table's width in the place of Report's width,will it work?    Your help would be greatly appreciated.

How should I configure Asp.NET on IIS 6, Sql Server 2005 and SSRS 2005 across 2 Windows Server 2003

I was running a MIS reporting solution on a single server running MS Windows 2003 Server and Sql Server 2005. The solution was built using ASP.NET 2.0 on IIS 6.0, Sql Server DB & SSRS. I now have purchased a 2nd server running MS Windows 2003 Server and Sql Server 2005. What is the best configuration to split the following application components across the 2 physical servers? ASP.NET web application SQL Server 2005 Datawarehouse SSRS Web Applications (Reports & ReportServer) SSRS Databases (ReportServer & ReportServerTempDB) The hardware configuration of the 2 servers are as follows Server 1 MS Windows Server 2003 Enterprise Edition SP2 Intel(R) Xeon(R) CPU 5150 @2.66GHz 16 GB RAM Sql Server 2005 SP3 Standard Edition Smart Array P400 in Slot 1 (SAS Array A with Spare / SAS Array B with Spare) Drive C: 68.33 GB | Drive D: 273.40 GB Server 2 MS Windows Server 2003 Standard Edition SP2 Intel(R) Xeon(R) CPU X5570 @2.93GHz 4 GB RAM Sql Server 2005 SP3 Standard Edition IBM ServeRAID-MR10i SAS/SATA Controller Drive C: 135GB | Drive D: 556 GB | Drive E: 271 GB Any suggestions would be of great help

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

Converting crystal reports to ssrs reports

Hi, I need a documentation which helps me to convert crystel reports to ssrs. if any one having the procedural documentation you can email to my below mentioned email address that will be helpful to me in my new starting project. naveenjustlikethat@hotmail.com

How to programmatically hide SSRS reports

I've built a process to deploy several reports to SSRS in either native mode or SharePoint integrated mode.  I'd like to programmatically hide several SSRS reports when deploying them to a sharepoint site.  I believe I need to do something like this -  http://www.mssqltips.com/tip.asp?tip=1357.  Any pointers?  I'm new to SharePoint development. Thx.

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

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

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?

Building SSRS reports based on SharePoint 2007 lists

Hi,   I'm building a SSRS report, and I want to get data out of a SharePoint 2007 list. The difficulty I'm facing is the following: The SharePoint server is behind an ISA Server, and is configured for Form-Based Authentication. Is there a way to keep the FBA and retreve information out of a SharePoint list with reporting services?   Kind Regards,  AVermaas    

Configure Synchronization connections with PowerShell (User Profile)

Hi, I was checking the Pshell cmdlets for SPS2010 and wasn't able to configure the sync connection after creating the User Profile SA. Do you know if it's possible to configure this part (AD, filters, etc) in PShell ? Is it done using the "SetupSynchronizationService" method of the User Profile Service Application object ? Thanks ! Wes  

Migrating from Crystal Reports to SSRS

Hi, we are currently evaluating SSRS and its features for making a decision on migrating from Crystal. I have read up on SSRS a bit and just need some confirmation on some of my findings. My company develops Windows applications, distributable via MSI files. The backend is SQL Server 2008. We are currently using Crystal Reports to display reports to the end user using the Crystal .NET viewer control. Crystal Reports are saved as .rpt files and contained in the msi file, therefore deployed to the clients. As we are considering migrating away from Crystal, I had a look at SSRS. It is my understanding that there are two ways of using reports: First, in local mode, which is similar to the way Crystal works: Client-side deployed report files. However, unlike Crystal, the application has to retrieve the data for the report from the database and pass a dataset to the viewer control whereas in Crystal, you just point the report viewer to the database you want to use and it pulls the data itself. The other mode, remote or server mode, has the reports stored in the report server (i.e. SQL Server). The viewer control will be set to the URL of the report, and the report then pulls the data from the SQL database. I am unsure to how you could deploy reports onto the Report Server using a MSI package; it sounds like quite a bit of work as the only way I have found by now is to consume webs

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?

SSRS generic template creation for variou reports

Hi I am new to SSRS and most of the reports I am developing are having the same header and footer, Please advice the possible ways I could reuse the template and the background color for header, footer and the tablix that I am using in new reports I develop. I am a newbie so sorry if I am asking an answered question. Thanks for responding.

pass Drop down selected value to Texxtbox in SSRS Reports

hi, i have developed a ssrs report which as Two dropdown as parameter first one is used to select the Starting year second one is used to select the ending year based upon the selected value a table will retreive data's Above the table there s textbox which is used to give message as "Project From year 2006-2007 " this 2006-2007 must be the dropdown selected how to do this? Thanks, Saraswathy

SSRS Reports

How to merge Two columns, ie, one under another in ssrs reports.?Pls help.  
ASP.NetWindows 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