Hey
Im trying to write a report in BIDS, where columns will show depending on what the user enters when prompt for a paramter.
The paramter has summary or detail as an option.
Then I would like it so if user select Summary only column 1 and 2 will show if the users selects details all the 5 columns will show.
Can someone explain how to do this please?
Thanks
R