on 10-06-2008 6:35 PM
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)
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thnaks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.