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 > 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 >>



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 >>


DevelopmentNow Blog