Skip to Content
0
Former Member
Dec 01, 2006 at 04:52 PM

Limit columns based on variable value

29 Views

Gurus,

My requirement;

User will enter a value "A" in the variable and based on the value i need to limit

the columns in the output. for example in the query designer i have 6 fields in

Rows, in Free Chars i have the field with variable which user will enter. if the value

entered is "A" only 4 fields should appear on the report else if value is "B" only

the other 2 fields should appear.

Is there a way accomplish this...please suggest

Thanks with points in advance...