What SSRS are you using, if there is any SP? Are you allowed to send me the rdl? There has to be something that is hidden, going beyond the margins,...

I got it now...ID10T error! LOL

Thanks for all of your help, I really appreciate it!!!

I'll see you online...have a good day,

Kerrie

I have never tried that before....but I will now. Thanks for all of your help, I really do appreciate it!

So you are telling me it should NOT be set up like this...

SELECT A.*

FROM

(SELECT *, 'Environ' as PRODUCT_TYPE

FROM [PSEnvironPublished$] 

UNION

SELECT *, 'Control' as PRODUCT_TYPE

FROM [PSPublishedFixes$]) A

I tried taking...

I wish it was that simple...I did, twice. This is kicking my butt and there is no information on this at all. Has no one tried this, I find that...

I finally got it to work....

Make sure that all of the mapped drives have the same drive letter along with the same path. Make sure permissions are correct for all...

Yes, we have tried that. I have tried to map a drive to the client machine, connected it to the client, and it worked for the client but not the...

Custom Datasource (I have tried a few different ways to do this)

Connection type...

ODBC

Connection String....

PageTimeout=5;FIL=excel 80;MaxBufferSize=2048;DSN=FixDS;DefaultDir=P:;DBQ=P:\FixStatus1.xls;DriverId=790

Connect Using...

Windows NT Integrated Security

Is that what you are looking for? I hope that tells you...

In the expression you could do something like CDEC(Fields!expression.value). It turns that field into a Decimal.

Thanks, Kerrie

Just wanted to say thanks for all of your help!!!!

I have learn a lot because of this site!!!

Thanks for everything and Good Luck with everything you do,

Kerrie

Sorry it took so long for me to get back to you...

I had to regisiter the directory in IIS Manager. I did not do this personally, I had one of...

Got it figured out! Thanks anyway though!

THANK YOU!!!!! IT WORKS!!!!!

"=IIF(InStr(Fields!DivisionName.Value,"Division")=0,Fields!DivisionName.Value,Left(Fields!DivisionName.Value,InStr(Fields!DivisionName.Value,"Division")-1))"

I would take it a part....

Try something like..

=IIF(InStr(Fields!DivisionName.Value,"Division")=0,Fields!DivisionName.Value,NOTHING)

Or something like that.

Again, I am guessing, but i usually figure it out when...

"=IIF(InStr(Fields!DivisionName.Value,"Division")=0,Fields!DivisionName.Value,Left(Fields!DivisionName.Value,InStr(Fields!DivisionName.Value,"Division")-1))"

I think it should be...

Left(Fields!DivisionName.Value, 'some positive number')

I do not think it can be a negative number. Maybe I'm wrong. Just a guess.

Thanks and...