One small problem I've disvovered with this is that if you refresh the report then the sp is executed again with the sasme parameters and the data is updated again.

Just thought...

You need to enter just the stored procedure name without the parameters, they're not needed as Visual Studio works out the parameters for you.

and for even more fun pass the pattern for the like operator as a parameter to the function:

CREATE FUNCTION dbo.JeffsFunction(@sText AS VARCHAR(8000),@pattern varchar(8000))

RETURNS VARCHAR(8000)

     AS

  BEGIN

        DECLARE @Result...

To check bit flags you have to AND the column with the value of the bit you are trying to test

eg:
SELECT name,dbid,status FROM master..sysdatabases
where (status & 1024)=1024

Try numeric(38,0). It worked ok for the number you quoted

This usually happens to me when either the report header/footer/body sections are too wide for the width of the report. The extra (usually blank) space at the right of each...

As a start point try Googling for:

red brick odbc

Note: This won't work if any of the values does NOT contain a '/'.

In this case charindex(value,'/')-1 evaluates to -1 causing LEFT to blow up with an invalid length error.

You'll need...

Try:

=IIF(Fields!Sales.Value<>0, Fields!Margin.Value/Fields!Sales.Value ,"")

Problem with ISNUMBERIC is that it will return 1 not only for integers but also for valid decimal and money values too, eg. '1.00', '1,000.00' , '£1.00' and '$1.00'

I thought you only had to divide by 2 when using datalength.

Or perhaps:

SELECT LEN ('    '+'.')-1

Only a slight modification of my previous code required then:

=(Fields!hours.Value-Fields!hours.Value Mod 24)/24 & " days " & (Fields!hours.Value Mod 24) & " hours "

should do it.

There is a sample application that comes with reporting services that looks like it covers what you want to do. If you've installed the samples you'll find it in:

C:\Program Files\Microsoft...

Try this instead:

=(Fields!hours.Value-Fields!hours.Value Mod 24)/24 & "." & (Fields!hours.Value Mod 24)