Archived Months
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007


all groups > sql server reporting services > april 2006 > threads for thursday april 20

Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

Multi-Select Value dropdown "Select All" in SP1
Posted by Tom.Rally at 4/20/2006 10:29:01 PM
Hi, With SQL-Server 2005 SP1, the "Select All" in the dropdown does not appear. Without SP1 the "Select All" in Multi-Select Value did appear. How can I fix it? Regards, Tom ...more >>

display parameter value on Report Builder generated report
Posted by minority at 4/20/2006 7:15:50 PM
hi all, is it possible to display the parameter value on the report for parameters which contain multiple selection ? i can display the parameter value if it has only 1 value. how can i display the values if there are more than 1 ? Thanks! ...more >>

next 30 days or all values
Posted by jasrus at 4/20/2006 7:07:11 PM
Hi, I have a dataset and I need to be able to filter that data based on Completion Date. I have created a user parameter is SSRS with the following values: 0 = All Dates 1 = Next 30 days I am trying to filter my dataset but I don't know how to filter this based on my user parameter. He...more >>

Configuration SQL Server 2005 Report Services
Posted by Joe K. at 4/20/2006 4:40:02 PM
I have SQL Server 2005 and SQL Reporting Services installed on my server with IIS. I would like to obtain instructions to configure the SQL Reporting Services on this server. Thank You, ...more >>

Deploying a Reporting Model
Posted by Justin at 4/20/2006 4:39:01 PM
I'm trying to deploy a Reporting Model (.rmdl), but it continues to give the standard error message of "The permissions granted to user <me> are insufficient for performing this operation". I am an Administrator on the computer and have given myself every possible permission in the Reportin...more >>

Page Breaks
Posted by ERS Developer at 4/20/2006 3:50:02 PM
Hi, I am using RS 2000. and have a problem with the Page break. I have header and footer in my report and a 2Tables in the Body part. If the number of rows in the table1 exceeds some records(say 100) the page is printed in 3 sheets. FristPage :with Header and footer and Table1 75 Records. Sec...more >>

SQL Server 2005 / MS SQL Server Report Pack for IIS
Posted by Joe K. at 4/20/2006 2:44:01 PM
I have website that uses Microsoft SQL Server 2005 databases for backend storage. Listed below Microsoft SQL Server Report Pack for Internet Information Services (IIS). This package has the capablility to create reports for number of users connected to the webite and many statistic data....more >>

2k5: Interactive Sort - Total Line moving
Posted by Steve Funk at 4/20/2006 1:00:02 PM
When using the interactive column sort in a table, I have one report that the Total (footer) actually moves with the interactive sort. How can I keep the footer fixed as the footer? -- Steve Funk Application Developer iHomeowners, Inc....more >>



image won't show up
Posted by jenr at 4/20/2006 12:20:44 PM
Hey all, I have an image to put into a report. It's a jpg. I can see it in layout view, but in preview or when deployed, i get a red "x" - any idea why or how to fix it? Thanks!! jenr ...more >>

where are the stored procedures fields in report design?
Posted by SK at 4/20/2006 12:11:02 PM
When I call a stored procedure in the data tab of SQL Server Reporting Services 2000, The fields do not show up or disappear. Does anyone know why? How can I drag the fields from the stored procedure into the layout? Thanks for your help....more >>

Clustering Reporting Services
Posted by Alex Anderson at 4/20/2006 10:55:02 AM
Hello, I'm running a two node cluster, Windows 2003 R2 and SQL 2005. Does anyone have a white paper or documentation that tells me how to install Reporting Services as a clustered service? I've never set up a web farm or anyting of that nature, so any information regarding this would be g...more >>

charlist_to_table for mvp function
Posted by Lisa at 4/20/2006 10:02:02 AM
Hi, I found the following function on this site and am trying to use it my reports. The dataset for my mvp is different from my stored proc I'm using. The data set for my mvp is simple codes dataset = select distinct codes from tbl_codes values are AAA-2222 BBB-3333 CCC-444 In...more >>

Oracle with Reporting Services
Posted by jdcamp at 4/20/2006 9:32:18 AM
I am trying to connect to an Oracle database using Reporting Services. I create a new Shared Data Source, give it a name, then hit the edit button. Set the provider to Microsoft OLE DB Provider for Oracle, on connection tab I enter (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = server.som...more >>

Isstallation - licenses
Posted by MANCHO at 4/20/2006 8:58:02 AM
Hi, Is there any general recommendation if SSRS should be on the same server/different server than the SQL Server Database and Analysis services? Can the SSRS be installed on another(remote ) server than the SSDS andSSAS? IS there any licensing problems if this is done? Thanks. ...more >>

can a report read parameters from POST as opposed to GET?
Posted by awtesta NO[at]SPAM gmail.com at 4/20/2006 8:39:30 AM
My scenarios is that I have to have an ADHOC report page, which will allow the user to select various attributes, and I have to then create the SQL clause on the fly, based off these selected attributes. I then have to have the report in reporting services run off of that generated SQL clause. ...more >>

Calculated Measures
Posted by Al at 4/20/2006 8:34:15 AM
We are presently having an issue where if we use calculated measures an MDX query that takes about 1-2 seconds to run suddenly takes about 1.5 minutes to run. These measures are not extremely complicated they are simple like taking TotalDollars/TotalUnits. TotalDollars and TotalUnits are alr...more >>

Chart borders not hiding when no data is returned
Posted by Rabbit at 4/20/2006 8:18:47 AM
I do not have much experience with reporting services or Visual Studio. I'm trying to upgrade some reports from reporting services 2000 to reporting services 2005. One of the reports I'm working on contains 5 charts. In the 2000 environment when no data is returned for a single chart, the char...more >>

Suppressing Sub-Reports
Posted by mkipiniak NO[at]SPAM hotmail.com at 4/20/2006 8:00:09 AM
I have a report that calls a sub-report if a certain ID is present. I have code in the visibility property that displays or hides the sub-report based on that factor. The code is in the Visibility (hidden) expression of the table row =IIF(IsValue.Value ="Y",false,true) Real-Estate is huge...more >>

.Net framework for SSRS 2005
Posted by siaj at 4/20/2006 7:47:02 AM
Hi, We are plannning to upgrade to SSRS 2005 from SSRS 2000. Does it mean that our clients/users will have to upgrade to framework 2.0 from framework 1.1 inorder to see the SSRS Reports ? Thanks in advance ! siaj ...more >>

rs script utility and vbScript
Posted by ghealy NO[at]SPAM gmail.com at 4/20/2006 7:12:46 AM
Hi, I've modified PublishSampleReports.rss and it is working fine to deploy reports, set data sources and update parameters. However, there is one thing I can't seem to get working.... I'm trying to read the list of report names to be deployed from a text file. To do so I was using the fo...more >>

Forcing '0' to set number of decimal places
Posted by MACNR at 4/20/2006 1:55:01 AM
Ok heres my problem. Ive got a field that is rounded off to a set number of decimal places that is defind in another field. Heres the code... =ROUND (Fields!Transaction_Quan_.Value, Fields!Decimal_Places.Value) my problem is that when the value is zero, it returns just 0, not 0.00 for ...more >>

Upgrading to 2005 - are there issues?
Posted by Will at 4/20/2006 1:33:38 AM
Hi All, I'm about to upgrade a SQL server 2000 to SQL 2005, including reporting services. There's already a lot of reports, that probably use every feature known to reporting services (which for the reporting services 2000 isn't much ;) ). I was wondering if anyone had any advice about the ...more >>

Please Help Me !
Posted by Meftah Tayeb at 4/20/2006 12:09:53 AM
I am as Visual Basic 6.0/.Net Developer Wath Is The Microsoft SQL Server Reporting Service ? Wath Is The Microsoft SQL Server Analisie Service/Olap? Wath Is The Microsoft Engleech Query ? Thank You ! ...more >>

Merge cells vertically
Posted by Jens Winter at 4/20/2006 12:00:00 AM
Hello Is it possible to merge cells of a table control vertically? See the second column in this example: +----+---------+ | | | +----+ | | | | +----+---------+ Ciao, Jens...more >>

ReportViewer not displaying report
Posted by Doug Stiers at 4/20/2006 12:00:00 AM
I'm using the following code to run a report on a simple web page, VS2005, SQL 2005, RS 2005. For some reason the parameters retreive but when I run the report there is no data at all displayed. It's a very simple report reading straight from a table. Protected Sub Page_Load(ByVal sen...more >>


DevelopmentNow Blog