Exclud data from a text box

[#1]

Hi Guys,

I am running the following report which is pulling data per month and then date.

how can I make the report shows only the dates related to that month in the Day text Box?

Thxs

[pover]

Enable the "Hide excluded values" option in the General tab of the properties window.

Karl

[#3]

I tried that one but It won't help..

It will exclud them but will keep huge gray space before or after the data depending on the Month.

Like If I click on JUL from the month box, then I see gray space on the day box andf i have to scroll down to view the data

[pover]

Ok.  In the sort tab, enable the "By State" option and change it to "Ascending".

Karl

[#5]

It didn't help as well..:(

[pover]

That didn't move the possible white values to the beginning and push the excluded gray area below?

[#7]

Nope!

[pover · Accepted solution]

How do you see the selection in the attached file?

[#9]

Yours is working just fine but it is not working on my report even I have the same setting!

[CELAMBARASAN]

Hi,

     Try with the below expression

     =ValueList($(=chr(39)&Concat(DISTINCT DayFieldName,chr(39)&',' &chr(39))&chr(39)))

It will work as your need

Celambarasan