Case Statement in Universe Designer

[Former Member]

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

[Former Member · Accepted solution]

Hi,

Can you please explain what exactly you are trying to do in universe designer( I MEAN what exactly you need what is your requirement)?

Thanks,

SK.

[Former Member · Accepted solution]

Hi,

Thanks for the Reply. I have Date parameter and Period Parameter(Two Values Weekly and Monthly). If I Select Date Parameter 04/23/2009 and I select Period as Weekly, then I should get the records Month to date. I should see the records from 04/01/2009 to 04/23/2009 and If I select Monthly as Period then I should see 01/01/2009 to 04/23/2009.

Thanks

Nisniki

[Former Member · Accepted solution]

Hi,

Can you please explain how did you reslove your issue. Sorry that i did not respond back in time.

Thanks,

SK.