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 > october 2005 > threads for monday october 24

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 31

Optional page break
Posted by news.microsoft.com at 10/24/2005 6:32:47 PM
Is there a way to create an optional page break? I tried using a rectangle and using the insert page break before or the insert page break after properties in conjunction with an expression to determine if the rectangle should be visible or not the problem is that when i use the expression on ...more >>

Jump to URL - New Window - Ampersand
Posted by kaibh at 10/24/2005 3:31:10 PM
I have a Jump to URL hyperlink action using the "javascript: void(window.open)" code. This works great, except when one of the parameters contains an ampersand. I get an error saying that the "path of the item is not valid. The full path must be less than 260 characters long, muster start ...more >>

expression based on multiple values in a dataset
Posted by l.holmes at 10/24/2005 2:34:07 PM
Hi I am trying to seth the background colour of a textbox to either red or green depending on the multiple values in my dataset. Each row of my dataset has a boolean value for Pass. The background colour of the text box needs to be green if all rows in my dataset have a Pass value of Tru...more >>

Interactive Sort in a matrix
Posted by LaurieT at 10/24/2005 2:17:15 PM
I cannot get the interactive sort to work in a matrix (SQL Server 2005, Sept CTP). Does anyone have examples on how to do this? Should interactive sorting work in matricies -- or is it only set up to work with tables? -- LaurieT...more >>

Fetch a certain row
Posted by Alek Lynge at 10/24/2005 1:08:22 PM
Hi. I have a dataset with a two column table: name | value What I'm trying to do is to make a textbox in the report designer to fetch a certain field (value) from the table based on the name field. How to fetch that certain cell from the dataset. Any help appreciated. Alek ...more >>

Custom Assembly deserialization issue
Posted by Keenan Chadwick at 10/24/2005 12:27:06 PM
I see a lot of people are having the same issue when deploying to the report server, even though things are running fine in design mode on their local machines. I know that you need to copy all assemblies referenced to /80/Tools/Report Designer/ and /MSSQL/Reporting Services/ReportServe/bin/ a...more >>

Dynamically Adding Columns
Posted by Terry at 10/24/2005 11:49:23 AM
Is there a way to dynamically add columns as a report parameter? ...more >>

Not allowed to install Reporting service
Posted by Isak Lyberth at 10/24/2005 11:46:18 AM
When i try to install Reporting Service 2000 on a windows2003 server with SQL Server 2000 SP3a and Analysis Services 2000 with SP3a, I get a message saying that Reporting Service requires SQL Server to have the hotfix 821334 installed. This hotfix I cant find, only in SP4. Installing SP4 is not...more >>



Export feature - Show or Hide?
Posted by Immy at 10/24/2005 11:05:10 AM
Hi all, Is or WILL it be possible to show or hide the Export feature either in RS2000 SP2 or RS2005? By this I mean when a user (forms auth.) logs on, dependant on his/her permissions, they will have the ability to export reports or not by disabling this feature. Regards Immy ...more >>

Can Users choose Rows & columns for a matrix??
Posted by pmud at 10/24/2005 10:26:07 AM
Hi, Is it possible to create a report which allows users to select the fields for the matrix in a report. To explain in detail, can we allow the users to select the X and Y axis for a matrix in a report? For ex., there is a report containing a matrix which shows the total sales( data cel...more >>

Report Error when 2 pages for multiple records
Posted by bssolutions at 10/24/2005 9:46:21 AM
We have a web app, built in .Net, with reporting services as our reporting tool. The problem we are having is when we have a report that goes to numerous people and the report is 2 pages long. When we make it 1 page, legal size, it works fine (avg records are 500-900). When this report is ...more >>

Stored Procedure Parameter Problem
Posted by Brennan at 10/24/2005 9:01:02 AM
Hi All: I have created a stored procedure to act as the data source for a report. Here is the code: CREATE PROCEDURE dbo.tshspClosingScheduleRpt @Community Int AS SELECT HomeTypes.HomeType, ClosingSchedule.Lot, ClosingSchedule.Purchaser, Locations.LocationID, Locations.Locat...more >>

Report usage stats
Posted by DJTN at 10/24/2005 8:45:08 AM
Is there anyway I can see who has ran what reports and when? I have so many reports that have been requested and I have a feeling they are not being used. ...more >>

Vertical Text
Posted by David at 10/24/2005 8:09:02 AM
How do I change the text to be layout vertically in a column? So it will show like this: t x e T...more >>

Page Header - Displaying Parameter with multiple values
Posted by Terry at 10/24/2005 7:46:05 AM
I am unable to display parameters with multiple values selected from the report. How do I resolve this issue? Code user on page header: Parameters!ExecContacts.Label...more >>

Dynmaic parameter on Subscription report
Posted by Voss at 10/24/2005 6:43:45 AM
Is it possible to have a dynamic parameter value such as current date to a subscription base report? Thanks, Voss. ...more >>

Page Footer - No totals
Posted by Terry at 10/24/2005 6:29:15 AM
I am unable to total values on the Page Footer. Thank you for your help! ...more >>

MS Reporting Service for Client Application
Posted by Mohan at 10/24/2005 4:50:03 AM
1. We have Thin Client which is connecting to the Sql Express database. Is it possible to use MS Reporting Service in Sql Express database. 2. What are the pre requisites shoule be there in my thin client to see my reports in the thin client. ...more >>

Changing layout for report
Posted by Hanne at 10/24/2005 4:04:02 AM
Hi all! Does anyone know if it is possible to change the layout of reports? I'm using reporting services for some new reports in our application, and I want the new reports to look similiar to the existing reports. Some of the things I would like to do is to move the parameters to the right...more >>


DevelopmentNow Blog