When a paticular user runs a report, she is getting an error that refers to not having security to the data source. I went to the Report Manager and added her to the properties>security of the datasource. Also, I went into sql and gave her db.readerwrites to the databases. Am I missing ...more >>

Hi Can you pl. help me with something that is supposed to be really simple however it is frustrating us no end. A client needs a reporting services report based on an SSAS 2005 cube. He wants to have only two date filters for the report that are shown in the form of calendars (default ...more >>

I am trying to create a chart using end_date (parameter) as the x-axis. I have set up the category group expression as "=Month(Fields!End_Date.Value)" and this is used for my x-axis. When the report is viewed, it shows January - September, November, December, then October. The end_date is setu...more >>

Can i have multiple Report Server 05 instances on one machine conneting to one remote Sql Database instance. Each Report Server will have its own database in the SQL instance...more >>

Who can help me with SSL and Reporting Services (Reportmanager)? Reportmanager (SSL): >> Unable to Connect to the remote server System information: Server 2003 Std Edition, SQL Server Enterprise, both 64-bit, latest service packs Microsoft SQL Server Reporting Services Version 9.00.3042.00 ...more >>

Well, it seems like I have a few more questions that I usually do :( Is there any way to hide the text without hiding the entire cell? Right now I can set the Visiblity->Expression property to "True" to hide it (?!), but this also hides all the formatting. This is ugly when you have lin...more >>

Hello, I have just installed Reporting Services and was able to figure out pretty much everything, with the exception of using Windows Authentication. As I am an administrator on the machine on which Reporting Services is running, I am able to successfully log in. However, no other account...more >>

Hello, I'm creating a report with a textbox that contains a field from the dataset and some hard text (something like =First(Fields!MyField.Value) & " TheTextPart"). This works, but when I try to do a shift+enter (line feed) I get an error "The value expresxsion for the textbox 'textbox7' ...more >>

I am trying to add a simple table footer to an existing table. I am trying to get a basic understanding of it. For now I have a single row in the footer with constants in each columm. "TestTotal", A, B, C, ... The RepeatOnNewPage is set to "False". When I view the report in "Preview", the t...more >>

Hi, Is there anyway i can use 2 databases in one dataset using named queries ? here is what i want to do select name from database1.dbo.employees union select name from dabaase2.dbo.employees i dont have reportmodel veiew etc. I am using plaing old reporting services 2005. Thanks ...more >>

Is there anyway I can fill the all the defaults for the Report Parameters without having the report execute before the user clicks the View Report key? By default the user has to either fill in at least on report field then click View Report or the Report automatically executes. I need the...more >>

Hey All, Is there a way to find out the number of items selected in a multi-value paramter? I would like to know if the user has selected 1, 2,...n values for a single parameter. Thanks in advance, Michael C...more >>

would there be any issues if i where to install reporting services 2005 64 ed on 64 bit machine with the report database on another server running 32 bit...more >>

Hello again, I found out, that there's a limitation in rendering reports to excel format. The SSRS can only render reports with less than 256 columns! Is there a work around to render reports with more than 256 columns? In my case, it would be also possible to start a new sheet after 256 ...more >>

I am conditional formatting a value as Red if the number has been adjusted. Adjusted is a bit field (1=adjusted). I am using the following expression on the Colour property of the Data field. =iif(First(Fields!Adjusted.Value) = 1, "Red", "Black") This works well, but now I have introduced a dril...more >>

Hi All, I am new to SSIS. If I need to desing a SSIS Package what are the basic standards I should follow, say for example. 1. How to Handle Error Handling 2. How to Log Information 3. Using Shared Data Source across Package .... Where do I find these Information. Please let me know oth...more >>

I am getting this error trying accessing RM page. Server Error in '/Reports' Application. -------------------------------------------------------------------------------- Object reference not set to an instance of an object. Description: An unhandled exception occurred during the execution...more >>

I am getting this error trying accessing RM page. Server Error in '/Reports' Application. -------------------------------------------------------------------------------- Object reference not set to an instance of an object. Description: An unhandled exception occurred during the execution...more >>

Hello: How to convert this Crystal report formula to an expression in SQL RS ? if {@Date} <> minimum({@Date}) then (({ByMonth.CustomerCount} - previous({ByMonth.CustomerCount})) / previous({ByMonth.CustomerCount})) * 100 Thank you....more >>

In SRS 00 sp2 we were able to call the printer direct by using the following URL http://xxx.xxx.xxx.xxx/ReportServer?%2ffolder%2fReport&Parameter=LAPTOP&rs%3aCommand=Get&rc%3aGetImage=8.00.1038.00RSClientPrint.html I saw in a previous post where GetImage is no longer available. This URL w...more >>

Hi I'm new to reporting services. I'm desinging a query for a report. I have one filed "ship_yw" that contains year and week numbers, for example, 200701, 200702. I want to display the year in one column and the week in another. I'm connected to a Progress database via ODBC. I have accomplishe...more >>

Is there any way to reference the value in the current table cell (Textbox) from within formulas in that cell? I am curious because there are many places, like 'Visiblity' where I would like to set it based on the current value, but need to duplicate the formula I use for "Value". I would ...more >>

ASP.NET 2.0 Project Added rdlc file DataSet with DataTable to be populated dynamically at runtime I cannot set DataSetName in the dropdown -- it does not recognize my DataSet and I cannot type into it. If I compile I receive this error for my RDLC "Error 1 The table 'table1' is in...more >>

Hello All, I have been asked to find a solution for generating an SSRS report directly to PDF without the client ever viewing it. There are a couple of particualrs about our requirements: 1. The report is being called from a third party piece of software 2. We have no, or at most, ver...more >>

Hi there, We have an ASP.NET 2.0 application that we are currently using and would like to tie in some SQL RS 2005 functionality. Specifically, we'd like to be able to use the report exporting functionality to generate Excel or Acrobat docs, without having to use the report viewer or using R...more >>

Does anyone know if it is possible to have the text in lists to be displayed horizontally (left to right) instead of vertically. This is what I have: 3a 2b 1C But this is what I need: 3a 2b 1c Please let me know if this is possible, and how I can accomplish this if it is possible. ...more >>

Can anybody tell mehow I can downgrade report made in RDL 2005 be downgraded to RDL 2003 . ...more >>

I am trying to use the WSS 3.0 web server lists.asmx to display list items in a report. I have created a datasource pointing to the url http://windows2003serv/_vti_bin/lists.asmx I the create a report using this datasource and set the query to: <Query><Method Namespace="http://schemas.micr...more >>

Hi experts, I'm able to subscribe to a report and send it to my internal email address (myname@mydomain.com), but when I set it to send to myname@gmail.com, I got error saying "invalid email address". I tried other outside addresses and got same error. My reportserver is configured to use m...more >>

When i deployed my data source and reports, i see in my output screen warning message 'Warning : Cannot deploy data source ReportsDS to the server because it already exists and OverwriteDataSources is not specified.' What is this mean???...more >>

Is there any way to expand all of the collapsed groups in a report? TIA Dean ...more >>

In the Preview mode, the collapse/expand works well but after deployment, collapsing and expanding caused the page to jump all over and I loose track of the grouping I expanded. Any ideas why this would happen and if there is anything that can be done to control this behavior? TIA Dean ...more >>

I have been working on this problem for days. I have a report that is grouped and will be printed duplex (front and back). There is a page break after each group. I want to ensure that the start of a new group does not end up printed on the back side of an old group. For example: Page 1 (pr...more >>

I have a mystery. I have a series of reports. Each report has the same basic parameters all of which except for dates have default values. The first two are From Date and Through Date. I have couple dozen of these reports. When I select a report via Report Manager I click my mouse in the ...more >>

Please help! I'm struggling to get an OLAP report to work in SSRS using an Analysis Services cube. When we attach to an SSAS cube all we can get is a static report with no pivot functionality. For example, I can't change the dimension of the cube in the report review mode. Does SSRS allow ...more >>

Hello, I'd like to create custom templates in Visual Studio 2003 when creating reports for SQL 2005 RS, but I'm unable to find anything online that shows how to do this. VS2003 has about 5 generic templates available, but it'd be nice to have a template customized to our corporate colors a...more >>

Here is the error: "An error has occurred during report processing. Query execution failed for data set 'ReportingDB'. For more information about this error navigate to the report server on the local server machine, or enable remote errors " Now here is the catch, when I hard code the conne...more >>

I am trying to export a report as a pdf file which may be around 160MB in size and the report is giving issues, its timing out or gives me out of memory, can someone let me know if you faced an issue like this and how it can be fixed....more >>

Hi All, Lets say we already deployed a report to the server via VS2005 or even VS2003, then we changed the defalut value for a paramter (it does not matter if it had a default or not) when we deploy again, the report server will not keep the changes for the defalu value. It does keep all th...more >>

I have a Requisition Report that generates the details for a specific Requisition ID. This is done by passing a paramater to the report. The end-user downlads the report as a PDF and saves it to his PC. The problem is that the default name when he tries to save is the name of the report (Re...more >>

Hi, i have a report which contains a table with several columns. The first column is filled with some data from a database, and can contain data, that is some cells can be empty, some can have values... So my question is, how can i make all the cells in that column that HAVE a value, to have t...more >>

Hi! When running a report in our production environment we get squares instead of characters. Does anyone have an idea why this is happening?...more >>

Hi! I have a problem while i want to test the status of the report server in my win xp os: -my os is win xp professional + sp2 -first i installed iis -then i installed sql server 2005 standard edition but when i want to initialize reporting service (using configure report server page) ,...more >>

I'm getting this annoying javascript error in my webapp when I try to display a report. parent.ClientControllerPageDev_PeterL_ctl00 is null or not an object All I see in Internet Explorer is the toolbar, in firefox the report is visible but the width is not correct. Anyone knows what th...more >>

Hi, I am using a web Report viewer control for viewing reports on a SRS 2005 report server. Is it possible to change the data source of the report at run-time? e.g. I have 2 identical databases - the live database and a test database. I want to be able to set the data source to point to...more >>

Hi, I am having a problem with Reporting Services printing duplicate rows. There are no duplicate rows returned in the data set when I run the query in SQL Server 2005. They just seem to be randomly printing a duplicate row here and there in RS. Has anyone experienced this? Any advice? ...more >>

I'm trying to override the true/false labels you get when you create a boolean report parameter. I've tried creating a dataset that I use for my available values but that didn't work either... Has anyone ever done this or have any ideas......more >>

Whenever I call the report from a browser, it opens the report in preview. Is there a command to have it go directly to the default printer? Thanks. David ...more >>

Hi, We currently have Microsoft Reporting Service 2000 with the Reporting Service and report data DBs on SQL2000. We will be migrating away from MRS in the future, so we don't want to upgrade to MRS2005, but we do want to upgrade the DBs to SQL2005. Can a MRS2000 instance use Reporting Service ...more >>

Hi all, After a couple hours digging through the archives, I've decided to ask for some guidance from the experts. Here's the deal: I have a classic ASP application. This application has a number of reports that were generated in asp as raw html tables. We've decided to replace these rep...more >>

Hello- I am having a bit of an issue configuring reporting services so that I can install the System Center Operations Manager 2007 Reporting feature. On our SQL server we have SQL2005 SP2 installed with the operations manager database installed and working. I installed SQL reporting serv...more >>

We are having all our Databases running on SQL Server 2000. Can we setup Reporting Server with SQL Server 2005 and Reporting Server 2005 and build the reports which will actually connected to SQL Server 2000 database. In short [Running Reports Build on SQL Reporting Service 2005 with a data ...more >>

Hi all, Could anyboyd tell me how i can get the max value of a table column. A column in my table contains numeric values. in my table footer i want to display the max value of that column. my table itself has one group. This group is called GroupByHour and is simply a group by hour for al...more >>

I am trying to get SSRS to work and am having trouble getting it to go. When I go to IIS and browse, it won't let me see the page, it reads "This page cannot be displayed". The internet has connectivity because I can get on my email and other sites. When I try to deploy the report, I am ...more >>

I have a number in a sql db that reads 315000, it is really 3,150.00 and when I add the field in SSRS it reads 315,000.00. What function or operator can I use to get the number to read 3,150.00 in SSRS? Thanks, Ryan...more >>

I followed the procedure on http://msdn2.microsoft.com/en-us/library/aa179206(SQL.80).aspx What should visible change in the GUI. I assumed that i would see the printer option when seeting up a subscription, but nothing new. Thanks, Gert ...more >>

Hello, I'd like to run some SSRS reports from my VB6 application. Is this possible? If so, could someone direct me to a good tutorial to do so? Currently I have an installation of SQL 2000 with Reporting Services, on a Win2K3 server box. Thanks! Rick ...more >>