Monday, March 12, 2012

Problems with Hidden visibility feature

I'm pretty new to Reporting Services so Im sure this is just something that I am messing up out of nievite! I need help hiding columns in a tab report when the column date is greater than the as of date parameter( they have a choice of chosing today, and as far back as the lasy day of last month) ...this is the formula that I am using:

IIf(FormatDateTime(DateAdd("D", 0, FormatDateTime(Cstr(Month(Parameters!b_001_AsOfData.Label)) + "/01/" + Cstr(Year(Parameters!b_001_AsOfData.label)),1)), 1)<(Parameters!b_001_AsOfData.Value),true,false)

I have tried using it per column in the visibility as well as in the tables visibility function....what the heck am I doing wrong? Any insight would be GREATLY appriciated!

thnks!

Sheidee

The type of Parameters!b_001_AsOfData.Label is a string, not DateTime. Have you tried using Parameters!b_001_AsOfData.Value instead?|||AAAhhh ~ Thanks! :)

No comments:

Post a Comment