select * from ${if(campus="1","aa","bb")}

用if  直接替换表就好了  if可以无限嵌套

select * from ${if(campus="1","aa",if(campus="2","bb","cc"))}

SWITCH(F4,1,sql("FRDemo","SELECT * FROM STSCORE where CLASSNO = 'Class1' ",3,1),2,sql("FRDemo","SELECT * FROM STSCORE where CLASSNO = 'Class1' ",3,2),'3',sql("FRDemo","SELECT * FROM STSCORE where CLASSNO = 'Class1' ",3,3))

根据不同的值，执行不同数据集的sql，“FRDemo”这个可以替换成其他数据集，可以同时执行不同数据集的。已测试正常使用。

${switch(sta,

1,"select  '1'  a  from dual ",

2," select '2'   a from  dual")

}

${=SWITCH($campus,'1','select * from aa','2','select * from bb')}

你的问题是，写了两个美元号，造成公式错误了。

去掉里边的美元号