Hiding columns

hi
I have 2 doubts . Need to finish some reports by tomorrow :
1.How to hide certain columns in a report based on say a value being returned from a SP.
2. I want all the recoreds in the report to be shown in a single page and without any page breaks...
Any suggestions will be very helpful
Thanks
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.1. Columns have a visibility property that can be based on any value.
2. Set the page height to something large.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:OprEejuVEHA.4092@.TK2MSFTNGP11.phx.gbl...
> hi
> I have 2 doubts . Need to finish some reports by tomorrow :
> 1.How to hide certain columns in a report based on say a value being
returned from a SP.
> 2. I want all the recoreds in the report to be shown in a single page and
without any page breaks...
> Any suggestions will be very helpful
> Thanks
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.