Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Need urgent help on data field visibility in report Expand / Collapse
Author
Message
Posted Monday, October 7, 2013 8:37 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 11, 2013 10:19 PM
Points: 25, Visits: 23
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?
Post #1502452
Posted Tuesday, October 8, 2013 1:38 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:55 AM
Points: 13,570, Visits: 11,383
Depends. Is it a matrix or a table report?



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1502487
Posted Tuesday, October 8, 2013 1:51 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 11, 2013 10:19 PM
Points: 25, Visits: 23
It is a tabular report
Post #1502489
Posted Tuesday, October 8, 2013 1:56 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:55 AM
Points: 13,570, Visits: 11,383
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1502490
Posted Tuesday, October 8, 2013 1:58 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 11, 2013 10:19 PM
Points: 25, Visits: 23
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
Post #1502492
Posted Tuesday, October 8, 2013 2:04 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:55 AM
Points: 13,570, Visits: 11,383
Yes, you can do this with the visibility property you mentioned earlier.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1502497
Posted Tuesday, October 8, 2013 2:06 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 11, 2013 10:19 PM
Points: 25, Visits: 23
yes, it but is there any other way to achieve this except visibility property?
Post #1502498
Posted Tuesday, October 8, 2013 2:17 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:55 AM
Points: 13,570, Visits: 11,383
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?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1502501
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse