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 2006 > threads for friday july 28

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

Re: Launching Report Builder via internet
Posted by Bob Meyers [MSFT] at 7/28/2006 3:27:25 PM
Report Builder is launched using a technology on the client machine called ClickOnce. This technology needs to authenticate to the server in order to download the application files, but it can only do so using the default credentials of the logged-in user on the client. The only two ways this wi...more >>


Using a custom dll to create a dataset
Posted by Michael at 7/28/2006 2:39:01 PM
In the RS data tab, one can create a dataset using text or stored procedure. I've also noticed there is an expression editor option available next to the query string box. Is it possible to call a custom dll that is already referenced by the report to return a dataset to the report? Essenti...more >>

Books
Posted by wnfisba at 7/28/2006 2:32:01 PM
Looking for suggestions on some good books for Reporting Services that will get me up to speed on its functionality. A book with a good index, good for beginners, good reference book; that will hopefully get me up to speed pretty quickly on utilizing Reporting Services. Thanks in advance fo...more >>

Jump to URL - Open New Window
Posted by nat.caserta NO[at]SPAM telelogic.com at 7/28/2006 2:29:52 PM
Hello, I'm still having an issue with opening up a new window on the report server regarding the report designer's -> Jump to URL feature (option) in Advanced - Navigation. This is what I currently have now and I've tried the JavaScript syntax (expression) i've seen on the old boards, but I...more >>

Oracle Stored Procedure Syntax
Posted by John W at Sungard HE at 7/28/2006 2:00:02 PM
I'd like to write a report with a data set that calls an Oracle data source for its result set. I have a package with a procedure that returns a ref cursor as an out variable. What is the syntax for calling this procedure from the Report Designer? Does the out variable with the cursor need ...more >>

Format Negative Number
Posted by Jeannie at 7/28/2006 9:50:28 AM
Does anyone know how I can use the format statement to show -234.00 as (234.00)? ...more >>

How do you show a subreport when there is no data
Posted by Kab at 7/28/2006 9:14:23 AM
I'm created a fix lenght report and i have several subreports. My problem is that if the subreport has no data, it's not displayed. I want to display the subreport all the time, any ideas? ...more >>

Launching Report Builder via internet
Posted by John J. Hughes II at 7/28/2006 9:10:06 AM
I have a copy of report builder exposed to the local LAN and also the internet, currently I am using a dynamic IP for testing in a development environment. I am using windows logon to for security. If I log onto the server from the local lan using the username/pw the report display and I a...more >>



Language syntax used in Report Expression
Posted by Peter at 7/28/2006 8:20:02 AM
Please advise what language syntax is used in report expression. I have two functions used in report expression. I assume VB.net syntax, but... 1. IIF. It is in .net SDK document. 2. FIRST. It is not in .net SDK document. Thanks. Peter...more >>

Troubleshooting "ANONYMOUS LOGON" Failure
Posted by Ken Powers at 7/28/2006 6:57:02 AM
I have what I think is an issue with Reporting Services. We have installed SQL Server 2005 Reporting Services on a Windows 2003 Server. Both SQL Server and Windows 2003 have been upgraded to SP1. My SQL Server is set to report failed login attempts. My EventViewer is constantly reporting...more >>

displaying records in two tables
Posted by venkat.oar NO[at]SPAM gmail.com at 7/28/2006 6:12:04 AM
HI, Need some help in displaying the records in two table( from a single dataset). To be precise i have a dataset which returns say 10 rows, i want to display the odd numbered rows( i mean the alternate rows) in the first table and then the even rows in the second table. I'm using RS 2K. ...more >>

SMTP email delivery problem
Posted by Cynthia at 7/28/2006 6:06:02 AM
Hi I'm trying to config our reporting service to deliver reports by email. In RSReportServer.config, I set up the email delivery potion as follows: <RSEmailDPConfiguration> <SMTPServer>mail.mycompany.com</SMTPServer> <SMTPServerPort>25</SMTPServerPort> <SMTPAccountName></...more >>

Oracle Query
Posted by karlbasson NO[at]SPAM gmail.com at 7/28/2006 3:17:55 AM
Good day I am having trouble with getting an Oracle query right for SQL reporting service. I wrote a front end to execute the query and it works fine. Now the next step is to allow users to get a report on any number of clients. The way I do this for normal SQL Server, is to build SQL wit...more >>

Running Reporting Services under XP
Posted by news-server.houston.rr.com at 7/28/2006 2:00:00 AM
I have SQL Server Developer Edition 2005 installed on my Compaq Presario which is running Windows XP Media Edition. When I try to deploy a report model I get the error message: "A connection could not be made to the report server http://localhost/ReportServer." Under additonal informati...more >>

Passing Report Parameters in SQL RS2005
Posted by Muhammad Naveed Aslam at 7/28/2006 1:58:05 AM
I have developed two reports "MainReport" and "SubReport". I click a value "CountryName" to navigate to detailed view in "SubReport". MainReport passes a Parameter 'CountryName' to SubReport. When I try to run it from report server: after clicking a country name in MainReport I get the foll...more >>


DevelopmentNow Blog