alternate colors

Hello all,

I am using sql reproting 2000. I have areport which spans a number of pages...say for every radio station, the report starts with a new page. On every page, I must have alternate row colors(white and gainsboro). It was easy to do that. The issue is, for every new page the report renders for every new radio station, the first row must be white. Say...Radio Station 1, the alternate row colors will continue...i.e white and ganisboro. But for radio Staion 2, the first row should be white again. I hope I have explained it clearly enough.

For alternate row colors, I use either an expression -

IIF(RowNumber("ds_LineUpByFeedDetail") Mod 2, "White", "#dddddd")

OR a VB Function in CODE window.

Thanks......

You can try specifying the name of the radio station group as the scope argument for the RowNumber function, instead of the dataset name, i.e. =IIF(RowNumber(<RadioStationGroup>) Mod 2, "White", "#dddddd").

Allow NULL - Skips User Input

Hi All,
I have a report with only one parameter(Date field). It is set to allow null
value.
When I click the report it immediately starts rendering the report instead
of waiting for user input. Is it anyway to make the report to wait for user
input without removing the allow null value?
TIA,
SamuelMy understanding of your questions is that you want the report to only begin
generating after the user selects a parameter value and clicks the View
button.
If all parameters have a default value the report will execute immediately.
This is by design and cannot be modified unless you write own parameter
interface.
The workarounds are
* Do not supply a default value to one or more of parameters.
* Create a dummy report parameter and do not supply it with a default
value.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Samuel" <samuel@.photoninfotech.com> wrote in message
news:e4$C6aCgEHA.904@.TK2MSFTNGP09.phx.gbl...
> Hi All,
> I have a report with only one parameter(Date field). It is set to allow
null
> value.
> When I click the report it immediately starts rendering the report instead
> of waiting for user input. Is it anyway to make the report to wait for
user
> input without removing the allow null value?
> TIA,
> Samuel
>