Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
How do you see the selection in the attached file?
Enable the "Hide excluded values" option in the General tab of the properties window.
Karl
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
Ok. In the sort tab, enable the "By State" option and change it to "Ascending".
Karl
It didn't help as well..:(
That didn't move the possible white values to the beginning and push the excluded gray area below?
Nope!
How do you see the selection in the attached file?
Yours is working just fine but it is not working on my report even I have the same setting!
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