all groups > sql server reporting services > february 2006 > threads for monday february 13
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
Link to a report with parameters
Posted by Pasquale at 2/13/2006 11:57:07 PM
I need to create a report with some parameters for filtering data.
This report must be called by URL link on an Html page.
This link must contains the values of these parameters; I don' want
specify the values when I see the report by clicking on View report button.
Is it possible? How?
What is... more >>
Export problem in Matrix
Posted by Tony at 2/13/2006 6:17:26 PM
I design a report by using Matix with 3 subreport inside it. It is ok for
this report to preview and export to pdf format. But when I try to export to
Excel, I got an error!
The error look like this:
Missing database/matrix in the subreport.
Please help! Thanks!... more >>
Changing domain password hoses subscriptions
Posted by kvanhulle at 2/13/2006 4:33:16 PM
Recently, I was prompted to change my domain password. Changed service
account for SQL and RS (2000 both) and reports and datasource credentials.
Reports run fine. However, getting the infamous "An internal error occurred
on the report server. See the error log for more details." error on all ... more >>
PDF/Excel output is fine, but HTML format crushes IE
Posted by Keith Rome at 2/13/2006 3:38:28 PM
I have a RDL report, very very simple in nature. It is a basic listing report
(uses a Grid, no filters or calculations in the report itself). The query is
not complicated at all, sorting and filtering are applied in the query
directly (no filters). Typical usage of the report brings back rough... more >>
Embedded Code Executing SQL
Posted by Bryan at 2/13/2006 3:18:27 PM
I'm trying to execute a stored procedure in the header section of a report
(so I can't use a dataset in the data tab) using the shared datasource of the
report. Does anyone have a simple example executing SQL from the embedded
code of a report?... more >>
Save Report as PDF
Posted by T.Poplawski at 2/13/2006 2:58:04 PM
Hello!
I have a ASP.NET application in which it is possible to generate a report
depending on some parameters.
I build the url dynamically in the application:
url = "http://server/reportserver/reportname&par1=" & par1 & "&par2=" & par2
and the report opens in a new window.
is it pos... more >>
Printing, User Permissions and RSClientPrint Class
Posted by Azriphale at 2/13/2006 2:41:27 PM
I cannot believe that we are the people to come across this issue but
despite hours of searching I cannot find any clues.
We have a new SRS server installed on win2k3 server with SQL2000 and are now
at the point of unleashing a few users on it. The first thing they tried was
printing some of t... more >>
Shared DSN
Posted by rschiefelbein NO[at]SPAM aimhealth.com at 2/13/2006 2:09:05 PM
Can anyone give insight between Shared vs. NonShared DataSources in SQL
Server Reporting Services 2005 and it being problematic? We have
created a folder that contains one DataSource per server\database and
we point all reports to the appropriate DataSource. For example, if we
have 5 reports t... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Re: Collapse cell if empty and
Posted by Colin at 2/13/2006 1:44:03 PM
Whoops. Sent too quick.
=Iif(IsNothing(Fields!ADDRESS3.Value),True,False)
Part 2 of question. I've got city, state, and zip columns evenly spaced in
a table. How do I get the columns to collapse to the width of their data?
"Colin" <legendsfan@nospam.nospam> wrote in message news:...
> I'm... more >>
Crystal Equivalent in SQL 2K5?
Posted by jason.pileski NO[at]SPAM pacourts.us at 2/13/2006 1:43:11 PM
I have an existing Crystal report that contains a subreport which lists
items across the page rather than down. The subreport has a Header and
Detail section, which are both supressed, and a footer section that is
visible. In the Header section, a field is defined with the following
expression... more >>
ReportServer Exectutionlog
Posted by joia at 2/13/2006 1:23:27 PM
Hi, apart from all the performance information i can extract about reports, i
also want to find information on how many times users have requested
information from Report Manager items such as an Excel file, or an OWC
component. This information is not stored in the default Executionlog tables... more >>
Bind my own DataSet that I get in my WebApp and show in the Reporting Services - is it possible?
Posted by Just D. at 2/13/2006 12:45:15 PM
All,
Does anybody know if I can bind my own DataSet dynamically getting it in my
WebApp and show it in the Reporting Services using the services as a
formatter/viewer of this DataSet - is it possible?
Or all I can do with the RS 2000 is just a new VD for each new report and I
have to use... more >>
Exporting Report to Excel
Posted by sgtpback at 2/13/2006 12:38:23 PM
I'm having a problem exporting a report to Excel. It only save the first 23
lines of the report. If I save it as .csv I get everything. Any ideas?... more >>
Rendering RTF in SQL Server 2005 Reporting Services
Posted by Chris Deyloff at 2/13/2006 11:09:50 AM
We are using SQL Server 2005 Reporting Services and we need to render RTF
text, which is stored in SQL Server, within reports. Does anyone know of a
vendor that has an RTF rendering extension?
p.s. I am suprised this was never in Reporting Services.
... more >>
Reporting Services Eval expired after SP2 installed
Posted by John Peters at 2/13/2006 9:32:54 AM
Can I upgrade to the full version and if so how?
Thanks a million in advance
On my test server RS eval has been running for over a year but on my new
development server I was stupid and loaded the eval version and just
recently installed SP2 and over the weekend it expired. Is there anythi... more >>
Conditional Format
Posted by Carmen at 2/13/2006 8:51:17 AM
I have a report that I would like to highlight some rows in it. I would have
to change the backgound color and set font to bold. The backgound color and
the flag to bold or not would be return by the stored procedure with the
data. For example:
'Gross Sales', 100, 'LightGrey', 'Bold'
'Net ... more >>
NT AUTHORITY\NETWORK SERVICE write permission
Posted by Darren France at 2/13/2006 5:04:29 AM
I am getting the following message when attempting to browse the reports
folder -
The current identity (NT AUTHORITY\NETWORK SERVICE) does not have write
access to 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files'.
along with the following event (apologies, it is ... more >>
Business Intelligence Install
Posted by emsab at 2/13/2006 3:00:01 AM
Hi,
How to install "Business Intelligence" to design SRS Reports?
I thought that this component would be in Visual Studio 2005 or 2003
but i can't find it.
I only try to get the "Report design Project" in Visual Studio.
Thank you
Emmanuel
... more >>
How to avoid login window?
Posted by Diego F. at 2/13/2006 12:00:00 AM
Hello.
How can I avoid to show the login window when I call the report using a URL?
I have deployed some reports and I want to call them from a web application,
just passing the url. The problem is that before showing the report, I have
to enter user and password in a login window.
Is t... more >>
Landscape and portrait
Posted by NDE at 2/13/2006 12:00:00 AM
Hello
I'm new to this newsgroup and I have a question regarding reporting
services.
I will explain what I am trying to accomplish first.
I need to genrerate several reports within one major report.
So, I have a mainReport, which contains a header and a body.
The body contains subrepor... more >>
|