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 > november 2004 > threads for wednesday november 3

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

Errow whilst initializing report server!!!
Posted by Jared Smith via SQLMonster.com at 11/3/2004 8:55:01 PM
I have an urgent problem which I hope someone can help me with. After installation, I was told by the wizard that I needed to initialize the report server manually... So I went to: http://uacl-sql2/reports It redirects to: http://uacl-sql2/reports/Pages/Folder.aspx And I get the foll...more >>


Problem on hiding toolbar when report is being rendered
Posted by Randy Gadingan at 11/3/2004 7:28:02 PM
I'm using url access to preview report and added a rc:Toolbar=false. When I preview the report, the toolbar still shows. Please help. ...more >>

Error when installing Reporting Services in Virtual PC 2004
Posted by Randy Gadingan at 11/3/2004 7:23:02 PM
When I tried installing Reporting Services in Windows Server 2003 under Virtual PC 2004 it displays a message "Error!". I have already installed VS.NET 2003 and SQL Server 2000 with SP3. Please help. ...more >>

Change style for HTML Viewer - toolbar
Posted by Pendula at 11/3/2004 5:58:01 PM
Hi, Is it possible to change properties such background colour for HTML viewer – toolbar? I just want co customise report ‘s look to match our application’s style where report is displayed (we use frames). Thanks ...more >>

Setting a parameterValue to Null
Posted by David V at 11/3/2004 5:06:02 PM
I trying to render a report via a web service, and I am unable to set one of the parameterValues to Null. I've try setting it to Nothing, "Null" and and an empty string, but nothing seems to work. Does anyone have any suggestions. David V...more >>

Reporting Services vs Crystal Enterprise
Posted by Sergio Florez M. at 11/3/2004 4:58:33 PM
Is there an article or web page that gives a good detailed comparison of Reporting Services and Crystal Enterprise? I need some info on this subject and couldn't find anything on the web other than a comparison table in a ppt called "SQL Server 2000 Reporting Services For The Impatient" by Kent ...more >>

Report Losses dynamic text formats when export to PDF/Excel.
Posted by Samuel at 11/3/2004 4:43:02 PM
Hi, Actually I have to dynamically format a text box in a report based on a database field value. For this I put the following formula in the FontWeight property of the textbox. =IIf( Fields!DisplayBitMask.Value AND 2, "Bold", "Normal" ). This works fine for online view (HTML) howev...more >>

Moving Report Manager
Posted by dachrist at 11/3/2004 4:43:02 PM
I need to move the report manager from one computer to another computer. Currently the RS database is on a db server, separate from the report manager. This will stay the same. I need to know what the steps are for moving the Report Manager to this new server, and keep all my folders/sche...more >>



Reporting service Installation issues
Posted by andreab at 11/3/2004 3:48:19 PM
Dear all, i need some help with this problem: i'm trying to install Reporting Services on a win2k IIS server and when it asks me the istance of MSSQL i specify SQL login Account, I insert the sa account with its password. I received the following message: "Login failed for user '(null)'. Reaso...more >>

Need help to format matrix report, please
Posted by Kaisa M. Lindahl at 11/3/2004 2:18:59 PM
Hello all. I have a report showing hours registered for customer and projects, with the following layout: Hours registered Amount + Hours this period - Customer Project 5 500 Project 2 ...more >>

Error: Subreport could not be shown.
Posted by Microsoft PrivateNews at 11/3/2004 1:51:10 PM
Does anyone have an idea what would cause this error when viewing this in Report Manager or thru a subscription to be rendered as a PDF attachment? Subreports view fine through Visual Studio .NET Report project. Thanks in advance. ...more >>

Running a Stored procedure or a query
Posted by TA at 11/3/2004 12:40:03 PM
Hi Guys I woud like to run either a stored procedure before runing the actual report. The stored procedure will create and update a table and on the second run the report query will run and produce the report. Is it possible to achieve this? Regards Tofigh...more >>

temp tables in SP ? it is bug of RS?
Posted by Ing. Branislav Gerzo at 11/3/2004 12:27:29 PM
Hi pals, my whole work stops on this problem. I have to join some results of my stored procedures, so I can't use @table_variable (or don't know how) This definitely should work in RS, I really don't know what's going there (maybe some security issues, or what?): I tried #temp_table - ...more >>

Multiple select in 2005 Beta 2
Posted by chicagoclone at 11/3/2004 12:13:01 PM
I have heard that the ability to do multi-selects (selecting multiple records in a drop down prompt) would be possible in the 2005 version of ssas. I have the Beta 2 version and still do not think it is possible. Any help would be greatly appreciated....more >>

Subreport and paging
Posted by dp at 11/3/2004 11:44:04 AM
I am getting an "An unexpected error occurred in Report Processing" error when attempting to navigate to the next page in a report. The first page of the report comes up in the browser OK but produces the error when clicking on the "next" arrow. The main report uses a subreport that accepts ...more >>

Documentation
Posted by MFRASER at 11/3/2004 11:25:21 AM
Where can I get documentation on the reporting services? How can I find out if I have this installed on my server? ...more >>

maximum limit on results
Posted by Andy S. at 11/3/2004 11:18:47 AM
Is there a maximum limit on results returned? I didn't think so, but I'm seeing only ~3000 rows of a 100,000+ row table in my report. ...more >>

Max # of columns in Excel Export
Posted by david boardman at 11/3/2004 10:44:16 AM
I am exporting a report which consists of one simple table. The data is simply exported to excel. I am noticing that if I add more than 65 columns to the report (i.e. 66 or more) then, after exporting to excel, there is a problem re-sizing the columns in excel. For some reason the data ...more >>

404 on Report Manager
Posted by at 11/3/2004 10:05:43 AM
My report server has been in operation for 2 months now and my report distribution portion works fine. But yesterday I started getting this message "The request failed with HTTP status 404: Object Not Found." on my report manager. 1. Any ideas how to fix it. 2. If it is a reinstall how do I s...more >>

Installation Problem. Please Help.
Posted by David at 11/3/2004 9:13:26 AM
We are having issues installing Reporting Services on a Windows 2000 server with SP4. The database is located on a separate server and is also running Windows 2000 with SP4. At the end of the installation a warning is displayed that says "Setup could not initialize the report server. you mus...more >>

HELP! Report Parameters not working.
Posted by cmcdavid at 11/3/2004 8:54:04 AM
I bought a book, seems good, on Reporting Services. Since I am new to this all, I am on the uphill learning curve. I have a dataset I created and added parameters. After trying to run the report with the new parameters, I always get the same error, "The report parameter ‘SystemName’ has...more >>

Question: 2 decimals
Posted by JIM.H. at 11/3/2004 7:59:03 AM
Hello, I have a number column and I need to show it with 2 decimals, how can I do that? Thanks, Jim...more >>

Format input of date parameter
Posted by Viola at 11/3/2004 7:58:05 AM
I have a report with a datetime parameter. The report users need to be able to input the date in the format dd/mm/yyyy istead of mm/dd/yyyy. Does anyone know how this can be done? Thanks Viola...more >>

Subscription cannot be created ....
Posted by James at 11/3/2004 7:55:02 AM
...because the credentials used to run the report are not stored, the report is using user-defined values, or if a linked report.... This is not the first subscription with a parameterized report that I'm creating, and I cannot figure out why this particular report cannot be subscribed to: ...more >>

Report Layout depending on Rendering Format
Posted by Niklas at 11/3/2004 7:27:04 AM
Can I vary the layout (visibility) depending on the rendering format? Example: If 'PDF' add a title page, if 'HTML' no title page. Thanks...more >>

filtering
Posted by Soan at 11/3/2004 3:54:01 AM
i want to filter one dataset. So i created a filter: CDEC(Fields!Open.Value) >= CDEC(iif( Parameters!Value_Min.Value, Parameters!Value_Min.Value, -10000000)) it seems to work in preview but just there. Does anyone has an idea...more >>

Hide Toolbar does not work
Posted by Manfred Salomon at 11/3/2004 2:23:01 AM
Hello everybody, trying to hide toolbar. &rs:Command=Render&rc:Toolbar=false not works, nothing happens I tried serveral variations of commands. It looks like the reporting server ignore any aditional command in browser. All other things works fine. What can I do? Manfred ...more >>

Installation Reporting services on SQL fail-over cluster
Posted by Martijn at 11/3/2004 1:13:03 AM
Hi, Perhaps a simple question, but I could not find a clear answer in the deployment guide. I want to install SQL Reporting Services on a SQL fail over cluster to be used for MOM Reporting. I was wondering where to run the set up for SRS. Do I run it on the Virtual server or on one (or both...more >>


DevelopmentNow Blog