Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sachya45
Starting Member
25 Posts |
 Posted - 2009-08-25 : 11:03:55
|
| HI All,I want to write visibility expression on my table footers....**group1 footer1(forX=2or3) total*1 total*2 Total*3 Total*4**Group1 footer2(forX=1or4) total*1 Total*2 Total*3 Total*4-------------------------------------------------------------------------Group1 Footer(forX=2or3or1or4) Total *1 Total*2 Total *3 Total*4I want to show group1 footer1(for X=2or3) AND group footer2(for X=1or4) ONLY IIF I have total values for both conditions as if when i have ((X=2 or 3)AND (X=1 or 4)) rowsif i have no rows for x=2 or 3....then dont show group1 footer1 and group1 footer2i have tried to do with following expression for visibility condition on footer1 and footer2=IIF(((countrows("table1_group1",(IIF((X="2" OR X="3"),1,0))>0))AND(countrows("table1_group",(IIF((X="1" OR ="4"),1,0))>0))),false,true)but i am getting error ....The hidden expression for the "table1" uses an aggregate expression with an invalid recursive/simple flag.The valid values for this flag are "recursive" and "simple".Please help this is urgent....Experts if you any other way to do it please explain... |
|
|
|
|
|
visibility issue with group footer