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 > october 2006 > threads for saturday october 7

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

How to List Left-Outer Join Data
Posted by Cindy at 10/7/2006 6:16:10 PM
I have a left-outer join between a table of Sales Opportunities and a table with Activities associated with those Opportunities. On one of my report tables I need to filter out all completed activities and then list those Opportunities that do not have an activity left (eg no open activitie...more >>

Nested Filters
Posted by Cindy Mikeworth at 10/7/2006 5:08:16 PM
Is it possible to create a complex, nested filter on a table in a report? For example: (Statement A AND Statement B) OR (Statement C AND Statement D) ...more >>

Exclude Null Dates
Posted by Cindy Mikeworth at 10/7/2006 4:33:56 PM
I can't seem to figure out how to exclude records with a null in a date field as part of a filter expression. I've tried all of the following: !=<blank> != System.DBNull !=DBNull !="" !='' ...more >>

Reference Book Needed
Posted by Cindy Mikeworth at 10/7/2006 3:00:35 PM
I'm a consultant with 20+ years of experience. With Crystal Report Writer, I just sat down and starting playing with it to figure it out, but now I am confronted with using SQL Reporting Services 2005. It is definitely giving me a shot of humility because I am finding it the most frustrati...more >>

Project opening - XML Document Error (118, 17)
Posted by Rohit Jain at 10/7/2006 5:45:01 AM
While openeing the solution file (.sln), I got the following error: "There is an error in XML document (118, 17)." I am trying to open a project of SQL Server 2000 - Reporting Services. Don't know what had happened actually....more >>

Analysis Services 2005 Deployment Wizard
Posted by somuthomas NO[at]SPAM gmail.com at 10/7/2006 3:29:54 AM
Hi, I used the deployment wizard in the analysis services 2005 to convert it into XML script. Using the SQL Management Studio I opened it as Analysis Server scripts and used the local host as the system in the connections windows then loaded the XML script into the Queries window as a XMLA q...more >>



DevelopmentNow Blog