Thursday, March 29, 2012
alternate row in table
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.
Sunday, February 12, 2012
All that extra whitespace that displays in HTML
So I have a footer row in a table that is set to 0 height. Actually it is set to 0.03125in because SSRS doesn't allow a 0 height, but whatever.
When I view this in the designer preview, life is good. The amount of whitespace on each footer is minimal and a minor nuisance.
But after deploying to the server and viewing in the web browser, the whitespace is much more pronounced. Any special reason why these display differently, and any way to shrink down that HUGE row whitespace?
Can't you just select the whole footer row and delete it if you are not using it for anything? That would eliminate the space on the report.|||Please give me a little credit. I know how to delete a row.
No that won't work. This is a sweet little workaround for other major deficiencies that exist in SSRS.
But now the new problem is that the way HTML is rendered in the Report Viewer is different than the display in the Visual Studio environment. Namely all that extra whitespace and no way seemingly to control it by specifically setting the size of the row or assigning css styles.