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 > april 2005 > threads for wednesday april 6

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

Report Server Installation Issue
Posted by ejswanson at 4/6/2005 5:15:02 PM
Hi, I followed the article, here is the error I am still recieving: Server Error in '/REPORTSERVER' Application. -------------------------------------------------------------------------------- Security Exception Description: The application attempted to perform an operation not allowed ...more >>

Access denied reports on http://localhost/Reports/
Posted by culam at 4/6/2005 3:55:03 PM
When I access report on: http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fWebCast1%2fLoanMatrix I got error as follow: You are not authorized to view this page But I could acess report on http://localhost/ReportServer OK. Notes: After everything installed, we changed the computer n...more >>

Hiding a row in a table based on whether another row is hidden
Posted by PD at 4/6/2005 2:59:10 PM
Is it possible to determine whether or not another row in a table is visible? The example is in a multiple detail row table, where I want to display a 'header' row (really just another detail row), if any of the other detail rows in the 'section' are visible. Is there some syntax like Repo...more >>

Can't deliver reports in Web Archive format
Posted by spp at 4/6/2005 2:35:30 PM
I can't deliver reports in web archive format using subscriptions. If I choose to send only the link it's working. I used to have SP1 for Reporting Services but I was forced to unintall it because I am using Romanian lang for my reports and all reports with date fields where not working when I...more >>

Delivering expanded reports using Report Manager scheduling
Posted by David Swanson at 4/6/2005 2:31:04 PM
I have a report that in its default state has detail rows hidden. You click the little plus sign and they are visible as expected. The problem is that if you schedule this report, the report is delivered unexpanded which is of very little use for this particular report. Is there a way to ...more >>

How to get non-html format data to open in a new window
Posted by lisa.bogart NO[at]SPAM eds.com at 4/6/2005 2:08:52 PM
I am totally new to reporting services and am struggling with how to accomplish something. I have an aspx page that needs to display the html format version of a report on the bottom portion of the page and then provide a drop down list from which the user can select another format and an expor...more >>

Stacked Bar Chart - Making first stack not appear
Posted by deniseamat at 4/6/2005 1:57:03 PM
I have a stacked bar chart. I have 2 values. My data looks like: VehicleID: 110 Total Hours: 10 Start Hour: 7 My Y axis is 0-23, which represent hours of the day. So what i'm trying to do is start my bar at 7 and go out 10 hours. i didn't see a way to do that. So I thought as a work around, ...more >>

RENDERSTREAM - What am I doing wrong?
Posted by IraD at 4/6/2005 1:45:02 PM
I'm writing my own app that calls the RS Web Service. So far, pretty good, but I can't seem to make RENDERSTREAM Work. Do you have any idea what is wrong with this code? The error I get is that RenderStream can not find the stream.... RenderedReport = myReportService.Render (myReport, Forma...more >>



Even driven Scheduling of report
Posted by Ramdas at 4/6/2005 12:39:06 PM
I would like to run a data driven scheduled report based on an event that happened outside reporting services. How to achieve this? I would like to use some kind of batch program or exe that i can run in my DTS package that could trigger the Schedule. Any suggessions welcome. Thanks Ram...more >>

new to put the parameter in report
Posted by chad at 4/6/2005 12:35:05 PM
Have a report with two datasets. One has the list for the parameter (salesperson_list). The other is a grouped by age / count result that populates the table in the report. Age Group Count 0 - 9 2344 10 - 19 588 etc... How do I put the parameter ...more >>

ReportDesigner.config wrong?
Posted by MJ Taft at 4/6/2005 12:21:04 PM
according to what I read, in order to enable custom assemblies you have to enable them by changing the ReportDesigner.config setting which by default is disabled? I looked in my config file which was installed with whatever defaults because I didnt change anything - I dont see the section in ...more >>

subscriptions/schedules don't run at all, why?
Posted by SteveM at 4/6/2005 11:59:24 AM
I have a number of subscriptions and shared schedules that I set up as a test, but none ever run. Can anyone give me a potential clue as to why? For instance, I set up the shared schedules to a date/time a few minutes into the future, and the "Shared Schedules" page lists the proper date/tim...more >>

Stored Proc parameter name change leads to duplicate variables
Posted by twbanks at 4/6/2005 11:48:06 AM
When I changed the parameter variable names in my stored procedure that is my data source, upon going to preview in Visual Studio, it asks for both the old and new parameters, and will not preview unless all are filled out. How do I remove the old ones? Thanks, Trevor ...more >>

Rendering Extensions
Posted by Deyvisson Oliveira at 4/6/2005 11:27:01 AM
Hello everybody, I need to render my report in a MSWord .doc format, but the default rendering options are only HTML, Excel, Web Archive, PDF, TIFF, CSV and XML. How can I export it to .doc, is there any extension available from Microsoft? The SQL Server Reporting Services SP1 has this extens...more >>

Running reports over the Internet for Anonymous Users
Posted by Nate Dogg at 4/6/2005 10:07:02 AM
I need to have reports available to Internet Users but I keep running into permission problems. I have links to the reports that will allow the user to download the report in PDF form. However it asks them to login. I do not have AD accounts for these users. They are just logged into my we...more >>

URGENT!!!!!! Sarbanes-Oxley says we can't use SA to pass to serve
Posted by Erin at 4/6/2005 9:39:08 AM
Our DBA's have to restrict all SA access. We set up a new sqlrptsvr user which has dbowner to both report server and report temp. We used rsconfig to set the userid to sqlrptsvr / password. I ran iisreset and refreshed the sites. We still get an error of not being able to connect to the da...more >>

How to change SMTP server after installation
Posted by dean at 4/6/2005 9:21:02 AM
How do you change the SMTP server in Reporting Services after installation is complete? Thanks Dean ...more >>

Export to Excel with Mutiple Sheets
Posted by Nat at 4/6/2005 8:37:06 AM
Hi, I have encountered this problem of not being able to export my different sub reports to individual work sheets within excel. I have tried to put Page breaks after each table, as this is all the sub reports contain. Thus after each table a page break is inserted. If I preview the Report,...more >>

Change the default navigation bar
Posted by Bryan Avery at 4/6/2005 7:34:24 AM
Is it possible to change the default navigation bar that appears in Reporting Services? The Navigation bar that allows, page movement, viewing size, Export etc. ...more >>

SRS Service pack 2.0
Posted by Ajay Kumar at 4/6/2005 7:31:09 AM
Hi All, Can any one tell me the tentative date for Relese of SRS Service Pack 2.0 Beta version. As i have to release product which is dependent on the Release of SRS service Pack 2.0 . Pls update me . Thanks in advance Ajay kumar...more >>

SRS Service Pack 2.0
Posted by Ajay Kumar at 4/6/2005 7:27:05 AM
Hi All, Can any one tell me the Tentative release date for SRS service pack 2.0 This is urgent as i have to release a product base on the release of SRS Service Pack 2.0 beta version. Please help Thanks, Ajay kumar...more >>

Connection error after copying an rdl
Posted by Jody Z at 4/6/2005 7:23:04 AM
Whenever I make a copy of an existing report (.rdl) in order to use it as a template for a new report, I get the following error message when I try to preview it: An error has occurred during report processing. Cannot create a connection to data source 'Prospect' Login failed for user '(nul...more >>

Using Passport Authentication.
Posted by Ajay Kumar at 4/6/2005 7:09:01 AM
Hi All, I have created reports and deployed to reporting server. The Report Server is using Anonymous Acess for Internet Access. Now i had a complain from my client that reports is acessiable from any where and they want to Lock down the access to all users who doesn't use the tool...more >>

Store Procs, Temp Tables
Posted by Vanessa at 4/6/2005 4:07:02 AM
Can one run either of these from RS?...more >>

Summing distinct values...
Posted by Vanessa at 4/6/2005 4:05:07 AM
Is there a way of doing this in RS?...more >>

FileShareDelivery Problem - String not a valid boolean
Posted by Dhericean at 4/6/2005 3:19:01 AM
I have a data driven subscription for FileShare delivery. The query supplies all but the UserID, Password, and Write Mode. The test should run 10 reports but when it executes I get (eventually): - Done: 10 processed of 10 total; 10 errors. The ReportServerService_<date>.log file contain...more >>


DevelopmentNow Blog