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 2006 > threads for tuesday november 7

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

SSRS 2005 Report Manager toolbar does nothing
Posted by John A at 11/7/2006 8:44:02 PM
Hi all, I just did a new install of SSRS 200f on a Win 2003 sp1. The database is on another Win 2003 machine the Reporting Server Service is on the machine I am having a problem with. We are running SSL port 443 and I set up the Report Server Virtual directory appropriately for that. The V...more >>


Translation of Report made it with Crystal Reports
Posted by Melitón at 11/7/2006 1:47:02 PM
help, I am trying to translate a report created in Crystal Reports to RDL, but I don't find the way of passing anything as this: To print a column of details on horizontal form inside the row of details of table For example: CONTENT OF DATASET ---------------------------------------- ...more >>

Server report request failed with HTTP status 401: Unauthorized pr
Posted by Brian Orrell at 11/7/2006 1:28:25 PM
Just created a new report that uses report services. I have created the report in the Report Manager website and am able to view it from there. However, when I include a reportviewer control on a page and try to view the page I get the error: "The request failed with HTTP status 401: Unautho...more >>

Help! Report changes behavior based on DataSet Command Type being either Stored Proc or Text
Posted by Matt Ranlett at 11/7/2006 1:19:07 PM
I've got an SSRS 2005 report all laid out but I'm having an odd bit of trouble. I am gathering the data for the report via a stored procedure, and I want some of the report parameters to drive the sproc parameters. When I set my dataset to be of command type Text and I hardcode the param...more >>

Help! Report changes behavior based on DataSet Command Type being either Stored Proc or Text
Posted by Matt Ranlett at 11/7/2006 1:16:49 PM
I've got an SSRS 2005 report all laid out but I'm having an odd bit of trouble. I am gathering the data for the report via a stored procedure, and I want some of the report parameters to drive the sproc parameters. When I set my dataset to be of command type Text and I hardcode the param...more >>

UNION ALL
Posted by Ben Watts at 11/7/2006 11:03:13 AM
I have a UNION All statment that works just fine until I choose 2 values from the paramater. Then it errors out, can someone help? ...more >>

Datasource = SQL 2000 sp2 (Cross-Database-Ownership Chaining?)
Posted by Michelle at 11/7/2006 9:46:01 AM
We have a report in RS 2005, data source uses Windows Integrated Security, Initial Catalog is the database where the stored procedure is. The stored procedure selects data from a different database on the server. This server is running SQL Server 200 sp2 (so pre-Cross-Database-Ownership Chaini...more >>

placing two matrix data regions one below the other without spacin
Posted by Timmo at 11/7/2006 9:21:02 AM
On my report I want to place two matrix data regions, whereas the second matrix data region is placed exactly below the first matrix data region - without spacing. The first matrix shows the data with the numbers for the year 2006 and the second matrix shows exactly the same data but with the...more >>



datepart("dw",Now())
Posted by MS newsgroup at 11/7/2006 9:12:31 AM
the function "datepart(dw, getdate())" works just fine on Microsoft Sql Server Management Studio. However, the function " datepart("dw", Now()) " doesn't work on report. Is there someone who got the idea why it doesn't work? Is there any other function which works same on report? -Ken ...more >>

Reporting Services Roles not seeing presenting AD dialog box
Posted by Fred Lobmeyer at 11/7/2006 7:07:02 AM
Hi, We have installed RS 2K5 & SQL 2K5 on Windows XP with SP2. SQL and RS have all patches applied. When we try and set the permissions on a report that has been uploaded or created we are not able to specify domain users. This causes the report not to be viewable by the end user we are ...more >>

Error accessing ssrs2005 reports mgr from mgmt studio
Posted by glennl at 11/7/2006 6:40:02 AM
Hi! What's the proper format for "Server name" when attempting to connect to reporting services from ss2005 mgmt studio. I can successfully connect via ie7 with url http://servername/reports but when I try via mgmt studo I get the following behaviors: If I use just the servername (like ...more >>

Multiple data sources
Posted by Chubbly Geezer at 11/7/2006 12:00:00 AM
If I write an SQL query I can select data from various database from within the same query. Any idea how I can do that when creating a SRS report.? Thanks ...more >>

Rotate table (or sort data for graphic)
Posted by bala nemate at 11/7/2006 12:00:00 AM
Hello, We have to make report from table, witch has columns named PropertyValue = and PropertyName. Is these colums are all data... like: PropertyValue PropertyName pTemperature 22 pPreasure 11 pOperator OperName pTemperature 27 pPreasure 23 pOperator OperName pTemper...more >>


DevelopmentNow Blog