Click here to Skip to main content
14,271,871 members
Rate this:
Please Sign up or sign in to vote.
See more:
I did group by account number in ssrs Table . Now i want when the account number group will be end the horizontal line will be come ..


for eg :

AccountNumber:1000
1 . 100% European Opportunities Series DBT
2. 100% Securitized Assets Fund (Delaware) L.P.
-------------------------------------------------------------
AccountNumber:2000
1 . 100% European Opportunities Series DBT
-------------------------------------------------------------


In the above example in 1st group i am shoiwng two records then line in second group i am showing 1 records then line

What I have tried:

Select entire group row then press f4 .
Go to borderstyle property ->Go to Top->put below expression

=Iif(Fields!AccountNumber.Value = Previous(Fields!AccountNumber.Value) OR Fields!AccountNumber.Value = First(Fields!AccountNumber.Value, "AllocationHistory"),"None","Solid")


i got this error mentioned below : 
[rsInvalidAggregateScope] The BorderStyle expression for the text box ‘AccountNumber’ has a scope parameter that is not valid for an aggregate function.  The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a dataset.
Posted
Updated 17-Jun-19 1:47am
v6

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100