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 >>
|