Roman,

Give this a try, it seemed to work for me.

SELECT

Pers.Name

FROM

Pers

ORDER

BY

(

SELECT

Thanks David. 

Mike

Kerrie,

Thanks for sharing!  I'd yet to come up with a solution for this.

Mike

Jeff,

If a given Name exists in Column1 and Column2 try dropping the ALL from the UNION.  Without the ALL sql will remove the duplicates for you.

Mike

Andrew,

First create a user defined function that looks something like this.

CREATE FUNCTION [dbo].[fnTextRollUp] 

     (@Code int)

RETURNS varchar(2048)

AS

BEGIN

--

DECLARE     @Keywords   VARCHAR(2048)

SELECT      @Keywords=  ''  

--

SELECT      @Keywords = @Keywords + Keyword +...

To drop the decimal point and what follows.

select

left(convert(varchar,cast(12345 as

I too have ran into the same situation.  The only workaround I've cam up with so far is to move my 'join' into the 'where' clause.  For example.

SELECT * FROM...

This would be the expected result when your data type is BIT.   You can try modifying the query / sproc to force the value as an INTEGER.

CONVERT(INT, data_value)

Good luck

Mike

Tracey,

Suspect that your double clicking on the rdl's file name.  Instead, try opening the file using the open dialog box of the development tool your using.

Mike

Raj,

Change your WHERE clause to "WHERE .... AND TST.Billable IN ( @Billable ).  This only works if the query is embedded in the .rdl.  If your using a stored procedure...

Using 2005, I received the following message.

SELECT SCHEMA_NAME(schema_id), name FROM sys.objects

WHERE name...

Thanks guys.  Appreciate your help with this.

Mike

Chris,

Try this expression in the aggrevating cell.

=IIF(Sum(Fields!FieldName.Value)=0,0,Sum(Fields!FieldName.Value))

Mike

Santosh,

Can do.  After you've created the basic maxtrix with an aggregate cell for 'Value1' right click in that cell and select either 'Add Row' or 'Add Column'. depending on whether...

MG,

Unless your using RS 2005 your only option, that I know of, is have the user enter a delimited string of characters - C,D,H - then parse that string into...