Click here to Skip to main content
15,886,851 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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

 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900