我需要使用用户提供的报表参数筛选Server (SSRS)中的视图,但是它应该只应用由用户启用的那些筛选器,即报表参数不为NULL的情况。此外,只有<运算符工作,=运算符返回“传递给SUBSTRING函数的无效长度参数”。谢谢!SELECT FROM AND
[prefix] = ( CASE WHEN @rp_prefix IS NOT NU
%2fKonsolidata_Data_Exporting_Project%2fEXPORT_REPORT_TEST&rs:Command=Render&RP_cntry="+Fields!STD_CTRY_NM.Value+"&RP_cll_typ_l1="+Join(Parameters!RP_cll_typ_l1.Value,",")+"'))"喜欢
An error has occurred during