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