Hello Guru's
I am converting Crystal report to WebI. I was trying to create prompt in Designer but I couldn't do it. Can anybody help me to write this code in Universe Designer. We are using BOXI3.1,SQL Server.
Crystal Formula:
(if {?Period} ='Week' then // if selected period is week
{DC_downtimeUptimeDCS.stopTime} >= date(year({?currentdate}),month({?currentdate}),1) //beginning of Month MTD
else // if seleted period is month
{DC_downtimeUptimeDCS.stopTime} >= date(year({?currentdate}),1,1) //beginning of Year for YTD)
Any help would be highly appereciated.
Thanks
Nisniki