One simple way I used is to save the jpeg on the server's drive and then save the path in the database. If you are going to save the...

Well I never used the reporting services and I haven't found anything usefull on yahoo so I'm officially out of ideas. Good luck with that.

Sorry Martin I didn't see that the & NBSP ; had been removed from my post (or actually shown as a space like in your report)... but I'm glad I...

you can try this format :

iif(isnull([Status]);"For All Jobs";iif([Status] = 1; "For All Closed Jobs";"For All Open Jobs"))

>> but does it when rendered in the browser via report manager.

Do you mean you are viewing this in internet explorer or netscape (as int html report).. if it's the...

SP3 is not out, so SP2.. but maybe he means SP3 for sqlserver but I'm pretty sure it's for win xp sp2

In answer to WSquared's comment, I'm using appname() on sqlserver in a trigger so any access options are off.

IN answer to Jonathan Stokes :

This is an ADP connected directly...

Thanx for the reminder... havn't coded anything in html for 8 months now :-(..

In answer of Al Matthews, if you try this you'll see the problem

Declare @Words varchar(255)

select @Words = 'This is a            test of the REPLACE FUNCTION'

select replace(@words,'  ', ' ')

gives : This is a      test of the REPLACE FUNCTION

instead of 'This...

can someone tell me why the double white spaces are removed from the posts??

It wouldn't work >>

declare @Words varchar(255)

select @Words = 'This is a test of the REPLACE FUNCTION'

select replace(@words,' ',...

How much faster is it than the other version?

Cleaner but slower doesn't do much for any of us.

Could you do some test and report back to the board??

if nothing has changed on the sqlserver side I'd check with the network guys... especially since it's something that has changed recently. But I can't help you any further...

what's the return type of DTSSource("Authorization#")??

if this is a string or a date you need to wrap it in quotation marks like this:

strSQL = "select AuthorizationNumber from REPRICE_AuthNumbers where...

Or on the same page as japie, you could make a search for the records... Something like : name like 'ab%' and state in (CA, FL) and.... (a little search...

case closed.. found out it's impossible to do something like that.. and for obvious reasons... I don't see how you could inner join on a ever changing recordset.