cancel
Showing results for 
Search instead for 
Did you mean: 

Yes/No parameter determines if Second parameter(s) is used or not

0 Kudos

I am currently using Crystal Reports 2016. What I am attempting to do is when the Previous Month parameter comes up and you choose YES, then it run for previous month (lastfullmonth). I don’t want the Episode Start Date parameter and Episode Stop Date parameter be required to have a date inserted.

When the Previous Month parameter comes up and answer is NO, then it should require you to put in dates for the 2 parameters.

(IsNull({VWCIS_EPISODE.EPI_END_DATE}) or {VWCIS_EPISODE.EPI_END_DATE} >= {?Select Start Date} and {VWCIS_EPISODE.EPI_START_DATE} <= {?Select Stop Date}))

The following is my Select Expert:

{VWCIS_EPISODE.EPI_FAC2} = {?Facility #} and {VWCIS_MOVEMENT.STAT_FC} in ["1", "2", "5"] and

{TBST04A.DIAGNOSIS_CODES} like "F*" and {@DD Facility} and

(if {?PreviousMonth}= "Yes"

then

(IsNull({VWCIS_EPISODE.EPI_END_DATE}) or {VWCIS_EPISODE.EPI_END_DATE} >= minimum(lastfullmonth) and {VWCIS_EPISODE.EPI_START_DATE} <= maximum(lastfullmonth))

Else

(IsNull({VWCIS_EPISODE.EPI_END_DATE}) or {VWCIS_EPISODE.EPI_END_DATE} >= {?Select Start Date} and {VWCIS_EPISODE.EPI_START_DATE} <= {?Select Stop Date}))

The following are my parameters

{?Facility #}

{?PreviousMonth}

{?Select Start Date}

{?Select Stop Date}

Former Member
0 Kudos

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with: https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members.

For example, you can:

- outline what steps you took to find answers (and why they weren't helpful)

- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags

- use a more descriptive subject line

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html

Questions on how to draw responses from members? Check out this discussion on how to improve questions. https://groups.community.sap.com/t5/welcome-corner-discussions/advice-from-sap-champions-questions-a...

Accepted Solutions (0)

Answers (0)