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 > december 2004 > threads for thursday december 23

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

Footer problems
Posted by Jim at 12/23/2004 11:30:59 AM
Hi all, I've got a couple of problems with some reports that I'm developing: 1) I'm trying to print a Group Footer at the bottom of the page in a fixed position, regardless of how many detail records there are. Is there a way to do this? 2) I have another report that is supposed to giv...more >>


Using Action Items
Posted by Asim at 12/23/2004 11:11:03 AM
I am trying to refer a field using ACTION ITEM property and selecting JUMP TO option. I am trying to create a linked field which if clicked will open up a new report and passing this field as a parameter. How can i set up the values of the other reports parameter in this report. Thanks Asim...more >>

maximum width
Posted by Bucky at 12/23/2004 10:27:39 AM
When loading a report that another developer created, I got an error message saying that the deserialization failed because the width value needs to be between 0 and 85.3333 in. I was able to get around this by opening the RDL file in notepad and changing the width values manually. But my qu...more >>

producing a report that lists 1 record per page
Posted by zero at 12/23/2004 9:55:33 AM
Greetings, I am creating a report using VS.NET and SQL Reporting services. The report I have created is detailed and has images and lines etc. I tied this report to a stored proc that returns back 7 records in a result set. When I view the report, the results list out downwards on a page i...more >>

unexpected Error in Production
Posted by RK Balaji at 12/23/2004 9:05:03 AM
We received the following error on reporting server in production this morning. I would like know if this is a known issue or what can be done to prevent this from happening.. Following this error, the connection to the report server database from the report server was lost for a brief moment....more >>

Strange charting behaviour
Posted by Mark Allison at 12/23/2004 8:46:18 AM
Hi guys, I have just built my first RS report and when I preview it I get the this image: http://tinyurl.com/4lfqv My query in the dataset is this: select DBName,statsdate,avg(space_used) as space_used from DBAConfig.dbo.All_Usage_History where Server = @Server group by DBName,statsd...more >>

how to change the user of the application pool and keep RS to work?
Posted by Jéjé at 12/23/2004 8:32:29 AM
Hi, actually my application pool run under the network user, but I have to change this to a specific user. When I change my application pool, RS stop working. How to do this? What are the required steps? Thanks. Jerome. ...more >>

Average problem
Posted by Seb at 12/23/2004 7:19:03 AM
Hi, I've a subtotal row in a matrix. I do an average of a column but the avg function return me the average of all results of each rows. In fact, I want do the average of each colums except where the results is equal to 0. How can I do that?...more >>



GUID in parameter causes 'Invalid URI: The hostname could not be parsed'
Posted by Jeremy M. White at 12/23/2004 7:11:42 AM
I have a report in which I have a GUID as a parameter. This has worked fine until I ran across one instance where I get the following error: ======================================================================================================= Exception of type Microsoft.ReportingServices.Re...more >>

rskeymgmt error (local NT service is disabled)
Posted by Zehra Kendir at 12/23/2004 5:53:03 AM
hello, I am trying to install the full versinon of reporting services. When I try to backup the symmetric key using RSKeyMgmt.exe it gives the error : "System.Exception: The local NT Service is disabled 0x80090005 ---> System.E xception: 0x80090005 --- End of inner exception stac...more >>

List
Posted by Mike Klaarhamer at 12/23/2004 4:29:02 AM
Hi, I would like to create a dynamic legenda. Like this: ATV=Arbeids Tijd Verkorting, BV=Buitengewoon verlof, CRS=Cursus, DET=Detachering, DIV=Diversen, DR=Dienstreis, ESV=Externe steunverlening, FV=Flex Verlof, GER=Gereserveerd, HSP=Hospitaal, ISV=Interne steunverlening, KAZ=Kazernedienst, ...more >>

Custom Format
Posted by Seb at 12/23/2004 3:17:03 AM
Hi, I've a problem. I get some decimals data from by database like 123,45 and I'd like to create a custom format to print in my reports the decimals like 123,45 €. If I've 0 in database I'd like print as 0,00 € How can I do that? Thanks ...more >>

Export to Excel. Version Problem
Posted by Ale Dori at 12/23/2004 2:19:03 AM
when I try to eport a report in EXCEL format it only works on client with EXCEL XP installed. With EXCEL 2000 it dosn't work correctly. Anyone knows if there are EXCEL version Requirements?? Thenks...more >>

Import & Export
Posted by עידן at 12/23/2004 2:09:07 AM
Hi, I'm using Reporting Services and MOM 2005. How can I import existing reports to Visual Studio for design mode?...more >>

Average in Matrix
Posted by Mike Klaarhamer at 12/23/2004 2:09:04 AM
Hi Everyone! I have a question about a matrix in RS. Its possible to add a Subtotal to a matrix bij right-clicking and Add Subtotal: PAUL | 1 MIKE | 4 JOSE | 8 TOTAL | 13 But how can i get the average in this matrix like: PAUL | 1 MIKE | 4 JOSE | ...more >>


DevelopmentNow Blog