alternate row in table

I have a table with a header and a detail. How I can set the detail so that
it displays alternate color? Thanks.Try this:
=IIF(RowNumber(Nothing) Mod 2,"WhiteSmoke", "White")
WhiteSmoke and White being the two variable colors.
Select the detail row and in the background properties select "Expression".
Then put that formula in.
Cheers.
"tangolp" wrote:
> I have a table with a header and a detail. How I can set the detail so that
> it displays alternate color? Thanks.|||I have used this but I condionally set a row to hidden based on a value.
When a row is hidden SQL RS thinks it's still there and I get two back to
back colors. Any ideas how to fix this?
Thanks,
Don
"Michael Montgomery" wrote:
> Try this:
> =IIF(RowNumber(Nothing) Mod 2,"WhiteSmoke", "White")
> WhiteSmoke and White being the two variable colors.
> Select the detail row and in the background properties select "Expression".
> Then put that formula in.
> Cheers.
> "tangolp" wrote:
> > I have a table with a header and a detail. How I can set the detail so that
> > it displays alternate color? Thanks.

Alignment/Formatting in Page Header...

I find that if I use a bunch of textboxes in a 'tabular' layout in the page
header (or anywhere) things dont line up quite right. I need a table in info
in the page header (not from a dataset just static text and param labels) so
I figure I'll use a table in the Page Header but it tells me that I cannot
use a 'data region' in the page header.
There has to be a way to create a 'table' like layout in the page header!
Any feedback/suggestions are greatly appreciated.Are you using the align to: top, bottom, side tools?
"Terry Mulvany" wrote:
> I find that if I use a bunch of textboxes in a 'tabular' layout in the page
> header (or anywhere) things dont line up quite right. I need a table in info
> in the page header (not from a dataset just static text and param labels) so
> I figure I'll use a table in the Page Header but it tells me that I cannot
> use a 'data region' in the page header.
> There has to be a way to create a 'table' like layout in the page header!
> Any feedback/suggestions are greatly appreciated.
>
>|||I have had similar problems in the past. I ended up using tables in the
"Body" of the Report to display static text and param value instead of
placing individual text boxes in the Page header. Make sure that you set the
property (RepeatonNewPage) for the static header in the table to repeat in
every page.
"Terry Mulvany" wrote:
> I find that if I use a bunch of textboxes in a 'tabular' layout in the page
> header (or anywhere) things dont line up quite right. I need a table in info
> in the page header (not from a dataset just static text and param labels) so
> I figure I'll use a table in the Page Header but it tells me that I cannot
> use a 'data region' in the page header.
> There has to be a way to create a 'table' like layout in the page header!
> Any feedback/suggestions are greatly appreciated.
>
>|||Yes, but this does not help. When the report runs the gaps between say 6 or
so rows of info varies and looks terrible, when I use a table (only
available in Body though) all rows have the same distance between them and
it looks very nice. MS needs to create a new 'layout' tollbox control (or
modify the existing table so it can be used as a non-data region object).
"BK9" <BK9@.discussions.microsoft.com> wrote in message
news:ACD30BAB-C2D8-4F42-8BD5-D9499CB77961@.microsoft.com...
> Are you using the align to: top, bottom, side tools?
> "Terry Mulvany" wrote:
>> I find that if I use a bunch of textboxes in a 'tabular' layout in the
>> page
>> header (or anywhere) things dont line up quite right. I need a table in
>> info
>> in the page header (not from a dataset just static text and param labels)
>> so
>> I figure I'll use a table in the Page Header but it tells me that I
>> cannot
>> use a 'data region' in the page header.
>> There has to be a way to create a 'table' like layout in the page header!
>> Any feedback/suggestions are greatly appreciated.
>>
>>|||Can't actually do this because I need to display different headers on
different pages (based on Globals!PageNumber) and just as Data Regions
(tables for instance) cannot be used in Page Header, 'Globals' cannot be
used in Body. So I am stuck!
"Taps" <Taps@.discussions.microsoft.com> wrote in message
news:B3F8D95E-9581-47A1-9B52-E79DC61D7782@.microsoft.com...
>I have had similar problems in the past. I ended up using tables in the
> "Body" of the Report to display static text and param value instead of
> placing individual text boxes in the Page header. Make sure that you set
> the
> property (RepeatonNewPage) for the static header in the table to repeat in
> every page.
> "Terry Mulvany" wrote:
>> I find that if I use a bunch of textboxes in a 'tabular' layout in the
>> page
>> header (or anywhere) things dont line up quite right. I need a table in
>> info
>> in the page header (not from a dataset just static text and param labels)
>> so
>> I figure I'll use a table in the Page Header but it tells me that I
>> cannot
>> use a 'data region' in the page header.
>> There has to be a way to create a 'table' like layout in the page header!
>> Any feedback/suggestions are greatly appreciated.
>>
>>