all groups > sql server reporting services > may 2006 > threads for wednesday may 17
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
how to change database at runtime?
Posted by Lori at 5/17/2006 6:36:58 PM
Hello,
Our customers often have 2 or more databases with the same structure.
How can we pass the database as a parameter at runtime in Reporting Services
2005?
Thank you,
Loreaca
... more >>
Installing RS
Posted by Lisa Calla at 5/17/2006 4:33:05 PM
I'm trying to install sql server reporting services for sql server 2000 on
my Win2003 server. In the system prerequisite check, I get the warning 'IIS
is either not installed or not configured for a server component
installation.' Well, IIS is installed (I can get my default page from
http... more >>
GROUP BY on same line?
Posted by Pieter Coucke at 5/17/2006 4:16:42 PM
Hi,
I want to do a group by in a Report (RS 2005), but the group by has to be on
the same line. For instance:
Imagine I have a table tblPerson (Name, FirtsName, Country, DateOfBirth,
....)
- Simpson, Homer, USA, 12-12-1970
- Johnson, Bart, Belgium, 05-02-1978
and a tblCars (Brand, Color... more >>
Impersonation Problems on RS WS
Posted by dsabo at 5/17/2006 3:20:02 PM
Hi all,
I'm running RS 2005 on a Win2003 R2 x64 english server. The regional
settings are configured for spanish (venezuela).
When I run Report Manager from IE, everything works ok, but when I tried
to render the same report with the web service it fails, "datatype is not
valid"... more >>
Using Displayname or Description
Posted by NeedToKnow at 5/17/2006 2:46:01 PM
I have a report embedded in another html document. I would like to get the
report name or something to identify the report and render it in the html
document.
It looks like displayname is set in code when you create and render the
report in reportviewer. Is there a way to set this direct... more >>
Report Execution Error
Posted by Roy at 5/17/2006 2:41:08 PM
Hi All,
We have SQL Server 2005 Enterprise installed on Windows Server 2003.
I created a data model from a remote server and deployed the model. When I
browse to the folder and click Report Builder and create the report then
click Run Report I get the following error:
Report Execution Error
... more >>
Upgrading reporting service database from 2000 to 2005 error
Posted by Pete at 5/17/2006 2:17:02 PM
I am trying to upgrade my SQL 2000 reporting service database to 2005. I am
following the direction outlined in SQL Server 2005 Books online, article
number 143724, Migrating reporting Services. When I try to upgrade my
reporting service database I receive the following error, when Upgradin... more >>
Missing Image in PDF Export copy of report
Posted by Elliot Rodriguez at 5/17/2006 1:56:59 PM
I have an ASP.NET application that passes stored procedure params and
generates a dynamic report with one or more Image controls.
The image paths are created with absolute references to their locations in a
separate web directory, the one that the .NET app calls the report from. So
the store... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Can I use data drive subscription on a remote sql standard version
Posted by Joaquin at 5/17/2006 1:19:02 PM
I would like to upgrade our report server to sql 2000 enterprise
edition to be able to use the DD subscriptions.. if I do do upgrade the
server, will I be able to connect to a sql server on another box with
the standard version and continue to use DD subscriptions on that
remote server.
or is... more >>
ReportItems in Page Footer
Posted by Jen Torres at 5/17/2006 12:51:02 PM
I have several text boxes in the page footer of my report, which reference
various ReportItems. The values are displayed correctly when previewing the
report. However, when I print the report the values are not printed. All of
the other textboxes which contain static information is printin... more >>
Display SRS Rendered PDF File in IE inline
Posted by Paul Keegstra at 5/17/2006 12:40:01 PM
Hi,
I have a web application (1.1 framework) that includes several SQL Server
2000 Reporting Services reports as part of the solution. I include in my
application a web form that allows the user to select a report, specify any
applicable parameters, and then run the report.
In my "run... more >>
Oracle Support
Posted by Peter Manse at 5/17/2006 12:05:01 PM
I'm hoping someone at MS is monitoring this and can give us some hope.
Another thread in this forum suggests that Reporting Services Oracle support
is not all there yet. Is this true? If so, what's the plan?
My specific need is to execute Oracle [stored] procedures that take
parameters to ... more >>
The definition of the report 'Main Report' is invalid
Posted by Amy at 5/17/2006 11:34:02 AM
I'm trying to access a custom assembly in repot designer.
I copied the dll to
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PublicAssemblies
In one report (rdlc), I'm able to access the above DLL. I have another
project which has a report (rdlc) but this one cannot access the abov... more >>
how to controll user access in comercial deployment?
Posted by Stephen Lonsdale at 5/17/2006 10:19:02 AM
Hello,
We have used SSAS and SSRS to develop a BI reporting suite for our data
warehouse and would like to deploy this into our customer base, but at the
same time protect our investment.
How do we control or limit the number of users that can use our cubes and
reports? We would like to... more >>
Limitation of Varchar 8000 in executing a dynamic MDX inside stored Procedure
Posted by shagarwal at 5/17/2006 9:00:53 AM
Hi,
I have a Stored Procedure in SQL which build a Long MDX query .Then i
connect to OLAP
and execute the query .The dataset returned is used in Report.
When my dynamic query exceeds the varchar (8000) limit ,
Error that comes :
''Unquoted string in the Query'' .
This error comes ... more >>
how to JOIN data
Posted by Ray at 5/17/2006 6:34:01 AM
Hi,
How is it possible to JOIN between tables from two different sql servers in
a dataset in reports, (using MS reporting services Version 9.00.1399.00)? Can
I use two dataSources in one dataset?
servers 1 is SQL server 2005 and server 2 is SQL server 2000,sp3
is Linked server the only way... more >>
|