Groups | Blog | Home


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 > march 2006 > threads for thursday march 2

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

Bold on Matrix subtotal
Posted by anthonysjo at 3/2/2006 8:45:15 PM
Hello all, Does anyone know how to make a subtotal column on a matrix report bold? I can bold all data but can't seem to figure out how to only do the subtotal column. Thanks!!...more >>

blank page in pdf report
Posted by joshua at 3/2/2006 2:41:11 PM
When I export my report to PDF, I get a blank page that shows up. The header and footer are on the second page, but the body is blank. There isn't enough data for a second page. Why is one being created? Any ideas? ...more >>

Error in deployment of Reports
Posted by Vince Keller at 3/2/2006 12:54:29 PM
Hello, I have built a report on SSRS 2005 and wanted to deploy that report as a URL. However, it gives me an error which reads - "The permissions granted to user '<Machine Name>\IUSR_<Machine Name>' are insufficient for performing this operation. (rsAccessDenied)". Any idea whats causing th...more >>

Ctype from string to double not behaving as expected.
Posted by Nathan at 3/2/2006 12:21:27 PM
I tried posting this earlier, but it never showed up. Hopefully I don't double post. I was writing code for a custom dll earlier this morning where I ran into some strange behavior for the IsNumeric function. IsNumeric("$1,0562.00") was returning false I thought that maybe this behavior ...more >>

Group Sorting in a Table
Posted by abillmeier at 3/2/2006 9:51:04 AM
Good morning, I am having a little bit of an issue with the sorting of data in a report. The report works great, but the sorting could be better. I have the data in a Table. I have a list of data that is grouped into three groups. The groupings are by Project, Phase, and CostCode, in t...more >>

Sql Code being modified automatically
Posted by jhoge123 NO[at]SPAM yahoo.com at 3/2/2006 9:42:45 AM
I'm writing a simple query against an OLEDB database that needs a conversion function. What I want to do is like this: SELECT CONVERT(ardtl.SIZE, integer) AS ItemSize, SUM(SHIPPED_QTY) AS shipped_qty ..... Once I type this SQL in the Data tab of the my Reporting Services project, Visua...more >>

Conditional Parameters
Posted by KimB at 3/2/2006 9:30:31 AM
Does anyone know if there is a way to have conditional parameters? Ex: User asked would you like to run report by representative or area? Then when the user chose representative a mulit select prompt would appear with a list of representatives to choose from or if they chose area then a multi...more >>

Report Engine
Posted by davidswain2005 NO[at]SPAM yahoo.co.uk at 3/2/2006 8:53:17 AM
Does Report Services 2005 have a Report Distribution engine. So that I can for instance say; I want user 'A' to get report 'B' in a format of 'C' at 17:05 every day. Many thanks David ...more >>



Report Layout
Posted by Chris Kye at 3/2/2006 8:51:33 AM
I have a page with a List of about 12 fields with text labels. Something like this: Label1 Field1 Label2 Field2 Label3 Field3 Label4 Field4 IS there any way to scale this so that if, for example, Label3/Field3 are empty, I can move Label4/Field up? Right now, it leaves a big bla...more >>

Programmatically chosing an image in table
Posted by Clint at 3/2/2006 8:28:32 AM
So we've got a report, and some external images (i.e. sitting on the server's HD). I don't really want to put them in the SQL 2000 database if I don't have to (mainly because I don't know how), but I want one column of the report to be one of 5 images, depending on the value a column in the ...more >>

Fields tab not populating in Data set setup
Posted by Bill at 3/2/2006 8:21:31 AM
I using a SP for my dataset problem is the Fileds tab is not populating with the fileds from the SP thus I do not have anything to drag in the Layout Tab to build the report. I know I missing something here, just can not rememebr what to do to get it to populate the fileds can anyone tell m...more >>

Excel Export Report Footer Problem
Posted by Frank Hoover at 3/2/2006 7:44:31 AM
We have a footer in our reports which displays a disclaimer in a textbox. The disclaimer shows up fine when exported to PDF, but when exported to Excel it chops off everything but the first 255 chars. Can someone explain why this is happening?...more >>

Q: access rights in report manager
Posted by JIM.H. at 3/2/2006 7:27:22 AM
Hello, Our users are launching reports through report manager, is there any way I can arrange access rights so that they can only run report but not do anything else in the report manager. ...more >>

Deleting reports
Posted by Mathias at 3/2/2006 6:14:21 AM
So I've got a couple of reports deployed in reporting services 2005 and Well I want to delete them but I have no clue how. I was wondering if anybody could either A) walk me through how to do it. B) point me in the direction of some sites that explain how to do it (I'm having no luck with go...more >>

Error when Exporting to Excel
Posted by Dave Peake at 3/2/2006 2:00:27 AM
For the last couple of weeks we've been experiencing problems when try to export reports to Excel either from the VS IDE or the Report Manager Web. After some tinkering and investigation (maybe more luck than judgement) we found it to be an issue relating to Page Breaks on tables. If we unche...more >>


DevelopmentNow Blog