Monday, February 13, 2012

Adding Borders in a matrix report RS 2005?

Hello,

I am wondering if anyone has come across a problem when you try to get formatting like this one below in a matrix report, RS 2005. Basically, I would like to have a border for every question and its related columns. Any help is greatly appreciated.

Thanks!

1. Question 1.SubQuestion Data 2.SubQuestion Data 3.SubQuestion Data 4.SubQuestion Data 5.SubQuestion Data 2. Question 1.SubQuestion Data 2.SubQuestion Data 3.SubQuestion Data 4.SubQuestion Data 3. Question 1.SubQuestion Data 2.SubQuestion Data 3.SubQuestion Data

Hello,

I played a little bit more today with the challenge above and was able to come up with some conditional formatting for a SubQuestion column which may be helpful in creating a border line for. So in RS 2005, I select a SubQuestion cell and go to View/Properties/BorderStyle/Top and paste the following expression statement: =IIF(LEFT(Fields!SubQuestText.Value,1) = "1", "Solid", "None") which copies automatically to BorderStyle property that looks like this:None, , , =IIF(LEFT(Fields!SubQuestText.Value,1) = "1", "Solid", "None") BorderColor property is set to Black. By using the following statements above, I would like to create a border line above every Subquestion cell value that starts with 1. Right now, this code generates a top border for the last question. Maybe someone has some ideas how I could generate a top border above Subquestion cells including values starting with "1"?

Thanks for your help!

|||

Hi!

I have a similar problem, did you get any solution?

Thank you!

No comments:

Post a Comment