all groups > sql server reporting services > october 2005 > threads for monday october 31
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
Blank Pages following report
Posted by Rick via SQLMonster.com at 10/31/2005 10:17:39 PM
I have a report that uses 7 subreports. Some reports show, some don't
depending on the data received from the Shared Datasource. My initial report
appears fine in the viewer, however I have a single page following the last
page with data containing only the header. When I create a pdf, I have... more >>
Reporting Services Database not supported by my instance of sql se
Posted by Rich at 10/31/2005 10:14:01 PM
Hello,
I downloaded the trial version of Sql Server Reporting Services from
http://www.microsoft.com/downloads/details.aspx?FamilyId=BA517C01-2E2F-4BC7-84AF-149B7637F807&displaylang=en
But when I try to install the service I get the error message that the
instance of Sql Server that I am... more >>
Install RS for multiple websites on single computer
Posted by Dilip Kumar at 10/31/2005 6:38:09 PM
My understanding is that RS installs ONLY on the default website. I'm hosting
four websites on a single IIS computer. I want to use Reporting Services
separately on each of the websites. That is, each will have its own database
and its own set of reports. Is this possible? How?
Thanks.
Dil... more >>
Make RS the default website in RS 2005
Posted by Bruce L-C [MVP] at 10/31/2005 2:15:44 PM
When installing RS 2000 I did not have to do anything to have RS be the
default website for the server. For instance, I could put in http://myserver
and it would re-direct to http://myserver/Reports/Pages/Folder.aspx
I have gone into IIS Manager attempting to set the default appropriately but... more >>
RS 2005 Prompts for User
Posted by Bruce L-C [MVP] at 10/31/2005 2:12:11 PM
I did a default new install of RS 2005. I am not using SSL. The server is
Windows 2003 with SP1. I have not done anything with roles. I am connecting
to reports from my computer. My domain/user is part of the administrators
account on the server. The server is not a domain controller. Default ... more >>
Avoid User Login
Posted by Wayne Wengert at 10/31/2005 1:33:21 PM
I have an ASP.NET application that includes a Report Viewer form. The user
clicks on a radio button list item to sekect the report to be viewed. The
system requires the user to enter a userid and password to view the report.
Is there a way to simply have the report display? I do not want user... more >>
Size Chart Dynamically in RS2005
Posted by Jason L Lind at 10/31/2005 12:12:02 PM
Hi, I am trying to size a chart dynamically with respect to the number of
rows in the data set it is rendering from (it's a bar chart) so that the
graphic will render appropriatley.
Is there any way to do this?
Thank you,
Jason Lind... more >>
Default Parameter Values
Posted by Vinny Vinn at 10/31/2005 12:03:01 PM
How can i have the user run a report in which the user may or may not select
a value for the parameter?I dont want to set a default value for the
parameter because that would limit the results of the query to whatever value
you set as the default.
I tried Robert Bruckner of [MSFT] suggestio... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Set PDF security options on export from SRS?
Posted by Tom Garrity at 10/31/2005 11:51:43 AM
Is it possible to set permissions on a PDF export from SRS to prevent changes
to the document?
I'm looking for functionality like within Acrobat's menu: Document ->
Security -> Restrict Opening and Editing... more >>
Drill down problem, report jumps to top of table!
Posted by l.holmes at 10/31/2005 11:37:40 AM
Hi
I have a report with a table which has two groups. Each group is collapsed
by default when the report loads. When I click on the first group expand
icon (+) the group expands but also the report jumps up the screen so that
the top of my first data row in my table is alligned to the top o... more >>
Problem in RTM Version
Posted by Tom at 10/31/2005 8:29:05 AM
After installing the RTM version of SQL 2005, I have noticed a problem. I
cannot add an SSIS datareader as a datasource type. In fact, SSIS does not
appear in the drop-down list. I uncommented the SSIS data reader extension in
the rsreportserver.config file, but it still will not allow me to s... more >>
Inconsistent Subscription Success
Posted by richard.warner NO[at]SPAM zurich.com at 10/31/2005 7:57:05 AM
Hi,
I've got a production SQL Reporting Services installation and have
created some file share subscriptions for one of the reports.
Sometimes the subscriptions work and sometimes they don't. My customer
has now had enough and wants to have them working all of the time
(unsurprisingly!).
... more >>
RS2005 - Response Time
Posted by Terry at 10/31/2005 7:01:06 AM
When running a report in VS, the report run fast but when running the same
report via the browser (<servername>\reportserver), the report runs slow.
How can I increase the response time in running the report via the browser?
Thank you.... more >>
Group by expiration date
Posted by Jeff Metcalf at 10/31/2005 6:49:08 AM
Is there a way to get this down to one select statement and group it as such
in Reporting services?
select custnmbr,contnbr,enddate,Cast(total as Money) from svc00600
where enddate >=getdate() and enddate <=getdate()+30
order by enddate asc
select custnmbr,contnbr,enddate,Cast(total as Mon... more >>
Installing RS 2005 support for Visual Studio 2003
Posted by Ryan at 10/31/2005 4:23:21 AM
Hi All,
Does anyone know if it is possible to author RS 2005 reports using
Visual Studio 2003? I ask because I installed both SQL 2005 and Visual
Studio 2005 recently but support for designing or compiling reports in
VS 2003 has been removed by the installation.
My project in VS 2003 now fa... more >>
|