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 > april 2005 > threads for thursday april 28

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

Graph Drop lines
Posted by Bryan Avery at 4/28/2005 11:40:16 PM
Within Excel you can create Drop Lines in line graphs, is it possible in the Graph Control in Reporting Services? ...more >>

Same here
Posted by Mark at 4/28/2005 10:40:27 PM
Same problem here too. I get the first page & then the error on the second page. I also only get the first page when printing & the error at the end. I have checked my IE explorer settings & verified scripting is turned on. Anything else to check? ...more >>

How does one use the sample Printer Delivery extension?
Posted by dj at 4/28/2005 9:15:38 PM
I've got the printer delivery sample compiled and configuration files edited per the sample ReadMe file, but I'm not clear on how to use the printer delivery extension to have the report(s) print. Do you use a report subscription, or what? Thanks very much. ...more >>

Subcription
Posted by Ashkan Daie at 4/28/2005 7:26:29 PM
I have deployed the sample reports to reporting server. When trying to subscribe to any of the sample reports I get the following error: --------------------------- Microsoft Internet Explorer --------------------------- Subscriptions cannot be created because the credentials used to run the...more >>

External Image not displaying
Posted by pmud at 4/28/2005 3:04:09 PM
Hi, I installed SP1 and have specified an image as External & am using "https"//abc.com/Images"+Fields!LOGO.Value as the exprseeion for getting the image but the iamge is not displaying. The image in the database field LOGO is stored simply as xyz.gif . How acn i display such an image? Am ...more >>

Index out of range error exporting to Excel (Already read through previous posts)
Posted by Jason Ratke at 4/28/2005 2:12:06 PM
Hi, I get the "Index out of range" error that a lot of people seem to be getting when exporting to Excel. All other formats work fine. I have already read a bunch of the previous posts, including Bryan Bullard's posts where he seems to have resolved the problem. In my case, I have tried ...more >>

Home page blank.
Posted by Trevor Morris at 4/28/2005 2:02:02 PM
When i try to administer my Reporting Services, the following page comes up with the picture of a folder and "Home" http://dev7/Reports/Pages/Folder.aspx How do I administer the Reporting Services enough to at least give myself permissions to administer it?...more >>

print active x question
Posted by Shaun Longhurst at 4/28/2005 1:22:11 PM
WE have locked down our security so that no active x controls can run for our end users. Is there a way to integrate the installing of the print active x control into the startup script? Or does it have to be installed using direct from the report manager? We have looked at the cab file but...more >>



Collapse All Groups
Posted by Derek Fisher at 4/28/2005 12:43:22 PM
Does anyone know how to create a button or link that would collapse all open groups? I'd like a link/button that would collapse all lower level items. For example if your report looks like this: Level 1 Level 2 Level 3 And the user has it drilleddown all the way...more >>

SMTP bug fixed with SP2
Posted by Bruce L-C [MVP] at 4/28/2005 11:08:13 AM
I use the email feature where you reference a remote SMTP server. It worked previously only for emailing links. It would not email the report. I was hoping this issue would be resolved with SP2 and it did. It works perfectly now. -- Bruce Loehle-Conger MVP SQL Server Reporting Services ...more >>

Excel Margins
Posted by Trace at 4/28/2005 10:06:02 AM
Hello Now with SP2 the page margins works fine. Exists a method to set the Footer and Header margin in the Excel Rendering Extension? Thanks......more >>

Deploying report to multiple locations
Posted by clutch at 4/28/2005 9:13:12 AM
We would like to be able to publish a report to more than 1 directory at the same time. Is this or would this be possible? Currently, we deploy the base report to a central location and create linked reports to all other locations....more >>

error occured trying to render the report
Posted by isamu at 4/28/2005 8:54:06 AM
I am getting the following error message when previewing or trying to just print using the client side activeX printing control after installing sp2 release: An error occured trying to render the report. (0x800040005) ??? don't have the slightest clue what this could be. I have deleted ...more >>

Error using CreateSubscription from "My Reports"
Posted by SouthFLBoiler NO[at]SPAM discussions.microsoft.com at 4/28/2005 8:44:07 AM
I can create subscription from all reports in the normal folder list. The problem is when I create a linked report in "My Reports", Then try to create a subscription, I get an error. A subscription delivery error has occurred. --> A subscription delivery error has occurred. --> The v...more >>

SP2 Client Printing On Xerox
Posted by General_Patton at 4/28/2005 8:33:10 AM
When I print to a Xerox Document Center (Large Copier, Fax Printer Combo) using the new client print button in SP2 it prints all the fonts inversed and larger than they should be (report runs off page). If I print to an HP printer, no problems. We have a large installed base of Xerox machines lik...more >>

format of point labels
Posted by dataGirl at 4/28/2005 6:54:11 AM
Can I display number values with their corresponding percentage values in pie charts like I can in Excel? (Ex. 45, 7.7%) If so, how? I've gotten either one or the other to appear, but not both at the same time....more >>

SP2 - Error exporting to excel
Posted by rweiss at 4/28/2005 5:42:07 AM
With SP2 installed, I get the following error when trying to export to excel (translation from german): Export Error Unexpected error while processing report. Object reference not set to an instance of an object. The report contains subreports. Removing the subreports, it works fine. If th...more >>

SP2 - Error excel export
Posted by rweiss at 4/28/2005 5:22:09 AM
With SP2 installed, I get the following error when trying to export to excel (translation from german): Export Error Unexpected error while processing report. Object reference not set to an instance of an object. The report contains subreports. Removing the subreports, it works fine. If th...more >>

Custom Error Pages
Posted by HelpSal at 4/28/2005 4:50:03 AM
Hi, I have created an asp.net application in which I use the report viewer control to display my report. My problem is that if the report server displays an error message then I want to trap that error and display my own custom error page my company logo with the error message, Is it pos...more >>

SP2 Print Document Bloat
Posted by Ben S at 4/28/2005 3:02:07 AM
When exporting to pdf and then printing, the a 2 page document sent to the print spool is approx 2.88MB, when printing via the new client print buton, the same document sent to the printer is dramatically larger - I cancelled the print job when it reach 23MB and still climbing steadilly. Ha...more >>

Can anyone really disable caching?
Posted by Matt Swift at 4/28/2005 1:48:05 AM
For report properties, I am in 'Execution' and the settings is at 'Do not cache'. I'd expect this to totally stop caching! What I'm looking for is the report to pull back fresh data every time it's requested, NOT when a parameter has to be changed first. I saw a solution where developers...more >>

Page Header & Page Footer Strange Behaviour.
Posted by Henky C. K. at 4/28/2005 1:38:05 AM
There is an options for page header and page footer in report properties, ie: "Print on first page" and "Print on last page". If I have 10 pages and I want to show page header ONLY on the first page and page footer ONLY on the last page, then I must uncheck those page header and page footer...more >>

Expand/Collapse button on Drilldown - Inversed +/- !!! Help!
Posted by Matt Swift at 4/28/2005 1:22:06 AM
One of my reports features a table that works with groups. Unfortunately the +/- for the expandability features seems to be completed inversed, and I cannot find a feature to correct it. It's really bizarre as I have virtually identical reports in other areas that work on the same basis and ...more >>

Reporting Services on SQL Server Personal Edition ?
Posted by Mary at 4/28/2005 12:24:54 AM
Is it possible for us to use RS with SQL Server 2000 Personal Edition ? Thanks...more >>

Error when trying to deploy
Posted by Jessica C at 4/28/2005 12:13:20 AM
Hi All Has any one ever seen this error? Error : The type initializer for = "Microsoft.ReportingServices.Diagnostics.CatalogItemUrlBuilder" threw an = exception. I have deployed reports numerous times and never seen it. Thanks, Jessica...more >>

Client-side printing hangs IE
Posted by Chris Childs at 4/28/2005 12:00:00 AM
Hi, When I try to print a report using client-side printing in SP2, I get the Print dialog fine, then when I click 'OK' I get the 'Printing now...' popup, but IE hangs instantly. I've tried removing the ActiveX component and reregistering it but to no avail. However, it works fine on othe...more >>

Reporting Services and an old sharepoint install
Posted by Julien Dumetier at 4/28/2005 12:00:00 AM
Hello, I'm trying to install Reporting Service on a windows 2003 SP1 server where a sharepoint had been uninstalled. The install program still detect my old sharepoint installation. i have checked the 2 documents from the support to remove manually sharepoint, but the problem still occur...more >>

Data Source access
Posted by Cathie at 4/28/2005 12:00:00 AM
Hi All, I'm looking to create an ad-hoc query generator so that I can create a report on the fly, but I would like to use RS Shared Data Sources for this. I have run into a problem though, in that I can't retrieve the password for the Shared Data Source. Is there any way to get the Data So...more >>

Invalid column name 'ChunkFlags'
Posted by Scott Stonehouse at 4/28/2005 12:00:00 AM
I get the following error whenever I try to run a report. --- An unexpected error occurred in Report Processing. (rsInternalError) Invalid column name 'ChunkFlags' --- A search turned up nothing. This is after installing SP2. Any ideas? I don't have any columns named 'ChunkFlags' in my ...more >>

Common Expressions Format syntax errror!!
Posted by James Woo via SQLMonster.com at 4/28/2005 12:00:00 AM
Hi All I have three data sets in a report. I am trying to format an average based on of the data sets (pManagerAvg), here is what i have : = " Average hrs/manager --> Total Finished: " & Avg(Fields! Measures_Finished_Count.Value), "pManagerAvg") This works fine, however I get 156.895623...more >>


DevelopmentNow Blog