SQL Expression in PARAMETER?

I have the following SQL Expression in my report. Is it possible to use this in a PARAMETER in order to use the PARAMETER in my SELECT CRITERIA? I don't see it as a data element to use, althought I am able to use it in the actual SELECT CRITERIA????

(
SELECT min([Applicable Date])
FROM
  bankruptcy.dbo.RLS
WHERE
  [FILE NUMBER]=  "BKCYACCT"."FILE NUMBER"

)

thanks
Mike
LVL 17
MIKESoftware Solutions ConsultantAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

dylanyeeCommented:
Hi Mike, I've never tried to pass in the entire sql expression to parameter so I am not sure is there a way.
But I would suggest you to alter the formula for select expert in runtime instead of pass in as parameter, this is the property you could you to alter your select expert's formula:

rptDoc.DataDefinition.RecordSelectionFormula

dylan
0
dylanyeeCommented:
Sorry my mistake, what you are talking is SQL Expression but not select expert. Just ignore my suggestion.

dylan
0
MIKESoftware Solutions ConsultantAuthor Commented:
Actually Dylan, I just used the MIN of the actual date field [APPLICABLE DATE] for the report. I just wanted to display the TO FROM REPORTING DATES in the header. I WAS using the parameter to do this, but had to change this. The paramter WAS a SQL Expression.l

I hope I'm making sense, but anyway thanks for the input....I just did a MIN(APPLICABLE DATE] for the FROM and a MAX[APPLICABLE DATE] for the TO date.

THANKS.....Mike
0
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
Hi Mike,

You can't use Formulas or Parameters within a SQL Expression.  You can only use true database fields, database functions are are available through your DB and method of connectivity (ODBC, for example) and true SQL recognized by your database.

You can, however, refer to a SQL Expression from within a formula or the record selection criteria.

~Kurt
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.