COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Revathi_M on 26 Dec 2014 10:54:10 PM

Title: how to use two variables in single style variable
Post by: Revathi_M on 26 Dec 2014 10:54:10 PM
Hi anybody explain me,

I have 3 tabs and one export excel button

i written sapare variabels for tabs and export to excel

i am using style variable for active tabs but same time i need eexport to excel only active tab. not other tabs but in HTML its show all tabs

i tryied like this it not working :

Case
When ParamDisplayValue('Param_tabs')='LIST'  or  (ReportOutput() in ( 'XLS','singleXLS'))Then  'LIST'
WHEN When ParamDisplayValue('Param_tabs')='CHART'  or  (ReportOutput() in ( 'XLS','singleXLS'))Then  'CHART' 
When ParamDisplayValue('Param_tabs')='Crosstab' or  (ReportOutput() in ( 'XLS','singleXLS'))Then  'Crosstab'
end

Title: Re: how to use two variables in single style variable
Post by: Ammus1234 on 31 Dec 2014 11:42:57 PM
You can create a string variable. It should work. What is the error you are getting?