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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|