sql server reporting services: Change subreport colors -- sql server reporting services

You're in the

sql server reporting services

group:

Change subreport colors

Nick
12/1/2005 1:26:03 PM

sql server reporting services:

I have a report in which I alternate colors between white and whitesmoke.
Simple report that contains a table with a header and a body. The body is
set to =iif(RowNumber(Nothing) Mod 2, "WhiteSmoke", "White") I then add
another row to my table, merge all cells into one and add a sub report to it.
Here I display more data by setting the parameter of the current customerID
that I am on. Is there a way to pull the current row color from by non
subreport row and apply it to the entire sub report? This way the main row
and sub report (no matter how may row of data it contains) will have the same

RE: Change subreport colors

v-mingqc NO[at]SPAM online.microsoft.com
12/2/2005 12:00:00 AM

Hi,

Welcome to use MSDN Managed Newsgroup!

From your descriptions, I understood you would like to set colors according
to per row's settings (For example, if the current row background color is
whitesmoke, the want the whole subreport background to be whitesmoke also).
If I have misunderstood your concern, please feel free to point it out.

Yes, we could add another parameter in the subreport and then set this
parameter value to be iif(RowNumber(Nothing) Mod 2, "WhiteSmoke", "White")
in main report. This parameter will pass the value to subReport,

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!

Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

RE: Change subreport colors

Nick
12/2/2005 6:06:02 AM

Just what I was looking for...Thanks!!!

[quoted text, click to view]

RE: Change subreport colors

v-mingqc NO[at]SPAM online.microsoft.com
12/3/2005 12:00:00 AM

Hi,

You are welcome! If you have any questions or concerns next time, don't
hesitate to let me know. We are always here to be of assistance!

Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn