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

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

Report builder - open error - (401) Unauthorized.
Posted by Kenny Cheng at 2/7/2006 11:26:32 PM
Hi, Does anyone have similar error for Report Builder? It seems odd for the messages. I don't know what is going wrong after the installation. Many thanks. Kenny kenny_tm_cheng@hotmail.com ============= PLATFORM VERSION INFO Windows : 5.1.2600.131072 (Win32NT) Common Language ...more >>

Exporting Reporting Data to MS Access
Posted by kishore.lakkimsetty NO[at]SPAM wipro.com at 2/7/2006 10:56:48 PM
Is it possible Reporting data to MS Access. As such it is possible to export data from Report Manager to MS Excel, PDF, HTML etc. Now I have a situation in my project to export data from Report Manager to MS Access. Is this possible programmatically or in any manner? ...more >>

Reporting Services Configuration Manager Error #2
Posted by Amos Soma at 2/7/2006 8:23:26 PM
I am attempting to configure my Report Server (2005). In the Reporting Services Configuration Manager, the Web Service Identity has a red 'X' next to it. When I click on it I see 'LocalSystem' entered in he ASP.Net Service Account field. When I click on the Apply button, I get an error. The text ...more >>

Chart does not show up untill cookies allowed
Posted by Magas at 2/7/2006 7:59:28 PM
We have web server with web application on one server and SQL Server with Reporting Services on another. We try to implement reporting on internet, but for some reason charts in reports not displayed untill cookies from Reporting Services server (not web server) on client side are not enabled....more >>

SQl Reporting to be view using a PDA or mobile phone
Posted by cuban NO[at]SPAM nospamexecpc.com at 2/7/2006 5:24:59 PM
Good Morning to all I want to know if its posible to create a reporting in sql Reporting 2000, that can be view using a PDA or a mobile phone. If so , do I need to do anything differents. thank you Tomas...more >>

Custom Properties and PDF Properties
Posted by D Redfield at 2/7/2006 4:13:25 PM
We need to generate PDF files as our end point. These files must contain 'custom properties' (such as Author, Title, 'What Have You') which will be used to index the documents for searches. We will generate our reports using Reporting Services and then 'export' them to PDF format. We are not ...more >>

dumb question
Posted by Scotchy at 2/7/2006 3:55:27 PM
Hi all, yes this is a dumb question, but I cant find a formatting answer... A zero value eg 0, or 0.0 is supressed on RS reports by default. How can I stop this, the report must show all zeros regardless in a total field. If I use default as the format type then I will see 0, but as the fi...more >>

Stuck Like Chuck
Posted by Ksorrell via SQLMonster.com at 2/7/2006 3:40:20 PM
Hi all, SSRS2000 with VS.net I was wondering if there is a to get two datasets on the same table with custom code? I have tried to do a subreport but it is not grouping like I need it to. And I can not get it all on the same dataset because it is bring in duplicate data. I was told that my ...more >>



Trigger a process from RS
Posted by Daniel Portal at 2/7/2006 2:38:16 PM
Hi there, I need to trigger a .NET process (I mean, a method from a Class I developed) when I first start a certain report. Does anyone knows how to do it? Thanks Daniel Portal ...more >>

Encrypting subscription generated emails SSRS 2000 or 2005
Posted by jp at 2/7/2006 1:03:27 PM
I need to be able to encrypt emails and/or attachments that are generated by subscriptions but I have been able to find a way to set this attribute the same way you can with traditional emails. Any pointers would be very appreciated -- John Shahan...more >>

Anybody use the WinForms ReportViewer?
Posted by jhcorey NO[at]SPAM yahoo.com at 2/7/2006 12:40:08 PM
My issue is one-click printing using a programmed format. For example I have reports that print landscape on legal paper. I have not been able to do this from the web environment, and I'm hoping that the WinForm ReportViewer control will allow me. It should be simple enough to try this, but i...more >>

Reporting Svcs - stored procedure
Posted by Lynn at 2/7/2006 12:10:31 PM
Hi. I have a need to create a number of different reports via Reporting Services. All of which are based on stored procedures, none of which require any parameters. Most if not all of the report is calculated. I am struggling badly to get even the most basic of the fields in place w/the ...more >>

HTML tags?
Posted by David at 2/7/2006 12:07:28 PM
Can reports using Reporting Services 2000, use HTML tags within the text? For instance, if I have "<b>text</b>" in my database, will text be bold in the report?...more >>

Conditional Sum Statement
Posted by Jimmy V at 2/7/2006 10:57:36 AM
Hey all, Quick question, I have a field that I need to sum only when another field is a certan value. For example, a dataset with 5 fields {row_id, dealer_id, rep_id, sales_code, sales_amt} and grouped by dealer_id then rep_id, I would want to sum the sales_amt field when the first character ...more >>

Sure do wish I knew what I was doing
Posted by Kerrie at 2/7/2006 10:47:54 AM
Hi all, SSRS 2000 with VS.net I have been working on the same problem for a while now. Is there a way to make a subreport to only bring back one value for each group on the parent report? I get all the values from the subreport repeating for each value on the parent report. I hope that m...more >>

session state in web farm
Posted by Marvin at 2/7/2006 9:31:29 AM
We'll be using rs 2000 in a web farm using forms authentication. Does reporting services use session state in IIS, asp_process, or sql, or none....more >>

Any news on different browsers?
Posted by jhcorey NO[at]SPAM yahoo.com at 2/7/2006 8:45:12 AM
I'm using the ReportViewer web control and RS 2005 and notice that reports don't come close to rendering correctly in FireFox. I had read posts concerning RS2000 and was thinking that maybe the new release would be compatible with browsers other than IE. Does anybody know of (1) any techniq...more >>

Producing reports on a web page
Posted by Todd Jaspers at 2/7/2006 8:11:29 AM
Hi, I'm a bit unfamiliar with report distribution and whatnot. I've been reading up on MS SQL Reporting Services and from what I can see they offer a report repository as well as a a web based portal for downloading the reports. The company I work for is currently using the following: • ...more >>

How to display KPI from Analysis Services in Reporting Services
Posted by Tomilee at 2/7/2006 8:11:27 AM
Hello I'm wondering how you can display KPI within Reporting Services. I know this is possible by creating a dataset on the data tab in a Visual Studio 2005 reporting services project, but I dont know how to display this data on the layout tab to come close to the browser View in Analysis ...more >>

RS2000 Cannot find server or DNS
Posted by Reinfried at 2/7/2006 7:49:30 AM
I have installed Reporting Services 2000 SP2 and Windows Server2000 SP4. At first access from the Client-PC (Windows XP SP2) with http://myserver/Reports I get always a "Cannot find server or DNS" error. With Second Start Internet Explorer with http://myserver/Reports the ReportServer wo...more >>

Managing user-defined properties for report items
Posted by MichaelS at 2/7/2006 7:33:54 AM
[crossposted to MS Community forums as well] I have defined a user-defined property for several reports. The coding for GetProperty/SetProperty is straightforward, but it looks as if there is no management/admin capability through Report Manager or SQL Management Studio for user-defined proper...more >>

Can't find Report Viewer/Explorer WebPart (SP v3+SQL 2005)
Posted by Marc at 2/7/2006 6:55:42 AM
Hello all, I'm new with SP v3 and the Reporting Services of SQL Server 2005. I did a prototyp report and show it with "SQL Reporting Services Report"-WebPart, but I can't find the WebParts Report Viewer and Explorer in the WebPart Gallery. Please, could somebody give me a clue where the...more >>

SQL Server Reporting Services 2005
Posted by TVanover at 2/7/2006 3:42:31 AM
I need to know the underlying usage of the connections in Reporting Services. Are these granted as a session based isolated instance for each report or does the connection get put into some ODBC type pooling? How should I plan for large numbers of concurrent users so that the connection is no...more >>


DevelopmentNow Blog