October 7, 2013 at 8:37 pm
We have a report where in there is a report parameter for selecting fields in report. Based on users selection, in report only those selected fields should be shown.
One way to achieve this is to add all the fields in report and set the visibilty of fields based upon user selection.
Is there any other way to achieve the same?
October 8, 2013 at 1:38 am
Depends. Is it a matrix or a table report?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 8, 2013 at 1:51 am
It is a tabular report
October 8, 2013 at 1:56 am
kirti.malukani 95398 (10/8/2013)
It is a tabular report
I don't know how your report looks like, but right now hiding the fields you don't need seems to be the best option.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 8, 2013 at 1:58 am
We have to hide the fields based upon user selection. For ex,
If @user_selection = 'a'
then
display field a,b,c
hide field d,e
else if @user_selection = 'b'
then
display field c,d,e
hide a,b
October 8, 2013 at 2:04 am
Yes, you can do this with the visibility property you mentioned earlier.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 8, 2013 at 2:06 am
yes, it but is there any other way to achieve this except visibility property?
October 8, 2013 at 2:17 am
kirti.malukani 95398 (10/8/2013)
yes, it but is there any other way to achieve this except visibility property?
Not that I know off.
Why? Is the visibility property not good enough?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply