For others who may encounter this perplexing situation (which is unique because the drop down is NOT based on a query and neither does the main report query contain a...

actually, it's really weird it's using PPCQuery, because I supplied the values for the drop down by typing them in. The parameter values are not supplied by a query!

The...

i have only one drop down box.

thanks lynn, for being forthcoming (finally!)

Thanks Scott, for the answer!!!!!!

too late, I figured it out. Each number has to be divided seperately.

select cast(18 as float)/cast(19 as float);

select convert(decimal(5,2),18)/convert(decimal(5,2), 19);

Spare me the long winding road to nowhere

select 18/19 still gives me zero.

Someone, please show me how to divide integers so that 94/18 gives me .19

I know I've done this before and can't understand where this...

lynn....this time...

replace('2014-07-30', '-', '')

hee haw. Thanks a lot

just keep it tame!

you're on to something. I missed that. Thanks. I shall maybe need to convert!

No, because the sproc is expecting the 20140625 format. The sproc works by the way.

I don't see where in my post i use a date format such as you...

Thanks a lot Koen

When I use the File Enumerator Property: FileNameRetrieval instead of FileSpec for the expression "*"+@[User::datePart]+".txt.zip".....

it finally maps this expression to the zippedFile variable and loops!!!!!! yay.

but.

now...after iterating through all the...

Koen,...

could someone take the ddl i provided and details of set up and try to reproduce and find the location of problem? I'm stumped.

ok, I don't see the value of the breakpoints. I set it as advised, and the breakpoints window is only telling me that it ran: name, hit count, file, address,...