Dataset Filter

Hi,
I have report works on SSAS query, the report has filter in dataset and its all good, but when I run the report and I did not type any value , the report did not retrieves any row, so I  need the report retrieves all rows if the filter without value

Thanks
Capture.PNG
samprgAsked:
Who is Participating?
 
TempDBAConnect With a Mentor Commented:
You can ignore the filter from the backend. Check the value i.e. being passed and if it is NULL or blank, just ignore the filter.
0
 
samprgAuthor Commented:
Do you know how in MDX query?
0
 
samprgAuthor Commented:
Thanks
0
All Courses

From novice to tech pro — start learning today.