This may be of assistance:

http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/

You could adapt this to your needs:

DECLARE @varCheck BIT

IF EXISTS ( SELECT *

FROM YourResultTable

...

Yes, pass the query result into a variable then use a case statement...

Something like:

case when @varCheck is null then 'No results for today...' else...

If you have the adventureworks cube - this may help:

http://msdn.microsoft.com/en-us/library/ms145528.aspx

WITH

MEMBER Measures.CategoryCaption AS Product.Category.CurrentMember.MEMBER_CAPTION

MEMBER Measures.SpanishCategoryCaption AS Product.Category.CurrentMember.Properties("LCID3082")

MEMBER Measures.FrenchCategoryCaption AS Product.Category.CurrentMember.Properties("LCID1036")

SELECT

{ Measures.CategoryCaption, Measures.SpanishCategoryCaption, Measures.FrenchCategoryCaption } ON 0

,[Product].[Category].MEMBERS ON 1

FROM [Adventure...

This is my take on what you are after:

DECLARE @tableHTML NVARCHAR(MAX) ;

DECLARE @LogShipDate DATETIME2, @productionDate DATETIME2

DECLARE @SuccessFailureText VARCHAR(15)

DECLARE @subjectline VARCHAR(150)

SET @LogShipDate = ( SELECT TOP 1 CurrentDate --Or whatever date...

If you use a function to store the custom palette - this can be reused amongst other reports.

Private colorPalette As String() = { "#9cc5c9", "#729ac7", "#005295", "#78496A", "#923C06", "#D06F1A", "#E89419",...

create a custom palette:

http://blog.infotoad.com/post/2009/06/30/Create-a-Custom-Palette-for-Charts-in-Reporting-Services-2008.aspx

I usually use SQL Search (http://www.red-gate.com/products/sql-development/sql-search/) and then double click the item I need but both the addins mentioned will get a download in the near future!

sharonrao123 (6/1/2011)

Thanks for the reply. I have ran the below Mdx statement as you suggested, but its giving and "type mismatch" error. Can you pleaes let me know how to...

Or UNION the three SETS:

WITH SET [OfficeSegmentECA] AS

Filter([OFFICE NAME].Members, (InStr(1, [OFFICE NAME].CurrentMember.Name, " ECA ") <> 0))

SET [OfficeSegmentECD] as

Filter([OFFICE NAME].Members, (InStr(1, [OFFICE NAME].CurrentMember.Name, " ECD ") <> 0))

SET [OfficeSegmentCCD]...

Try the Switch function on the Series Properties, Markers, Marker Type -> create an expression with something like:

=Switch(Fields!YourCategoryValue.Value="Median", "Cross", Fields!YourCategoryValue.Value="Average", "Circle")

This may be useful too:

http://www.keirgordon.com/post/SQL-Reporting-Services-Switch-Statement.aspx

Basically boils down to use IIF...

Try Notepad++

Open both rdl files

Plugins -> Compare

Or...

If you use BIDS within a reporting solution, right click on the report there is a compare option...

The example doesnt use a case statement:

WITH SET [ChardonnayChablis] AS

'Filter([Product].Members, (InStr(1, [Product].CurrentMember.Name, "chardonnay") <> 0) OR (InStr(1, [Product].CurrentMember.Name, "chablis") <> 0))'

SELECT

[ChardonnayChablis] ON COLUMNS,

...

I had a similar issue with a pie chart and found that doing it the old fashioned way:

Add this to the data label

=COUNT(Fields!YourField.Value) / COUNT(Fields!YourField.Value, "YourDataset")

Add 0% to the format...