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 > june 2005 > threads for wednesday june 8

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

Installation Question
Posted by HollyylloH at 6/8/2005 8:15:08 PM
We have a webserver running Frontpage. We have a second server running SQL Server. I would like to install Reporting Services on the Web Server. Will there be a problem with this? Will I need to install Visual Studio on the Webserver first? Thanks...more >>


Changing color of the details depending on the value of the field
Posted by imarchenko at 6/8/2005 4:56:54 PM
Hello ! I am using Reporting Services with SQL Server 2000 (SP3). I am trying to build in dynamic coloring into my report depending on the value in a certain field. Query already returns name of the color I would like to use as an additional field (color conditions are driven by rang...more >>

Issues running reports from browser vs RS SP2 Viewer
Posted by Kyle Jedrusiak at 6/8/2005 4:49:45 PM
Some people can run reports via IE. It seems that people running Server 2003 (a slight few) and IE with Enhanced secutity can't run the reports via IE. Running reports from our app using the report viewer worked fine at one point. Now we've changed something (not sure what) but now the ...more >>

Multi-lingual Reporting and Page Headers
Posted by Lisa at 6/8/2005 3:08:03 PM
I am doing multilingual reporting and have just about worked it all out. The method I am using is to pass the culture code into the report and it brings back my dataset from a language_translation table via stored procedure. Everything is working great, but I have one caveat. I am using a...more >>

Q: passing int parameter
Posted by JIM.H. at 6/8/2005 2:07:06 PM
Hello, This is the way I call report viewer in my asp.net application. this.ReportViewer1.ServerUrl=serverUrl; this.ReportViewer1.ReportPath=repName this.ReportViewer1.Parameters=Microsoft.Samples.ReportingServices.ReportViewer.multiState.False; this.ReportViewer1.SetQueryParameter("My...more >>

Control the WorkSheet Names when export to Excel
Posted by Albert at 6/8/2005 1:08:02 PM
When I exported the report to Excel File with Multiple Worksheets, can I name the worksheets with the values of the field I group on? -- Thanks, Albert Chow...more >>

How to pass more than 1 variable in jump to url??
Posted by AlanT at 6/8/2005 12:50:02 PM
What is the proper syntax for passing multiple variables to a web application using the jump to url navigation. I have succussfully passed one variable using this string "="http://servernamehere/variance_review?prod_order_number=" & Fields!Prod_Order_Number.Value" but can't seem to figure o...more >>

List control - New Page
Posted by jweesies at 6/8/2005 12:29:05 PM
I'm a newbie to SRS and have an easy questsion. I have a list control with a text box and want the values in that text box to appear on a new page. I've tried all the page break options in the list properties but nothing will work. I've also tried creating a details group on my text box and...more >>



RS asking for credentials
Posted by Kyle Jedrusiak at 6/8/2005 10:59:21 AM
We have SP2 installed. Our app uses the new viewer control. Right now every time the app asks for a report the RS is asking to login credentials. Prior to today sometimes it would and sometimes it wouldn't. We're on an intranet so anyone in the domain can run/view a report. It seems...more >>

chart series
Posted by MJ Taft at 6/8/2005 9:37:01 AM
Is it possible to chart one data series as a line and another as a bar on the same graph. Other tools allow this and I have been asked to do it - I dont see how it is possible since you define the graph as either line or bar to begin with....more >>

Report Layout Width and Height for Landscape on Legal Paper????
Posted by Bob Morvay at 6/8/2005 9:29:40 AM
I have a very large report that can't squeeze into Landscape on Letter size paper. I was wondering if anyone knew the dimensions for Landscape on Legal size paper. Is this possible? Thanks in Advance. ...more >>

Report caching
Posted by Trisha at 6/8/2005 9:20:53 AM
Hi all, I have a report that takes about 10 minutes to run for a given date. How can I cache it some how so that it would run lot faster for the same data input (date) later on? Thanks in advance....more >>

Refreshing the field list
Posted by Myles at 6/8/2005 8:20:05 AM
Hi all, running RS with the serve on sp2 - have a question about refreshing the field list in the data tab of the designer. I have copied (and changed slightly) a stored procedure that one of our reports runs on. All of the field names are the same, that didn't change...I can run the SP...more >>

why use mdx querys with Parameters very slow in creating repoter
Posted by vvp at 6/8/2005 7:24:28 AM
i have a dataset (mdx query with 5 parameters) to get more than 50 columns data,but it building too slow to wait Is there any way to solve this problem? thx to reply...more >>

RS Installation fail without message.
Posted by Johan at 6/8/2005 5:59:04 AM
Hi! I've installed RS alot during the last 6 months and been falling into every pit there is in this package, but now theres something really fishy with my current installation. During RS installation on a member server (Win2000 SP4, SQL2000 Std SP3a, RS 2000 Std) i dont get the usual Server ...more >>

Format date parameters
Posted by Tango at 6/8/2005 4:28:03 AM
Hi, I have a start date (date/time) parameter with a default value of =DateTime.Today & a end date (date/time) parameter with a default value of =DateTime.Today.adddays(7) These parameters query a short date field in an access database Could i please have some assistance around taking off t...more >>

Reverting from SP2 to SP1
Posted by DustpanDave at 6/8/2005 4:15:03 AM
Hi all, If i have installed SP2 for reporting services and need to revert back to Reporting Services with SP1. Is this possible without inplications? Am i able to remove SP2 and reinstall SP1 and have the normal functioanlity of SP1 or would i have problems. If anyone has tried this please...more >>

exporting to csv
Posted by Stuart at 6/8/2005 2:01:03 AM
Hi have had a look this morning through previous postings but cant quite find what Im looking for, as a complete beginner to reporting services Im a bit behind in how to do things and where configurations are set what I have is a report that needs to be approved by human eye before being ...more >>


DevelopmentNow Blog