Skip to Content
0
Former Member
Jun 15, 2009 at 06:20 PM

Case Statement in Universe Designer

63 Views

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