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 > january 2006 > threads for monday january 30

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 31

rkeymgmt question
Posted by Prashant Kumar [MSFT] at 1/30/2006 9:24:37 PM
Hi, This question pertains to Reporting Services 2000. As per http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_dbadmin_v1_98xh.asp, after doing a rskeymgmt -d, I need to perform 4 steps. I understand 1. 2 and 3 in the article. Can someone help me with the 4t...more >>

Query from within Excel
Posted by Preacher Man at 1/30/2006 4:56:27 PM
I have a need for some query help and I will try to explain my situation. Thanks in advance for any help. I have an Excel spreadsheet that has two different sheets. One one sheet called "Data" I have created a query that pulls AP Invoices from from a SQL database. In the results of this q...more >>

Creating ODBC link within SELECT statement
Posted by Preacher Man at 1/30/2006 4:43:57 PM
Is this possible. To explain myself, here is my situation. I created an Excel Spreadsheet that uses an ODBC link to a SQL database. In order for anyone to use this file on their PC, that same ODBC link must be setup. Is their some code I can use within a Select Statement that will allow me...more >>

report server no longer sends emails
Posted by Stacey at 1/30/2006 4:15:37 PM
We had to change the administrator password recently. So I took the opportunity and created a sql user (yes.. it is domain admin) and moved the sql and reporting services to run under this user instead of administrator. Since this time, my report server doesn't send out the reports via email. ...more >>

Culture Settings Problem
Posted by Ed Allison at 1/30/2006 4:00:04 PM
Hi everyone, My name is Ed Allison. I am very new to reporting services (about 2 weeks, in between working on a lot of other stuff), and have had no luck attempting to track down a particular problem. I am running Visual Studio 2005 and Reporting Services 2005 on Windows XP (fully servi...more >>

How to implement floating headers and/or columns
Posted by Ashok G at 1/30/2006 3:35:27 PM
Hello, I have read in a number of Powerpoint presentation from MS folks that we have the ability to implement floating headers and/or column, similar to freezing panes in Excel. Could somebody please point me to the article/link that explains how to implement this? Thanks in advance ...more >>

Same report - two different directories?
Posted by Scott Baker at 1/30/2006 3:10:14 PM
Is it possible to reference the same report from two different directories? Please advise. Thanks, Scott A. Baker OraSure Technologies, Inc. ...more >>

Does SSRS support sProcs that return multiple tables?
Posted by JDP NO[at]SPAM Work at 1/30/2006 12:19:54 PM
I'm porting an ASP.Net report(s) to SSRS. I have an sProc that returns meta-data about the result set in table(0) and the actual data in table(1). How do, or can I display table(1), the second table in my result set? TIA JeffP.... ...more >>



Extra white space in table
Posted by Mathias at 1/30/2006 11:53:08 AM
I've got a table with a header, group, and detail row. The detail row is collaspable however when it's collasped there is several lines of white space between the parent groups. How do I get rid of this white space? Thanks in advance for the help ...more >>

multiple prompts problem
Posted by bosstan1 NO[at]SPAM gmail.com at 1/30/2006 10:45:53 AM
I have a report with multiple prompts. Every prompt based on separate stored procedure with default value "All". If I'm running it via Report Designer everything works fine. However, if I'm trying to run it via Report Manager only one prompt display default "All" , all other prompts do not hav...more >>

Batch Printing
Posted by Curtis at 1/30/2006 10:07:05 AM
I have a report called Report1 that has 1 parameter called Parm1 and there are 296 choices for Parm1. Is there anyway to create a batch job to run this report for all 296 choices and send to .PDF? ...more >>

How to calculate distinct count per group?
Posted by ob at 1/30/2006 9:06:51 AM
I have Department group and want to count how many distinctive customers we have in each of them: I placed this formula in group footer :=countDistinct(Fields!Customers.Value,"Department") but it shows me total number of customers in each row. Oleg ...more >>

checkboxes and exporting to PDF
Posted by jagb at 1/30/2006 12:00:00 AM
How do you mange to create checkboxes on your reports? Since there is no builting support for checkboxes, I have tried using: Windings font: =IIf(Fields!MyBooleanField.Value=False,ChrW(&h006F),ChrW(&h00FE)) that would give me the empty square and the ticked square (when previewed in dhtm...more >>


DevelopmentNow Blog