all groups > sql server reporting services > july 2005 > threads for thursday july 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 31
Cannot create subscription in with Report Manager
Posted by mbianco21 at 7/7/2005 5:55:04 PM
While on the Report Delivery Options page if I click "Select Schedule" or
"OK" nothing happens; no error message, no postback, nothing in the logs,
nothing in a SQL Trace. I cannot create a File Share nor an e-mail
subcription.
I am able to programmaticaly (using ReportServer WebService an... more >>
Install doesnt recognize SSL
Posted by MS-News at 7/7/2005 4:44:50 PM
I put SSL on my server(rapidssl) but the setup tells me no SSL. Anybody
experience this error?
OS is windows2003 server No SP1 installed on this server.
thanks
craig
... more >>
Removing the spaces left by hidden columns or rows
Posted by Jim Campbell at 7/7/2005 3:29:02 PM
I have written a comprehensive report that is used as a subreport for many
others. The comprehensive report supports dynamic grouping and the dynamic
hiding of columns or rows.
My problem is that if a column is hidden, a huge gap is seen in the report
where the column is hidden.
A... more >>
401 : Unauthorized
Posted by John Holt at 7/7/2005 2:48:03 PM
Having a hard time finding this one. Have gone as far as having everyone-
full control.
w2k3
rssp2
Any ideas anyone???
System.Net.WebException: The request failed with HTTP status 401:
Unauthorized.
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMes... more >>
HELP!! Err whn changing Stored Proc used
Posted by MJ Taft at 7/7/2005 2:41:01 PM
We had to make a change to a stored procedure and wanted to test out the
change. So made a test version of the sp (all done correctly and verified by
dba). I changed the name of the stored proc used in my report to be the test
version. I could run the sp fine from the data tab and it picked... more >>
Access Reports using IP Address
Posted by MSRS at 7/7/2005 2:21:42 PM
I have the following going on: A win 2k3 server running sql server and
reporting services. I have IIS configured on it and can run reports
internally on my network but when I try to access a report from the web I
get
nothing back. I can access Folders List and other properties of any selected
r... more >>
RS SP2 Install Hell
Posted by GH at 7/7/2005 2:07:03 PM
Configuration: IIS Server on Win Server 2003, SQL Server 2000 SP4 on Win
Server 2004
Was able to install RS on IIS Server with command line using setup.exe
RSSETUPACCOUNT=sa RSSETUPPASSWORD=’sapw’.
Then ran rsconfig –c –m’reportserver servername’ -s ‘SQLServer machine nam... more >>
Number of pages displayed and printed do not match
Posted by BF at 7/7/2005 1:23:02 PM
I have a report in landscape layout because I have many columns to display.
When I display this report in browser, I see there are 2 pages for this
report. But when I click the print button on page to print it, I got 4 pages
because it's printed in landscape format on paper. Now QA logged this... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Chart Question
Posted by RP at 7/7/2005 12:44:02 PM
Hi,
I am kind of grouping some data into series.
My question is :
1. How can i change different colors for the series ? (1 color for each)
2. How can i adjust the space between one series and the other.
(right now they are evenly spced out and are very small to see)
Thanks
RP
... more >>
Running a report file directly
Posted by McGeeky at 7/7/2005 12:23:24 PM
Is it possible to run a report file directly without having to publish it to
the report server first?
Thanks
--
McGeeky
http://mcgeeky.blogspot.com
... more >>
Report vs software
Posted by Zurga at 7/7/2005 10:00:01 AM
Hello,
I'm new in this issue of reporting.
Can some one tell me if is it necessary the installation of Visual Studio
..NET in the PC of a end user so he can exctract dinamic reports?
Besta Regars
Thanks
... more >>
Temporary tables and the Report Wizard
Posted by Keith at 7/7/2005 9:18:02 AM
I have learned that by using the report wizard, RS does not like temporary
tables from stored procedures. When I created a report without the wizard I
am successful in using a SP with temporary tables. Is this by design, has
this issue been fixed, or when will it be fixed?
===============... more >>
Bug?? Implicit conversion from sql_variant to datetime is not allowed
Posted by kentverbal NO[at]SPAM gmail.com at 7/7/2005 9:13:04 AM
Greetings,
/* sample SP code
CREATE PROCEDURE dbo.GETSomeDateMoneyRange
@BegDate datetime,
@EndDate datetime,
@MinAmount money,
@MaxAmount money
AS
BEGIN
SELECT *
FROM Contacts
WHERE EntryDate BETWEEN @BegDate AND @EndDate
AND ContributionAmount BETWEEN @MinAmount AND @MaxAmount
... more >>
Image rendering in IE
Posted by ACC365 at 7/7/2005 9:13:02 AM
Hi All,
I cannot get any of my images to display in reports. I have tried all type
of image storage..embedded, external and database and they preview ok but
when i display the report through report manager or URL, the images will not
show. Any ideas?
regards... more >>
reportingservice.render does not work - path not found?
Posted by nickpup at 7/7/2005 7:36:01 AM
I am having problems getting a call to ReportingService.render to work. I
keep getting this error:
System.Web.Services.Protocols.SoapException: The path of the item
'/ReportServer/report%20project1?%2fReport+Project1%2fReport1' is not
valid. The full path must be less than 260 characters lon... more >>
Images will not show in report
Posted by Eric Gnagey at 7/7/2005 6:53:06 AM
I am trying to add a Company Logo image to my report and it will not render.
I have tried to add it all three ways, but still no luck. Is there something
that I am missing???
I can see the image when I preview the report locally, but when I deploy the
report to the sever, I cannot view ... more >>
Deserialization failed
Posted by SmogerP at 7/7/2005 5:30:02 AM
I am trying to set the <Top> value of an image thru code.
<Image Name="Marker">
<ZIndex>35</ZIndex>
<Height>0.14583in</Height>
<Width>0.15625in</Width>
<Source>Embedded</Source>
<Style />
<Value>marker</Value>
<Top>=Code.GetPo... more >>
Multi valued parameter
Posted by collie at 7/7/2005 3:51:01 AM
Hi,
I have a parameter that can accept multiple values. I want the values that
the user selected to be displayed in the report for example if user selected
for favourite colour: red,blue,pink then the report must display in a textbox
the 3 colours.
Currently, it only displays one colour in... more >>
SSL Trouble with Reporting Services
Posted by Ian at 7/7/2005 1:53:34 AM
Hi all!
I've been given the task of installing RS to see whether or not it's
feasible to change from Crystal Reports or not. At the moment I've got
it setup on my own development machine running Windows XP sp2, SQL
Server 2K dev sp4, IIS 5.1 and RS 2000 sp2. The problem arose when
using SSL... more >>
How do you open linked report in new window?
Posted by DaveW at 7/7/2005 1:18:05 AM
I am trying to set up linked reports to open in a new window using the
standard reporting tools and report manager. After reading a number of
comments from people in this group I found that I could not use the
rc:LinkTarget=_blank option at the end of our URLs as this will not work on
the ma... more >>
cascading parameters in Webpart
Posted by r388042 at 7/7/2005 1:02:03 AM
Hi,
In a Webpart, I have a report with 2 parameters.. the second parameter is
dependent on the first parameter.. I have noticed that when I changed the
first parameter, the values of the second parameter doesn't changed.., so I
got an error..
Can anybody help me?
... more >>
Cell1 = Cell2
Posted by rob.farley NO[at]SPAM jeyes.co-dot-uk.no-spam.invalid at 7/7/2005 1:00:30 AM
I'm pulling my hair out now... What am I doing wrong
OK..
Header1 | Header
----------+----------
cell1 | cell
Very basic table layout..
If Cell1 is just a field value I can do cell2 = reportitems!cell1 an
it works find. However, if Cell1 is a calculation that's slightl
complex an... more >>
Complete Newbie Question
Posted by JimW13UK at 7/7/2005 12:43:16 AM
I have just installed Reporting Services and created a few reports that
I want to run in a web page - that seems easy enough to do but my boss
has asked me to provide a batch reporting solution.
He wants users to be able to request a report and the request be
written away to a sql db. I have a w... more >>
Download SQL Reporting Services
Posted by sam at 7/7/2005 12:00:00 AM
Where can I download SQL Server 2000 Reporting Service?
Yes, I had license of MS SQL Server 2000
... more >>
Free SQL Reporting Services or license?
Posted by sam at 7/7/2005 12:00:00 AM
I had attended course 2030 creating report using MS SQL Server Reporting
Service and I wonder how do I get this tool? Free or license?
I had license MS SQL Server 2000 and do I need to purchase or request MS SQL
Server 2000 Reporting Service?
Please advise.
... more >>
|