Hi folks, I’m relatively new to both SQL Reporting Services as well as .Net programming. I come from a Crystal Reports background and I’m running into a problem duplicating a common technique used in my old Crystal reports. The simplified description of the problem I’m having is thisâ...more >>

Is it possible to "Expand ALL" levels of a summarized report? I have a report that has 3 levels of detail, with about 10 main items, a couple items under that and 4 or so items each under there, it gets tiresome real quick to click all the little pluses... When I export it to Excel 2000 t...more >>

...more >>

I am having the same problem that Cyndi posted on 5/10/06. I have a group that has a filter on it. The group has a footer that has a Sum field. The sum field is summing all data for the group, not just the rows that are displaying. Has anyone come up with a solution for this problem? Is t...more >>

We just migrated from 2000 to 2005 on a new box. The migration documentation was wonderful for 2005 and it answered all of our questions. Our main reporting page should allow all users of a group to browse, but it no longer seems to accept the integrated security login for access. It ends up gi...more >>

Hi All, I am getting this error - "Error: Subreport could not be shown" only in the report viewer. Strangely, the first row in the parent report has the subreport shown correctly and all the subsequent rows have this error message. The report runs fine when I use the preview in Business Int...more >>

I have a matrix where I am using the inscope function to return different calculations depending on which group it is in (ie the detail is just the value and the sub totals are sum(values)). In for the subtotal group I have used: iif(isnothing(sum(Fields!CurrentCount.Value)), 0, sum(Fiel...more >>

Hi, We have a main report that calls a subreport. The subreport is being = passed the appropriate parameters. The subreport works correctly in isolation in the preview mode. However, = when it is called in a main report it stops working. I get the message "Error: Subreport could not be shown."...more >>

Are there some major issues with the reports and IE7? One of our systems which is attempting to access the reports via LAN is having the following problems. The system is running IE7 Beta 3 on WinXPPro SP2. 1) When opening report builder the progress window appears showing the download...more >>

Is it possible that the reporting services will send a zipped excel file instead of just the excel file?...more >>

I have a dataset which has a ContractNo column which can take a null value. I cannot carry out the filter on the stored procedure which generates my dataset. This dataset is used in a matrix. I need to filter out all rows with a null ContractNo. I thought I could do this on the matrix prope...more >>

I've written a simple report to get familiar with RS 2005 syntax, etc. The report contains 2 parameters that are input in text boxes before the report is displayed. The select statement works correctly when executed in the query builder but does not display the report in the aspx page. Here is...more >>

I need to display a values from the another dataset. E.g. I have a SQL database with employees details and that is dataset 1; but employees salaries are stored in Excel spreadsheet and that is dataset 2. The question is how can I display a list of employees along with their slaries? Tha...more >>

Hi, I've defined a matrix in a report which looks like this: group by column group by column Description Data Data Description Data Data Now I'd like to add a colum which sums up th...more >>

I have my first project with reporting services - 2000 not 2005 and the very first report that I have to generate is based on a dynamic pivot of an SQL table. This means at design time, I don't know how many columns there is going to be - it will vary quite a lot depending on date ranges an...more >>

Hi, Can i know the first RowNumber in each page on a table ? Thanks -- Pony Tsui...more >>

Is there a way to put code (i.e. an Expression) behind a cell in a table that will control the background and foreground colors of the cell itself? For example (this is pseudocode to indicate what I want to happen) If =Fields!policy_count.Value > 5 then Set background and foreground to "R...more >>

What is the syntax to call a SQL server stored procedure from a report? Say if I wanted to create a custom field that would be based on an expression that calls the stored proc (which would return a single value from a single field - a sum in this case). What would be the syntax for doing thi...more >>

Report Builder is launched using a technology on the client machine called ClickOnce. This technology needs to authenticate to the server in order to download the application files, but it can only do so using the default credentials of the logged-in user on the client. The only two ways this wi...more >>

In the RS data tab, one can create a dataset using text or stored procedure. I've also noticed there is an expression editor option available next to the query string box. Is it possible to call a custom dll that is already referenced by the report to return a dataset to the report? Essenti...more >>

Looking for suggestions on some good books for Reporting Services that will get me up to speed on its functionality. A book with a good index, good for beginners, good reference book; that will hopefully get me up to speed pretty quickly on utilizing Reporting Services. Thanks in advance fo...more >>

Hello, I'm still having an issue with opening up a new window on the report server regarding the report designer's -> Jump to URL feature (option) in Advanced - Navigation. This is what I currently have now and I've tried the JavaScript syntax (expression) i've seen on the old boards, but I...more >>

I'd like to write a report with a data set that calls an Oracle data source for its result set. I have a package with a procedure that returns a ref cursor as an out variable. What is the syntax for calling this procedure from the Report Designer? Does the out variable with the cursor need ...more >>

Does anyone know how I can use the format statement to show -234.00 as (234.00)? ...more >>

I'm created a fix lenght report and i have several subreports. My problem is that if the subreport has no data, it's not displayed. I want to display the subreport all the time, any ideas? ...more >>

I have a copy of report builder exposed to the local LAN and also the internet, currently I am using a dynamic IP for testing in a development environment. I am using windows logon to for security. If I log onto the server from the local lan using the username/pw the report display and I a...more >>

Please advise what language syntax is used in report expression. I have two functions used in report expression. I assume VB.net syntax, but... 1. IIF. It is in .net SDK document. 2. FIRST. It is not in .net SDK document. Thanks. Peter...more >>

I have what I think is an issue with Reporting Services. We have installed SQL Server 2005 Reporting Services on a Windows 2003 Server. Both SQL Server and Windows 2003 have been upgraded to SP1. My SQL Server is set to report failed login attempts. My EventViewer is constantly reporting...more >>

HI, Need some help in displaying the records in two table( from a single dataset). To be precise i have a dataset which returns say 10 rows, i want to display the odd numbered rows( i mean the alternate rows) in the first table and then the even rows in the second table. I'm using RS 2K. ...more >>

Hi I'm trying to config our reporting service to deliver reports by email. In RSReportServer.config, I set up the email delivery potion as follows: <RSEmailDPConfiguration> <SMTPServer>mail.mycompany.com</SMTPServer> <SMTPServerPort>25</SMTPServerPort> <SMTPAccountName></...more >>

Good day I am having trouble with getting an Oracle query right for SQL reporting service. I wrote a front end to execute the query and it works fine. Now the next step is to allow users to get a report on any number of clients. The way I do this for normal SQL Server, is to build SQL wit...more >>

I have SQL Server Developer Edition 2005 installed on my Compaq Presario which is running Windows XP Media Edition. When I try to deploy a report model I get the error message: "A connection could not be made to the report server http://localhost/ReportServer." Under additonal informati...more >>

I have developed two reports "MainReport" and "SubReport". I click a value "CountryName" to navigate to detailed view in "SubReport". MainReport passes a Parameter 'CountryName' to SubReport. When I try to run it from report server: after clicking a country name in MainReport I get the foll...more >>

Hi I am trying to run the following query but want to use a parameter instaed of the -7 BETWEEN GETDATE() AND DATEADD(d, -7, GETDATE()) ive tried BETWEEN GETDATE() AND DATEADD(d, @date, GETDATE()) with the parameter set is an int & text but to no avaial. Thanks in advance...more >>

I'm using RS 2000 SP2 and have implemented a custom security extension. The reports are embedded in our web application. Everything works great except for the help link, which when clicked, launches an IE window that displays the login page. Is there any way to disable, hide, or change the hr...more >>

Hi all, I have seen this question asked many times, but never an answer posted. Here is the situation: I need to connect dynamically to an unknown number of databases at runtime, which the user will be no part of (any parameters involving the Servers or DBs will be internal/hidden). The d...more >>

Greetings... I am looking at setting something up to filter the data displayed on a report based on the user viewing the report. Has anyone else done this? Here's a break down of how I imagine implimenting it, let me know your thoughts... o Create a user_properties table containing (userid...more >>

hi, I'd like to add 2 parameers to my report. both of them are datetime datatypes. how can I use the values from this parameters further in my report? I want to buil the differnce in days between 2 dates. my approach would be =datediff("d",Parameters!Date1.label, Parameters!Date2.label) ...more >>

Using SQL Server 2005, specifically the Report Builder Interface. Two unrelated questions: 1) Is there a way to disable clickthrough reporting when exporting data to Excel? I want the clickthrough reporting enabled for reports created and viewed using Report Builder. However, when I export...more >>

When we were on SSRS 2000, I had to add a line in my RSWebApplication.config file in order for people outside our firewall to access our internal report server. It looked like <ReportServerExternalUrl>http://xxx.mydomain.com</ReportServerExternalUrl> We just upgraded to SSRS 2005 and I...more >>

I have reports developed in VS 2003 over the past couple of years. They were set up using SQL Server 2000 and deployed to an IIS 6.0 server, using IE 6 and IE 7 (beta) client browsers with no problems. I just upgraded my SQL Server from 2000 to 2005 yesterday and, using VS2005, re-deployed...more >>

Can anyone tell me if Visual Studio Express and Visual Studio Report Designer are compatible when designing reports? We tried to import .RDL files between the two and were unsuccessful. Our intent is to give our user something like Visual Studio Express to develop reports , but yet be flex...more >>

This message is displayed when the report model does not have any entities in it. Does your model have at least one entity? -----Original Message----- From: cobol Posted At: Wednesday, July 26, 2006 2:04 PM Posted To: microsoft.public.sqlserver.reportingsvcs Conversation: SQL Report Builde...more >>

I am trying to create a sub-report that is using a UDF(user defined function on the SQL Server) requiring parameters from the parent report for a datasource for that sub-report. (I hope that made sense). Basically, the UDF needs to be run for every record that is in the parent report. The UDF ...more >>

Hi, I'd like to display a chart with simple bars. I'd like 0-100% (in 20% steps) displayed on the y-axis. At the moment my y-Axis is only as big as the highest bar. Example: I have to baras one with 12% and the other one with 56% my diagramm will only go until about 60%. How can I resol...more >>

hi, is it possible to deploy an report directly to a folder from the business intellegence studio? or can I only move reports via the Report Manager? Thanks! ...more >>

Any Answer would be appriciated.... TIA ...more >>

Hi, I have report created with Reporting Service 2000 SP2 designer. This contains a Column Chart with Simple Column type. I had selected GraySacle Pallete for my report. I have max 4 columns in my report. When I deployed the report on MSRS 2000 SP2 Report Server it is showing correctly. The...more >>

Hello, I'm using SQL Server 2005 Reporting Services. I'm having an issues when exporting to Excel. I'm using URL Access to generate the report and display it in a browser window. I then choose Excel and click the Export link. Doing this opens a temporary browser window and then a dialog that ...more >>

I installed Reporting Services on stand-alone server from a SQL Server 2005 Standard CD. It supposed to connect to a remote SQL Server that would host the ReportServer database. I went through the steps of the Configure Report Server till I got to "Database Setups". I created a new ReportSe...more >>