ssrs desing issue
i have table , trying group date according set ....
and want separate each group row
as can see below when insert row group above data set, puts row in between each data value
so how can code put row above if first name = ozzy or barney
so ll end having ozzy , franck group together, barney , homer on top
individualid first name last name datecreated
1 homeer simpson 5/14/2012 7:13:14 pm
2 barney rubble 5/14/2012 7:13:41 pm
3 ozzy osbourne 5/14/2012 7:13:46 pm
4 franck man 5/14/2012 7:15:39 pm
all replies
- 0
// desing table before adding row above dataset , previous said above
individualid first name last name datecreated
--->row inserted here
[individualid] [firstname] [lastname] [datecreated]
// after inserting r0w ( borderstyle = none)above how looks
individualid first name last name datecreated
1 homeer simpson 5/14/2012 7:13:14 pm
2 barney rubble 5/14/2012 7:13:41 pm
3 ozzy osbourne 5/14/2012 7:13:46 pm
4 franck man 5/14/2012 7:15:39 pm
- 0
// below want see in design
individualid first name last name datecreated
1 homeer simpson 5/14/2012 7:13:14 pm2 barney rubble 5/14/2012 7:13:41 pm
3 ozzy osbourne 5/14/2012 7:13:46 pm
4 franck man 5/14/2012 7:15:39 pm
hi there
you can change hidden property of row
=iif(fields!firstname.value="barney" or fields!firstname.value="ozzy" , false,true)
=iif(fields!firstname.value="barney" or fields!firstname.value="ozzy" , false,true)
i putting screenshot help.
if have questions please ask.
many thanks
syed qazafi anjum
please click "mark answer" if resolves problem or "vote helpful" if find helpful
SQL Server > SQL Server Reporting Services, Power View
Comments
Post a Comment