Alright so I finally figured it out...I had the List box grouped by DOY, hence the last line which happend to be the roll over hor for production was going...

I changed the interactive size to match the page size, but it was already set to 8.5 x 11. Changing it to match the page size of 14 x 8.5...

Yeah I tried that...no matter what the bottom and top margins are it doesn't change the result. That is unless I make the bottom margin something crazy like 5 inches...

The page setup is actually set up to landscape Legal, so it shouldn't have a problem fitting. I can't find any setting that would limit it to 20 lines per...

Where do you look to check the interactive property settings? I don't see this option anywhere in the options on the report tab.

Thanks works great now....I was passing it the string "True" rather than the boolean value as you suspected.

Thanks that worked perfect. Only issue is the nice message that pops up on the report server saying:

"The Hidden expression used in table ‘table1’ returned a data type that is...

Worked perfect...got to love it when your just missing a paren

In plain english what does "today()-1, 1, 0" mean in the example code you posted?