Hi, My client requires to use SQL server authentication instead of windows authentication while running reports. While report is running OK in Visual Studio and on the intranet it fails on the intranet when I come to work in the next morning. This is the situation which I observed several t...more >>

I have created one report and exported in CSV file. But in CSV file, it shows the Textbox names, table names etc in the first row. i dont want to show the first row of the CSV result. any idea how to hide/Remove the first row? Regards, Vinod ...more >>

Hi, RS2000 was a separate from SQLServer2000 and a free download, only requirement being you must have a SQLServer 2000 lic. For RS 2005 it looks like its bundled up with SQLServer 2005. Must I purchase SQLServer 2005 in order to upgrade to RS 2005, we don't wish to upgrade from SQL2000 just...more >>

Help! I'm using SQL Server 2005 "Reporting Service Configuration Manager" and I can't get past the "Report Manager Virtual Directory" step. The name box shows "<Not Set>", so I click "New...". Enter a new (unique) name for the virtual directory and click ok. The error is always the same:...more >>

I have a report that requires two separate stored procedures. Its a kind of master/detail query, but not quite. Each stored procedure uses the same parameter (down to the name and datatype). Rather than enter it twice I would like to use the first entered value for both procedures. Is it...more >>

Is there something I need to do in the report or on the server to enable URL Access Paramters? The report runs fine and prompts for my single paramter when running via native Reporting Services, but when I add the user-supplied paramter and/or RS commands in a URL (linked and non-linked) in a...more >>

Greetings All: We have a need to store and display rich-text using HTML tags. It appears Reporting Services can not render output with tags. I have found posts more than a year old that confirm this, but nothing more recent - is this still the case? If so, is there any word on including thi...more >>

I am just having many problems trying to call a procedure with multiple parameters in multiple datasets. The proc works fine in query analyzer with each parameter specified. I've got all the fields in each of the datasets, and I've drug them all into the report layout. right now, my rpt is ...more >>

I can write custom code in my report through the "Report -> Properties" dialog. Can this code access any of the report object such as data or Custom Report Items ? What context is this code running under ? I tried to figure it out using reflector and got to a dead end on a internal class...more >>

Hi all, is there a possibility to call a subreport depending of the result of a data-set? For example: IF Field!Rep!Value = "Subreport_A",Subreport_A,Subreport_B. Or can Subreports only be hardcoded? Thanks and best regards, Roland...more >>

I wrote a stored procedure with two paramters, both of which are nullable but both should not be null at the same time... it is either one or the other... if both are null then I return an error from the stored procedure. So now I am making the report to use this stored procedure. When ...more >>

When using VS2003 and Reporting Services 2005, I am met with the following compilation error after creating a dataset then trying to design it: "Version 2.0 Is Not A Compatible Version" I cant drag any tools to the design surface, or add any fields. I have both SQL Server 2000 Reporting Se...more >>

I have a report parameter that can have multiple string values into it. Should I handle formatting the strings with chr(39)'s on the reporting side or in my stored procedure. If on the reporting side how.. If on the stored procedure how?...more >>

I have a function that sets the color property on the font in a table cell depending on whether the percent falls in a particular threshold level. The function works and returns the hex value for the color ( #ff0000, #ffff00, #00ff00 ) and the report renders properly with the font color displ...more >>

We have installed SSL Wildcard cert on the SQL report server and it stopped working after that. We have taken care of modifying the report server configuration files and they look good. But when we try to access the URL: for the report server I get the folloowing error: Server Error in '/Re...more >>

I'm trying to install an instance of Reporting Services onto a 2003 Server. Everything works great until I get to the part where I connect it to a database. I'm attempting to connect it to a SQL 2005 server. I get an error when it trys to "Create A Grants Rights Script." Here's the rest of the ...more >>

I get the folowing error mesage. Make sure the application for the rpject type (.rptproj) is installed. I have tried clearing out the assembly cache and have also installed ReSharper to no avail. Any suggestions? ...more >>

Is anyone else working with the Web based SRS 2005 Report Builder? The one where you design the reports from the web NOT the FAT client version. If so, have you found any resources, training, books, etc.? Everything I've found revolves around the full client and believe me there are major dif...more >>

I am trying to convert reports from reporting services 2000 to 2005. I did not open the solution that contained the reports because I wanted to start fresh with a new structure. I added the projects and brought the existing reports in. My question is, I am findingt the only way to convert the...more >>

On rendering Excel, i want to make a new sheet which contains the RS parameters of the rendering. So, the end user get an XLS data and the input parameters. Is there any way to make this "parameters" sheet ? Thanks Antoine ...more >>

I am developing reports in RS 2005 accessing Oracle data. It works fine as long as I preview my reports in my local Report Designer. But after have deployed my reports to my Windows 2003 EE x64 Report Server, I cannot view my reports. I get the error message "Cannot create a connection to data ...more >>

I'm a bit of a newbie to SRS / CRM3 and have worked through the Adventure Works example http://msdn2.microsoft.com/en-us/library/ms171046(SQL.90).aspx so I can get my head around creating reports. I am already struggling with Dynamic Queries, my first attempt has failed. = "SELECT New_Liv...more >>

Hi, I have a report containing a table like this: -------------------------------------------------------------------------- |=Fields!callRef.Value | ="Problem:" & Fields!callDesc.Value | -------------------------------------------------------------------------- My boss wants me to make "...more >>

Hi! I want initialize my custom assembly using information what user input (Parameters collection)(Later I present values that I calculate using my custom code in same report). According to MSDN articles from OnInit method I can't access Parameters collection. Is there any way to do this over...more >>

Hi everyone, At the moment, my company is looking at ways to offer data hosting to our customers. As far as Reporting Services goes, the current idea is that they would contact a Report Server hosted by us externally. As a result, we are looking at which security options are best and would a...more >>

Hi, ok, here's what i want to do: I want to filter the data a user ist able to access. I'm using SSAS, the data is provided by a Cube. The usernames and security group memberships are dimensions of this cube. Now i want to restrict the data like this: If a user is a Member of "AssetTeamX"...more >>