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 friday december 10

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

RS Memory Leak?
Posted by Fabian Cevallos at 12/10/2004 6:18:28 PM
I am testing the SQL Web Reporting Services and noticed that the memory usage of sqlservr.exe and w3wp.exe remain at a high level even though all the client applications were closed. Is this a known issue? Is there a fix? Thanks. Fabian ...more >>


Logon prompts twice
Posted by Fabian Cevallos at 12/10/2004 6:09:57 PM
Any idea why the logon prompts again when clicking on a report after succesfully logging into the reporting services the first time? The report opens with no problem. I am using Windows Server 2003, SQL Server 2000 Standard Edition, and IIS 6. Thanks. Fabian ...more >>

Output Parameters from Stored Procedures
Posted by Jeff at 12/10/2004 4:37:03 PM
Is it possible to retrieve the value of an output parameter from a Stored Procedure that is set set up as a DataSet?...more >>

How to move one report?
Posted by Annette at 12/10/2004 2:59:19 PM
I've browsed thru the topics and found the suggestions on doing backup/restore to "bulk move" reports to a new Report Server, but once you've got a working Dev/Production environment, how do you go about moving one report at a time? We are using a consolidated Dev environment with two producti...more >>

Keeping a group together over page break
Posted by Kaisa M. Lindahl at 12/10/2004 2:13:30 PM
I'm creating a report now, that will span over several pages. I want to keep a group togheter. The report shows clients and projects, and I don't want to have any "hanging" projects starting on a new page. Is it possible to have the report do page break if it calculates that the grouping is too ...more >>

Date parameter getting converted
Posted by BrianW at 12/10/2004 1:05:04 PM
I have my report's data source set to a stored procedure that I created which takes 2 date parameters. If I run the dataset while in the Data Tab it works fine but when I go to the preview window no data shows up. I ran a SQL Profiler trace to figure out what was going on. Apparently in the...more >>

Printing embedded images
Posted by ccatwork at 12/10/2004 1:03:04 PM
Has anyone had trouble being able to print images & graphs that you sent via reporting services embedded in an email? We have RS SP1 and some of the images will not print even though they show up just fine when they are opened. This only seems to occur with Outlook 2003 & XP or W2003 - they ...more >>

Inserting images stored in a field to a report.
Posted by Rudi Groenewald at 12/10/2004 10:51:28 AM
Hi all, In my report, which is based on a table with 2 fields ex: imgID and Picture1 ..... Picture 1 is data format "image" and I simply insert the photo from my forms application into the field. The problem is extracting this information. When adding this field to my report, I would s...more >>



SMTP & DNS MX records
Posted by JMcquillan at 12/10/2004 10:51:02 AM
Does RS lookup MX records in an environment where DNS A records can not be found? WHat is the proper RS confiquration to resolve mail sent though Smarthosts nad MX records? Help? ...more >>

Line Number ?
Posted by jean-marc.audrin NO[at]SPAM future.ca at 12/10/2004 10:45:44 AM
Hi guys, SQL RS supplies the global variable "PageNumber" but is there a kind of "LineNumber" variable or function available ? Or another way to get the number of current line being printed ? Thanks. Jean-Marc ...more >>

XP SP2 and .NET Framework 1.1 SP1 causes error
Posted by sathya at 12/10/2004 10:39:01 AM
Hi It seems like everytime I update my machine with a service pack and reboot, my reporting server gives this error: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delet...more >>

Disabling Links in Excel, PDF
Posted by Ashish at 12/10/2004 10:35:03 AM
I am displaying some links using Jump To URL in my Report. I want to Disable those links when I export the report to Excel or PDF Does anyone have any clue as how wwe can disable those links when report gets exported to Excel, PDF. -- Thanks! Ashish...more >>

Parameters...Null as an available value?!!?!?
Posted by Brian at 12/10/2004 10:14:54 AM
I have a hierarchy of organizations that I need to be able to filter by in the reports... For example, an Agency can have many Applications associated with it. I have three stored procedures, one that gets a list of Agencies, the other that gets a list of Applications based on the Agency tha...more >>

Calling External Assemblies which require there own condig setting
Posted by Martin at 12/10/2004 8:37:05 AM
Hi, I've successully called a method of an external assembly (which is part of a large web-based application) from within the report designer. However, when I call a different method from the same external assembly I get an error "Failed to load expression host assembly. Details : The Conn...more >>

Impossible to sort in exported Excel
Posted by Nikola Tepper at 12/10/2004 12:29:02 AM
Hi, When we export tabular reports into excel, it is then impossible to sort the table by columns. Following excel error appears: "This operation requires the merged cells to be identicaly sized" I guess, it is because some of the table cells are merged, but why this is, I dont know. If a man...more >>


DevelopmentNow Blog