Parameter Problems

[polynominalc]

Hi

Im using Crystal Reports 9.

I have a couple of problems regarding parameters.

1. I have a memo field called product, I need to put this into a parameter for my users to pick. As the crystal parameter does not allow me to do this, does anyone know another way that I can get this field into a parameter.

2. I have a date whose datatype is a number and the application starts at 1970. I have to do a formula to get the dates right that I need. Again I need to put this into a parameter so my users can pick a starting and closing date. Any ideas

Thanks

PC

 

[synapsevampire]

1) Since you can't use a SQL Expression to populate a parameter default values, one solution would be to create a View and cast the memo to a varchar.

2)Create a date range parameter and then create formulas to convert the minimum and maximum parameter values to the numeric value and reference the formula in the record selection formula. Make sure that you check the Database->Show SQL Query to assure that the SQL is being passed.

If you need details, let me know, and verify that the date is seconds since 1/1/1970.

-k