I am trying to run main reporting services page at: http://compname/reports and I am not getting anything back. I have SQL 2005 Express version installed. I also have SQL Server Business Intelligence Development Studio installed. What is missed then on my system? Thanks ...more >>

Hi there, I want to insert few dummy rows in my table in a report. Basically i've got an invoice report that returns different no. of line items for each invoice. I don't have page header and page footer in my report. That is because i want a border across my invoice. I've tried to do it us...more >>

Hi, I need to switch off background color of column in print mode to save printer resources. I need to show background color of column in preview mode only for readability purpose on the screen. I don't know how I can trace report current mode programatically. I am running server side r...more >>

Hi, I have a bunch of VS2003 rdl files which exist in named folders and I want to import all these files and their associated folders into a new VS2005 report server project. So, I tried just copying the base "reports" folder into the same folder where the new VS2005 reports solution is locate...more >>

I currently have a SQL 2000 RS SP2 installation and upgraded the back end to 2005. I think I read somewhere that the web service is not compatible anymore? I am using the web services and don't want to have to change any code if I don't have to. Will my 2000 WS implementation continue to...more >>

Is it possible to specify the file name of exported file? We like to have certain naming convention, including timestamp....more >>

hello, my english is not to well. i Have a chart (columns) I need set de colors of my columns How can a do that? thanks !...more >>

I have a report that contains a table. The group header in the table is set to repeat on a new page. However, as soon as I place a subreport in the table of the main report and that subreport causes a page break...the group header on the top-level report doesn't repeat. Is there a workaround f...more >>

Is there a way to set the zoom parameter to default to "Page Width" instead of "100%"? Thanks for any help, Carmen....more >>

I have a table that lists both "Buy" and "Sell" orders. I want to display a SUM of all Buys and a SUM of all Sells in the footer. Is there a way to conditional SUM the rows based on a column value in reporting? Thanks, Jeff...more >>

Does anybody know how to use special characters on a report's name? The name should countain "P&L" or "FC/PL/PY". When I try I get "The item name is not valid. Item names cannot contain the following reserved characters ;?:@&=+$,\*<>|"/, and cannot consist exclusively of dots or spaces" Is the...more >>

Hi, I would like to use a Matrix where the first table defines the Columns, the second table the rows and a third table holds the data - which needs to be associated by the values from column and row. But for some reason I can only set one table from a data set as the data source (e.g.: dsDat...more >>

Is there any way to change the behavior where a new primary entity (the entity at the top of the entities box) is automatically selected when you add data that traverses a role with a 1-to-many relationship? Let me illustrate using a generic example. Say the Customer table is the main prima...more >>

Hi, I have created a web application with ASP.Net 2.0. I also have created a report using Reporting Services 2005. After showing the report on the screen, I give the suer the possibility to export to report. One of the possibilities is PDF. Now we have some troubles with this export. O...more >>

Hello all. In my application I have some rdl file that determines general look of my report. Also I have a table that has 20 columns I have stored proc that returns dataset that also has 20 columns but may have filled less than 20 columns (5 for example). The problem is how to hide another (20-n...more >>

Hi, When I have paused a shared schedule in Reporting Services 2005 with SP2 (version: 9.00.3152.00 ) I cannot resume it again. It will remain in status "Paused". This applies for all of my shared schedules. Someone who have recognized this behaviour and/or does anyone have any ideas abo...more >>

Subject: RS - Error HTTP 401.1 - Unauthorized: denied access due to invalid credetentials I have a problemm with an Reporting Services installation. When I want to access a http://orden14/reports, it request me to type login and password. I type login and password 'administrator' and, i...more >>

Hi NG, I've got a report in my report project in that the fields' position is changed when previewing. Have anybody recognized similar problems? ...more >>

I have reports designed and deployed at the report server running Sql 2005 SSRS. I want to display those report in a vb.net Windows application using a report viewer control and I have searched the internet for the past 2 weeks and I still can not find anything or samples on how to do this. I ...more >>

Hi there Apart from MSDN, could you anyone think of Tutorial websites and DVDs = for learning Reporting=20 Services on Microsoft SQL Server 2005 please? Im using a DVD from the excellent DV Press company. Great to have media = with live instruction and screen shots. Many thanks Chris...more >>

Hi, how do I go about converting 2000 rdl files to 2005 format? I have searched on the web and people recommend opening up the existing rdl files in report designer or create a new microsoft report project from visual studio 2005. My problem is that when I open up the rdl files in 2005 I jus...more >>

I have a data field called RunStatus that I place into a hidden textbox on my report. I created a textbox in the footer and set the expression to =ReportItems("RunStatusTextBox").Value. The footer does not repeat this value on all pages. I am assuming it is because the hidden textbox is on ...more >>

I have a table with start and end dates for useage of an asset and would like to generate a sort of gantt chart for a date range. ie a horizontal bar graph like Microsoft Project with the assests down the left-hand-side and dates along the top. Is this possible with SSRS? I feel like I ha...more >>

I can access the Reports Manager and all the tab pages in the manager from my home PC by authenticating the username and password, BUT THE REPORTS THAT I UPLOAD WILL NOT RENDER REMOTELY. If I log into the actual server, I can see and view the reports just fine. I am using SQL Server 2000...more >>

So I have a report that has a header, and in the body there is a table. The table has a heading row. When I export this report to excel, the freeze pane is put under the header. Is there a way to specify the location of the freeze pane when the report is exported to excel? I would like to have...more >>

I can only get to my Reports from http://localhost/reportserver, the http://localhost/reports is not working, it is only showing me part of the page. What can I do to fix this? I am only seeing the top tool bar and the part that says; home - my subscriptions - help Any ideas of how to tro...more >>

i've already read the MS help file saying this can't be done, but there are lots of people out there smarter than MS. Has anyone come up with a way to take a multiple select paramter and pass it into a stored procedure yet? I noticed there is a built in function string.join which concatona...more >>

I am having an issue with the winforms viewer where it always shows the report in full print width (8.5" for this report) regardless of the "InteractiveSize" property. - The report itself is 7" wide in the designer - .75 margins on each side. - "InteractiveSize" is set to "7in, 11in" In ...more >>

We installed sql 2005 server and reporting services (standard edition) on window2003 with sp1 and IIS 6.0 is running on it as well. I am in local admin and got error when i try to connect report server: Cannot execute a program. The command being executed was "C:\WINNT\Microsoft.NET\Framew...more >>

Okay, here is the scenario. I have an analysis services cube and a report model generated from a OLAP datasource in reporting services. My first problem is that when I try to create a report using the report builder from my local pc I get data source connection errors, but if I remote deskto...more >>

We installed sql 2005 server and reporting services (standard edition) on window2003 with sp1 and IIS 6.0 is running on it as well. I am in local admin and got error when i try to connect report server: Cannot execute a program. The command being executed was "C:\WINNT\Microsoft.NET\Framew...more >>

Hi- I dug through the archives and found this helpful bit from Robert Bruckner from September 2005: Sum(Fields!Reg_Hours.Value) / Sum(Fields!Reg_Hours.Value, "MatrixRowGroupName") I'm doing this; no error, but getting 100% for each item in my group. Any suggestions? 99% (ha) of what I do ...more >>

Trying to build a report that will return information on many contacts. SELECT ContactExtensionBase.ContactId, ContactBase.LastName, FROM ContactExtensionBase INNER JOIN ContactBase ON ContactExtensionBase.ContactId = ContactBase.ContactId WHERE (Contact...more >>

I use the javascript method to launch most of my drilldowns into their own IE window: ="javascript:void(window.open('" & Globals!ReportServerUrl & "?/Sales/Dashboard Drilldown - By Stage" & .... But now that we just switched to Sharepoint Integrated mode with my reports now residing in a do...more >>

Hello All, I am a newbie here coming from a Crystal development background and intermediate skills with SQL. I seem to have various issues creating all sorts of RS reports. I'm trying to start with "more modest" reports to ease myself into the groove of using RS, but some things that seem s...more >>

Here's the scenario: I want to be able to create a report (typically these reports are "table like" reports ... in other words, several columns with a list of data underneath) and I want to be able to re-order the columns (not the rows) in these reports at runtime. So, for instance, if the ...more >>

I need some help on SQL reporting 2005 -Grouping and page break. I am displaying list of Lobbyist Names in one my reports order by Names. I want to Group all the names starts with 'A' and introduce page break at the end. Then all the names start with 'B' and show it in next page and so on...more >>

Hi, I need to have a few folders in a reporting system to organise my reports. All of the reports connect to the same database. The only solution I can see is to make a separate Visual Studio project up for each folder I want on my report server. This means I need a separate shared data sou...more >>

Dear all, what is the easiest way to rerun a set of time-scheduled subscriptions on a report? I need to rerun inflow on the Data Warehouse and rerun these reports. BR, Bert ...more >>

Hi, I have a report which has a subtotal and users can click on the subtotal and go to a sub report. However, when people click on the subtotal they are shown a blank screen (Apart from the standard reporting services header). When I right-click on the blank screen and view the properties of t...more >>

Hi all, using SQL2000 sp4 How can I see why a report is not loading in browser. Just hangs with hour glass. not even the paremeter input fields are loading? I haven't even clicked view report? other reports are fine. thanks, gv ...more >>

Is there any way to send a quantity to the print que to deterimine the number of copies to print? I need to deliver a copy of a report to each department that is reflected on areport. Let's say for example, I have a report that has 3 departments with line items to be produced by each departme...more >>

Hi guys, We have 2 database one in US another in UK. I am developing 2 reports one for US and another for UK.. Is there any way to pass/give the connection dynamically? Regards, Sri...more >>

Is there any way of adding subreports to a "container" report at runtime? I need to make the reports composable and would prefer not to have the superset of all reports in the container and just toggle visibility. Right now the only solution seems to be to generate my own RDL on-the-fly, which...more >>

Dear all, I'm a noob to SQL Reporting Services but have plenty of experience with other MS applications (including excel and access). I was wondering whether it's possible to combine a cross-tab and a chart within a single report. If so, how do you do this? I believe the power of a report (...more >>

could u please tell me how to validate inputput parameters in reporting server ...more >>

I want to combine several reports into a single report to print out. I want the correct page numbering on each of the individual reports so I don't want to use subreports on a main report. Is there a way to combine reports into a single report to allow the user to print without having to print ...more >>

Does anyone know of a way to relocate the "View Report" button for reports? ...more >>

Hello, I have pulled al my hair out and have no more hair left, so I hope someone can help. I have a function I'm trying to use in my SSRS 2005 Report (Report-->Parameters-->Code tab): Function funAdditions(pFields As Fields) As String if pFields!FA00902_AMOUNT.Value > 0 and pFields!FA0...more >>

Hi, I would like to allow my users to create report templates and save them. The reports should get their data from my business objects. I'm not really sure where to begin with this.. I image that i'll need to setup reporting services. Currently I have rdlc client reports and report vi...more >>