Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Parameter Query for True or False values

I have what seems like a painfully simple task and it has me stopped dead. I reviewed a similar thread, and the answers there don't seem to apply. Working in Crystal 11.5 with an MS SQL database.

I am pulling data from vwCommmittees. There is a field in this view called IsActive. I want to create a committee list report that will allow the user to select only the active committees or all committees.

A SQL select statement that says where dbo.IsActive = '1' will return only the active committees.

In Crystal reports, if I place the IsActive field on the report, it returns with "True" or "False."

When I create a parameter for this field, I find that 1) I can't see the parameter in the report expert -- my only choices are Is any value, Is true, Is false or Formula.

I've made several attempts to create a formula and nothing is working. It's not clear to me wheter I should be creating a static or a dynamic parameter. When I choose boolean as the type, that doesn't seem to help. I tried a dynamic parameter which gave me true and false values, but don't seem to work.

Any pointers on dealing with this kind of parameter query would be greatly appreciated.

Sincerely,

Ridge (in New Joisey)

Former Member
replied

Hi..

Create a static parameter and give the default values like

0 and 1

In Record Selection check like..dbo.IsActive = {?parameter}

If the above is not working for you, then create a formula

like..

If dbo.IsActive = '1' then

"Active"

Else "In Active"

Place this formula on your report and create a static parameter with default values Active and In Active.

In record selection filter the above.

Thanks,

Sastry

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question