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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|