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 > 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 >>



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 >>


DevelopmentNow Blog