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 > june 2006 > threads for wednesday june 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

A Jump to URL expression Question for a table control
Posted by Hotwheels at 6/28/2006 2:51:01 PM
I have a report that uses the table control, the last column has id's for dealcompanies in it. When the user clicks on any of the other Columns in a row I would like to be able to grab the id from the last column in the row and insert it into the expression for the Jump to url feature. http...more >>


Winform: Launch in PDF Post-Render?
Posted by crferguson NO[at]SPAM gmail.com at 6/28/2006 2:43:33 PM
I'm building a winform application and I've managed to use the Reporting Services webservice to render a report after passing it a parameter, but I can't figure out how launch it in Acrobat after rendering. I've done it in a web app using Response like this: Response.ContentType = "applicatio...more >>

IUSR_Machine account permissions in Report Builder
Posted by Chris at 6/28/2006 2:01:52 PM
We have an ASP.NET application using Forms authentication which launches the Report Builder via an HTML link with the href set to: ReportServer/ReportBuilder/ReportBuilder.application This will launch Report Builder and allow users to create, modify, and save reports. But when the user trie...more >>

Reporting Services 2005 in VS.2005?
Posted by Larry at 6/28/2006 1:20:19 PM
We are on SQL server 2000 (sp4). We have upgraded to Visual Studio 2005 (from .NET 2003) We installed SQL server 2005 reporting services, on a separate machine (separate from the machine that has sql server 2000. But when we open our Visual Studio 2005 IDE, on a client machine, we can't ...more >>

How do I pass user parameter and dates to stored procedured in reporting services
Posted by mountainrental NO[at]SPAM gmail.com at 6/28/2006 1:17:46 PM
Here's my question. I have store procedure sp_whatever it has @login varchar(50) @beginDate varchar(10) @endDate varchar(10) select .... from... where somDate between @beginDate and @endDate AND logged_by=@login. In RS I have: 2 parameters, both are string @start and @end (for date...more >>

HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials.
Posted by bellis at 6/28/2006 11:49:04 AM
We have a SQL reportserver Version 2000 setup on a Windows 2003 Server that is part of a Active Directory Domain. We are able to see the reports using the url http:\\Localhost\Reports but when we try to open a report we get the credentials Popup. We try to enter a User {DomainName}\{UserNam...more >>

Report from multiple databases
Posted by Deki at 6/28/2006 10:01:02 AM
Hello, I'm trying to create 2 reports. I have SQL Server 2000 and Access 2003. Report should be done in Access. There are 4 different databases on same SQL Server. I need report showing: CustomerID AgencyName State TotalDVI TotalDRI TotalVI ...... Totals are cou...more >>

List of Procedures used in RDL on Production site
Posted by LostinSpace at 6/28/2006 9:46:02 AM
Is there a way to search all of the RDL's that have been deployed out to a Reporting Services site? I am looking for what stored procedures are being used on our production reporting site. Any help would be appreciated....more >>



NoRows doesn't work for Subreport
Posted by fanh NO[at]SPAM tycoelectronics.com at 6/28/2006 9:18:58 AM
Hi there, I have one report which has a table with a subreport in it, I put something in the NoRows property of the Table and subreport. If there is no data, I always got error " An internal error occurred on the report server. See the error log for more details". Is NoRows property for subre...more >>

Column Value Lookup
Posted by Terry at 6/28/2006 7:01:02 AM
What is the best way to lookup a value in a column from another data set? I am trying to locate and display the employee name based on the employee id found in another data set. I.E. 13 = Terry Ward 14 = Peter Jackson Thank you....more >>

SSRS2005 - issue with hyperlink in report after sorting table
Posted by pete757 at 6/28/2006 6:12:01 AM
I have a report with user sorting enabled. Each row of the report contains a hyperlink (Jump to Url) of the form: ="javascript:window.open('"+Globals!ReportServerUrl +"?/myreport&rs:Command=Render&rc:toolbar=false&rc:LinkTarget=_self" +"&Action="+Fields!Action_ID.Value +"','_self')" ...more >>


DevelopmentNow Blog