Crystal report command parameter via table

Is there a possibiliy of passing values from a regular table as a parameter value in crystal report command?

For example: table Ordertrack (with fields: originatorid, requestdate)

Sql Command:

Select * from EmployeeeLoan where EmployerID={?@originatorid} and LoanDate >={?@requestdate}.

We cant join these 2 tables together but using a sql command would be most efficient if the command can accept values from the Ordertrack table for its parameters.
LVL 1
ITDeptAtPCSAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Kurt ReinhardtConnect With a Mentor Sr. Business Intelligence Consultant/ArchitectCommented:
In other words, you want to use one table as the source for the List of Values with a dynamic parameter.  The short answer is no.  Dynamic parameters aren't compatible with SQL Commands. That being said, if you capture the dynamic parameters in a container report, you can pass them to a subreport that uses the command.   So, build a blank report against one table and create dynamic parameters against that table.  Then, create a subreport based on the command and link the main report to the subreport based on the parameter values in the main to the parameter values that exist inside the command.

~Kurt
0
All Courses

From novice to tech pro — start learning today.