Prev: sql server report 2008 export options
Next: Permissions and Roles Questions
From: onkarsinghsaini on 20 Mar 2010 14:16
I am creating a SSRS 2008 report and there is a grouping in a column in the
table and i need to insert a line when the group changes. For example:

1 abc
1 def
1 ghi
1 jkl
------------------------------------
2 john
2 maria
2 Cheryl
2 Oneil
--------------------------------------
3 kl
3 po
3 uy
3 op
---------------------------------------

From: Mike Lum on 22 Mar 2010 10:53
For the entire row on the layout, change the Top BorderStyle Property
to the following:

=iif(RowNumber("table1_Group1") = 1 and RowNumber(nothing) <> 1,
"Solid", "None")

Where "table1_Group1" is the name of your grouping. The
RowNumber(nothing) will return the row number without the grouping, so
that allows the first row to not have a line at the top.

-Mike Lum

From: onkarsinghsaini via SQLMonster.com on 24 Mar 2010 03:05
Thanks Mike for the reply.

I tried your suggestion, Its working.
I got one more solution for this issue. I would like to share with you.
I tired as follows

=IIF(Fields!CloumnName.Value <> Previous(Fields!CloumnName.Value),"Solid",
"None")

here CloumnName is the column on which the grouping is done.




Mike Lum wrote:
>For the entire row on the layout, change the Top BorderStyle Property
>to the following:
>
>=iif(RowNumber("table1_Group1") = 1 and RowNumber(nothing) <> 1,
>"Solid", "None")
>
>Where "table1_Group1" is the name of your grouping. The
>RowNumber(nothing) will return the row number without the grouping, so
>that allows the first row to not have a line at the top.
>
>-Mike Lum

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/201003/1

 | 
Pages: 1
Prev: sql server report 2008 export options
Next: Permissions and Roles Questions