I have two servers, one being the SQL server with RS db, one being the webserver with reporting services on it. I want to replace this webserver slowly by installing reporting services on a new server but at the same time being able to access the reports on the old server until we take it off...more >>

Hi, I am using DateTime parameters for SQL 2005 Reports that are converted from SQL 2000. The report works fine for me but my client complains that the Datetime pop-up does not come up always on clicking the date button. It comes up but at times after 3-4 clicks. Any idea as to why ...more >>

Is it possible to create a Report Model based on a mySQL server? i am getting errors: ERROR [42000] [MySQL][ODBC 3.51 when connecting. Ihave been able to write standard reports but am running into this issue. Also I was looking into using the DotNet Data connector but cannot figure out how to ...more >>

Hello, I have developed a web application that uses ReportViewer Web control supplied with VS 2005 RTM version. The ReportViewer control uses Network credentials to connect to a remote SQL 2005 server to get the reports. It works fine for reports that doesn't use any parameters. But, for the ...more >>

How can I create a VB.NET function to run my query below that my SSRS report can run to retreive TotalPostingDays so I can show that in a textbox in my report? I need help creating the function in the Report properties of my SSRS report and not sure how to call this stored procedure to return T...more >>

can the custome security extension for forms authentication use ssl?...more >>

At first glance, this appears to be a bug in Reporting Services... I have a 2005 cube with a Scenario dimension. On the Scenario attribute I set IsAggregatable to False (since it doesn't make sense to add Actuals and Budgets). This effectively removes the All level, as I understand it. I've ...more >>

This feature is very annoying, report service 2k rewrites my query, even the format of query is changed too. How to disable this feature? Thanks really a lot. ...more >>

Hello Does anyone know why the Home page of the reporting services displays ALL the reports to ALL the domain users? I would like to set the site so that I can restrict or not the users to see the reports. Thank you so much in advance...more >>

Hello all, does anybody know the format code for upper case field formating? I.E. in MS Access it's the greater sign ">" and turn all the fields text to upper case. Thanks....more >>

So I'm trying my first Report project from Visual Studio 2005 and I get a good connection string and run the project. When I run it it tries to deploy to http://localhost/reportserver, and asks for a login and password. But nothing works. I don't even think I have a password set up for reporting...more >>

Everytime I use VS.NET 2005 to Author Reports the IDE Crashes. It crashes when I click Exit, it crashes when I uses the Query designer, I fully expect it to crash everytime! Anyone else see this happening? Any one know why it crashes all the time? ...more >>

Hi all, I need a certain functionality in my Reporting service report. I need a report with 4 levels of grouping above the detail level. The initial visibility of all the lower levels should be hidden expect the top most level. For all the levels toggle item is set in the group properties...more >>

I have a table(No.1) with several groups. I have inserted another table(No.2) in one of the groups footer. Both tables have the same DataSet as source and groups with same Column. Everything works fine except that the Header and Footer, for table2, will not be rendered. I have hardcoded val...more >>

Hello, I have a SBS2003 running with SQL Reporter, and I want to try and get it to email to the excahnge server (on the same box) the copy of the report. Can anybody point me to what the settings should be in the RSReportServer.config file? At the moment, I am emailing it out to my yahoo ...more >>

I am trying to build my dataset WHERE clause with the IIF function. I have 4 parameters that include a "ALL" option and that is what I am trying to cater for. Have done is successfully when there is only one parameter involved, IIF (Parameters!Rep.Value = "0", " WHERE A.Region = '" & Parame...more >>

Hi, Would be interested to hear your thoughts on whether is best to minimise or maximise the use of stored procedures in SQL Reporting. Is it best to have as much as possible coming from Stored Procedures or is it better to have as little as possible. At this stage I am more concerned abou...more >>

Does anyone have any good examples of programmatically creating subscriptions using the SQLRS web service ? rgds, Jay ...more >>

Hi, This question pertains to Reporting Services 2000. As per http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_dbadmin_v1_98xh.asp, after doing a rskeymgmt -d, I need to perform 4 steps. I understand 1. 2 and 3 in the article. Can someone help me with the 4t...more >>

I have a need for some query help and I will try to explain my situation. Thanks in advance for any help. I have an Excel spreadsheet that has two different sheets. One one sheet called "Data" I have created a query that pulls AP Invoices from from a SQL database. In the results of this q...more >>

Is this possible. To explain myself, here is my situation. I created an Excel Spreadsheet that uses an ODBC link to a SQL database. In order for anyone to use this file on their PC, that same ODBC link must be setup. Is their some code I can use within a Select Statement that will allow me...more >>

We had to change the administrator password recently. So I took the opportunity and created a sql user (yes.. it is domain admin) and moved the sql and reporting services to run under this user instead of administrator. Since this time, my report server doesn't send out the reports via email. ...more >>

Hi everyone, My name is Ed Allison. I am very new to reporting services (about 2 weeks, in between working on a lot of other stuff), and have had no luck attempting to track down a particular problem. I am running Visual Studio 2005 and Reporting Services 2005 on Windows XP (fully servi...more >>

Hello, I have read in a number of Powerpoint presentation from MS folks that we have the ability to implement floating headers and/or column, similar to freezing panes in Excel. Could somebody please point me to the article/link that explains how to implement this? Thanks in advance ...more >>

Is it possible to reference the same report from two different directories? Please advise. Thanks, Scott A. Baker OraSure Technologies, Inc. ...more >>

I'm porting an ASP.Net report(s) to SSRS. I have an sProc that returns meta-data about the result set in table(0) and the actual data in table(1). How do, or can I display table(1), the second table in my result set? TIA JeffP.... ...more >>

I've got a table with a header, group, and detail row. The detail row is collaspable however when it's collasped there is several lines of white space between the parent groups. How do I get rid of this white space? Thanks in advance for the help ...more >>

I have a report with multiple prompts. Every prompt based on separate stored procedure with default value "All". If I'm running it via Report Designer everything works fine. However, if I'm trying to run it via Report Manager only one prompt display default "All" , all other prompts do not hav...more >>

I have a report called Report1 that has 1 parameter called Parm1 and there are 296 choices for Parm1. Is there anyway to create a batch job to run this report for all 296 choices and send to .PDF? ...more >>

I have Department group and want to count how many distinctive customers we have in each of them: I placed this formula in group footer :=countDistinct(Fields!Customers.Value,"Department") but it shows me total number of customers in each row. Oleg ...more >>

How do you mange to create checkboxes on your reports? Since there is no builting support for checkboxes, I have tried using: Windings font: =IIf(Fields!MyBooleanField.Value=False,ChrW(&h006F),ChrW(&h00FE)) that would give me the empty square and the ticked square (when previewed in dhtm...more >>

I get the following error when i try to acces to the reporting services web site. Attempted to load a 64-bit assembly on a 32-bit platform. Use ReflectionOnlyLoad() instead if trying to load for reflection purposes. I have no idea of the source of the error (it is really a 64 bit edition o...more >>

Where can I check to see the default references set for an SSRS report? In a standard VB project I have a references item if I right click on the solution. In a standard VB proejct I can also use the Object Browser and view the MySolution item. The reason I am asking is I was playing around...more >>

How to disable a report caching with 100% guaranty??...more >>

We are using SQL2000 with Reporting Services 2000. I would like to be able to use Visual Studios 2005 to create my reports. After creating the reports and uploading the report to Reporting Services2000 we get the following error: The report definition is not valid. Please verify ...more >>

I am having a problem with Reporting Services. I had installed the developer edition on my system and everything was working fine. Next day, turned my system on and the report manager no longer responds. I can't access any of the reports I had developed...nothing. I am a newbie at repo...more >>

the isue is Report Builder, when i am deploy the progect is work fine and i receive "Deploy Succeeded", but when i am trying to click on he report builder i received "authentication error"......more >>

Is there a tool to convert existing RDL files to RDLC. ...more >>

I am trying to create a Reporting Services project in Visual Studio 2003. I am using SQL 2000 SR4. When I try to add a new project in VS I get an option for VB project, Setup and Deploy, and Other projects, but not the Business Intelligence Project folder that it shows in the book I am usin...more >>

I'm new to Reporting Services 2005. My question is this. Say I create a report that retrieves data from database "xyz". Assume also that identical copies of database "xyz" (identical in schema, not in the data it contains) might be sitting on many different servers, servicing different clients...more >>

I need to improve the sql setup at my current location (long term contract) Currently there are 100+ msde installations (1 gb average running a retail back end processes) Backup to disk and tape locally only. 10+ other servers Running HQ apps including Accouts, Payroll, Credit Control, ...more >>

I am trying to install Report Designer on my XP development machine. We already have Reporting Services Enterprise install on our SQL Server. When I insert the CD it automatically attempts to install the Server components and fails becuase it is an XP machine. I only want to install the cli...more >>

Hi all, Why we are using XSLT and XSD for the reports generated thru reporting services. Can any one suggest me any sample application which guides me about how to use XSLTs in a report which generates report for a web applications. -- Vishnu...more >>

Hi All, I am running setup.exe (RS 2000 Enterprise), and ran issue during the following step - "specify credentials that are used at run time by ReportServer service to connect ot SQL Server Instance..." I am connecting to remote databases. I am providing the right credentials but it i...more >>

I have a matrix where the detail cells are set to navigate to a subreport. However I *don't* want them to provide navigation if they're in a subtotal row or column. I can't figure out what to call in order to determine whether the cell is a subtotal or not. Any ideas? ...more >>

Hi gurus, I'm using RS2005, and have this problem: I have one main report, it looks like this; [] are subreports: [title] [analysis 1] .. .. .. [analysis 100] [end title] now, in "analysys xx" I have 1 table. On parameter ID I show only those reports I need to. When I export whol...more >>

Hi, I'm developing a report that calls a web service using a custom assembly. I've got the code working in VS.NET, but when I deploy to my local Report Server, I get this: System.Security.SecurityException: Request for the permission of type System.Security.Permissions.SecurityPermission, m...more >>

Hi all- I have Visual Studio 2003 ver 7.1.3008 with .net framework 1.1 ver 1.1.4322 SP1 When I try to refresh the field list, no fields are returned from a stored procedur. My data source is working fine though, it will let me query the database using the ! exclamation mark It just...more >>

Hi, I've implemented the custom authentication provider as prescribed by MSDN documentation. Everything is working pretty much as expected, however, I want to programatically retreive information about the report (such as the datasources, parameters, etc.) I extended a class for RSExecu...more >>

I am getting the following error when I call. Any help would be appreciated. ReportViewer1.ServerReport.Render(format, devInfo, out mimeType, out encoding, out extension, out streamIds, out warnings); Error: "Client found response content type of '', but expected 'text/xml'" below is th...more >>