Creating a command based on data in a binary field 1

[tsouth4]

I am designing a report which the date field is actually a binary number. The table WM_ARTSEARCH2 was created on 12/31/03 and the data in binary field BIN goes back to 01/22/2004 which is binary # 22. I was able to create a formula:
DateValue({WM_ARTSEARCH2.BIN})+37986

which I could use as a filter when pulling data over a desired date range.

Needless to say this worked fine. However now I am trying to create a parameter field based on this field but am unable to do so because its a formula field. So I'm wondering what my options are. I would like to publish this report to a Reporting server so the user would be able to open this report based on a desired date range. They will be opening the report in BOE "Business Objects Enterprise". I believe one option is to create a command in the database expert however I'm not sure how to do this. Well I'm not sure what the sql would be. Any help would be appreciated.

-Tim

 

[lbass]

I'm unclear on the issue. Since you've converted the field to a date datatype, all you need to do is set up a parameter of date datatype, and then in the record selection formula, set the formula to the parameter:

{@formula} = {?date}

Or are you trying to build a list of values to correspond to the parameter?

-LB

 

[tsouth4]

I'm trying to create a parameter on a formula so I can publish the report to a reporting server. However Crystal does not allow you to create a parameter field on a formula.

 

[lbass]

I don't follow. Parameters are holders for user-selected values that are then set equal to a database field or a formula. And you can definitely create a parameter and set a formula equal to it.

-LB

 

[tsouth4]

Thanks LB I'm not sure why I didnt try this to begin with. I guess being a binary field kind of scared me off.