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 > may 2007 > threads for tuesday may 15

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

Need Help! New to reporting services
Posted by Samyra at 5/15/2007 3:48:01 PM
I need to populate a detail cell in a table report with 0 if the value of a group cell in the report is > 500000. I've created on iif statement and it works great when pulling data into the cell from the query. However, I need to know how to call the value of a specific table cell into the ...more >>


calendar control for parameters in SQL 2000 Reporting?
Posted by KBlount at 5/15/2007 1:17:02 PM
As the subject says, I'd like to know if calendar controls are available for reporting creating using VS2003 running on SQL 2000 (for internal reasons we cannot upgrade to SQL 2005 for some time)...more >>

SSL Issue
Posted by Marvin at 5/15/2007 12:51:01 PM
for some reason I am able to deploy reports to an instance of Reporting Services installed in Virtual PC. However, in my web application, calling the logon web method throws a "The underlying connection was closed: Could not establish trust relationship with remote server" Any Ideas? VS 20...more >>

multi value parameter
Posted by brian at 5/15/2007 11:14:01 AM
I've been reading the forums regarding this but don't seem to understand exactly how this is supposed to work. I have parameters list build from query. Report Parameter is set to multi value. The SP that the report uses has line: PARAMETER IN (@Parameter) in the WHERE clause. When I run the ...more >>

Determining Report Format from expression
Posted by Weston Weems at 5/15/2007 9:55:51 AM
I would like to be able to check format to be running as, so I can make some columns and fields invisible if run as excel or CSV etc. Is this possible? I dont see a way at hitting render format from Report! object. Thanks....more >>

Error BC32093 "Of" required when specifying type argument when calling FormatDateTime() ?
Posted by JustTheJanitor at 5/15/2007 8:47:43 AM
I'm trying to format a DateTime column returned by a stored procedure to show the date as dd mmm yyyy. When I try and use the FormatDateTime() or Format() functions I get the following error: Error 123 [rsCompilerErrorInExpression] The Format expression for the textbox 'textbox26' contains an ...more >>

Report Model against Cube data source
Posted by Joe at 5/15/2007 8:01:09 AM
We have successfully generated a Report Model against a Cube data = source. My question is I can't seem to figure out how to modify the = model. The wizard organized and named entities in an odd way - and even = finding the measures is in some obscure place. I know how to create = models in B...more >>

TargetServerURL
Posted by Rich at 5/15/2007 7:49:01 AM
Hello Group, there is an old install of 2000 Reprot server on one of our servers. No one remebers what the TargetServerURL is for publishing reports to . I thought teh path was stored in a config file some place or on the IIS virtual folder. How can I find this for certain. rich...more >>



Big picture question about Reporting Services
Posted by B. Chernick at 5/15/2007 5:51:01 AM
I am an beginner who has completed one report under RS. I'm wondering if my memory is playing tricks on me. This report has been rather easy to do. I've hardly had to look at the documentation. (I should point out that I'm temporarily using the SQL Express version because Someone misplaced...more >>

Jump to report value for parameter, cube data
Posted by IanP at 5/15/2007 1:51:01 AM
Have a problem with passing information between reports using Jump to report facility. User clicking on field value in report to pass to second report. This works with the second report showing the value of field user has selected in the parameter box (Available Values set to non-queried...more >>

how to hide a subreport
Posted by Bernhard Held at 5/15/2007 12:00:00 AM
hey there gurus, I am a newbie to reporting server...and so i have a nice question for you gurus. I have a subreport, which is based on to parameters. now the problem is that in some special cases these parameters are empty. so for that I would love to hide the subreport in case paramet...more >>


DevelopmentNow Blog