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 > november 2005 > threads for monday november 14

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

Subreport parameters
Posted by WayCool at 11/14/2005 11:59:30 PM
I am using a subreport that uses two GUID's (uniqueidentifier) as parameters. The parameters are assigned in the parent report as "Fields!My_GUID.Value". The subreport runs correctly outside the parent report with supplied parameters. When I try to run the parent report, I get the error "The exp...more >>


Add New Report Wizard fails
Posted by SAinCA at 11/14/2005 6:00:03 PM
I'm using the Developer version with SP1 and have had to reinstall because the localhost Reports DBs were lost and there's no obvious way to get just two empty DB's created... So, after install, I can edit and deploy to local and Production. BUT: When I use the "Add New Report" wizard i ge...more >>

Can I use 2 different stored procedure in a single report?
Posted by MissQti at 11/14/2005 3:31:03 PM
Can I use 2 different stored procedures in a single report with the same dataset? How so?...more >>

Nested Lists and Printing
Posted by josef NO[at]SPAM wainz.net at 11/14/2005 2:14:23 PM
Is there something I need to do to get Nested Lists to print correctly? When I preview the report, it displays correctly, grouped by Year, Resource and Part. Yet when I print it or even print preview it, instead of printing on one page: Year 2005 Resource A Part 1 Part 2 Part...more >>

Can't get reports to print
Posted by msmolarek NO[at]SPAM community.nospam at 11/14/2005 2:08:04 PM
Hello, We have never been able to get the printing to work on any of our reports using SQL Server Reporting Services SP2. During the time we have been fighting to get this to work we had added on the SP, so we totally rebuilt the machine from scratch, that didn't help. In addition a cou...more >>

patindex that I can use in RS?
Posted by SharinDenver at 11/14/2005 1:09:03 PM
Basically, I am trying this in a table cell expression: =iif(patindex('%-%', Fields!courseName.Value) <> 0,left(Fields!courseName.Value, patindex('%-%', Fields!courseName.Value)-1),Fields!courseName.Value) It errors because it says patindex is not declared. I tried doing this part in m...more >>

Need help with report paramters.
Posted by Rob Edwards at 11/14/2005 1:01:20 PM
I have created a report that calls a stored procedure on Oracle using input parameters. It runs fine with no problems. My client has asked that i provide a list of available values for each parameter. For the first parameter I query a second dataset to get a list of items. For the second ...more >>

Line graph on bar chart
Posted by bobfoc at 11/14/2005 11:34:02 AM
Does anyone know if it is possible to create a graph where a line is on top of a bar chart? I'm using reporting services 2000, cheers bob ...more >>



Ill try this again
Posted by Matt at 11/14/2005 11:33:58 AM
The 'when run' column of the report manager website is blank. the reports have been run. i can also look in the ExecutionLog table of the reporting database and it is properly reflecting the dates and times that a report is run. it is not as important that i can see the times and dates run the...more >>

what this mean? First(Field!
Posted by Henry Chen at 11/14/2005 11:11:02 AM
and where can I find the reference. Please advise. Thanks!...more >>

Dataset Confusion in Reporting Services 2005
Posted by Amos Soma at 11/14/2005 11:05:18 AM
I'm creating a report that gets its data from a dataset returned from a webservice call. I've supplied the URL for the webservice and in my Dataset dialog (in Visual Studio), I've indicated the Comnand Type as 'Text' and my Query String as follows: <Query> <SoapAction>Federation/GetAll<...more >>

HELP with Running value totals
Posted by Susan at 11/14/2005 10:44:08 AM
HI, I have a table created. I need to have static fields. The table has one group, where I use an IIF statement to point the values into one of the three static fields. The reason I am using a table is that I have to show months/loan programs with zero as well. The fixed static fields...more >>

RS Scripting utility does not work with Forms Authentication
Posted by Dawit T. at 11/14/2005 9:59:02 AM
We have successfully implemented Forms Authentication using Custom Security Extension. It works fine except the RS Script Utility unable to deploy reports either locally on the report server itself or remotely from workstation. I could not connect to the report server. The command I used: ...more >>

is VS2005 required for RS2005
Posted by chicagoclone at 11/14/2005 7:15:07 AM
Upgrading to Reporting Services 2005. Does Visual Studio also need to be upgraded to 2005 or can I continue using VS20003?...more >>

Newbie Question accessing values in other data regions
Posted by cg at 11/14/2005 5:35:39 AM
Hi, i have a simple report that has two data regions, i want to use a calculated field in one data region that refers to a field in the other region. how do i achieve this? sql server 2000 RS 2000 regards ...more >>

Integrating Analysis Services 2005 with Reporting Services 2005
Posted by Ralph Watermann at 11/14/2005 12:00:00 AM
Hi, I found an article "Integrating Analysis Services with Reporting Services" (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/RSDSetEx3.asp) for SQL-Server 2000 saying: "Reporting Services 2005 will also add support for server-side aggregates. This featur...more >>

Use datasets from assemblies in reports
Posted by Ralph Watermann at 11/14/2005 12:00:00 AM
Hi, is it possible to call a function inside an assembly that returns a dataset, where normally a SQL or MDX statement is used to retrieve data for a report? Ralph ...more >>


DevelopmentNow Blog