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 sunday march 26

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

need to select the first two letters of a string in a text box
Posted by Susan R at 3/26/2006 3:32:02 PM
HI, I have a form that has a text box where there is a street address populated when the form is run. LEts call it textbox 1. I need to add logic that if the first two letters in the string in textbox 1 are PO or P.O. then populate the informaton in box 2. Any help would be appreciated....more >>

sub reports
Posted by blabore at 3/26/2006 3:07:50 PM
I'm trying to create a sub report for the first time, and have a couple of questions. 1) Does the sub-report have to exist in the same folder as the parent report? 2) Can I dynamically change the targeting sub-report at runtime? How would I go about doing this? Any help would be apprec...more >>

Chart Series Total
Posted by blabore at 3/26/2006 3:06:06 PM
I have a chart on one of my reports that has two series as a stracked bar chart, and displays two point labels on each bar for the series value. What I'd like to do is show the series value as a percentage relative to the total bar value. The real problem here is I don't know how to get progra...more >>

Extra Page breaks on saving report in pdf format in Rep Svcs 2000
Posted by IJ Singh at 3/26/2006 2:59:18 PM
I have created a couple of reports in Reporting Services 2000 ( with SP2 installed). The report shows up just fine in the preview tab, but all reports have one or 2 additional page breaks at the end when I export the reports into pdf. I have checked all tables in the reports and none has th...more >>

Export to Excel changes page orientation
Posted by Milu at 3/26/2006 2:52:38 PM
I have report page height defined as 11 in. and width as 8.5 in. When I export the report to pdf, it comes fine in portrait format. But when the report is exported to Excel, the orientation is changed to Landscape. Even the page margins are not preserved. Is it that Excel overrides the rep...more >>

Shading and Shadows
Posted by OHSA 300 Report at 3/26/2006 2:48:09 PM
I am doing an OSHA 300 report. This report requires boxes with shadows and shading of columns. I have not been able to accomplish these in SQL 2005 reporting services. I have done a total of 30 reports in SQL 2005 so I know I am missing something. How do you accomplish this in SQL 2005? ...more >>

64-bit Reporting Services 2005 single-threading?
Posted by SteveIrwin at 3/26/2006 2:43:43 PM
We're running on an AMD 8-core Opteron, with Enterprise RS 2005 64-bit. It seems that when we have multiple users running reports at the same time, the mdx queries get executed in parallel to the AS database, but the processing of the data by reporting services is done in a single-thread mode. ...more >>

RS 2000 Printer Icon Disappeared!!! PLEASE HELP!
Posted by DotNetNow at 3/26/2006 2:43:25 PM
Users have been able to print a RS 2000 report via the printer icon on the RS viewer toolbar for over a month. Yesterday, for no apparent reason the printer Icon has disapperared from EVERYONE's toolbar. When the report was first launched under various users, they were prompled to install cl...more >>



Use SQL 2005 reporting Services with 2000
Posted by Gouri at 3/26/2006 12:00:00 AM
Hi, I am a new user for SQL 2005. Is it possible to use the new features of reporting services from SQL 2005 in SQL 2000? GS ...more >>


DevelopmentNow Blog