shortstuff2212
Programmer
If a VB6 program passes a parameter into a crystal report is there any way I can tell the report to look for the parameter and populate the report based on the parameter?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Can a report print data based on a parameter
- Thread starter shortstuff2212
- Start date
- Status
sure...done all the time....that is the purpose of the parameter.
In the record selection formula you would use this parameter
{table.field} = {?Parameter}
for example: You might create a parameter called "CompanyID" and refer in the record selection formula to a {table.CompanyID}
the above formula would only select companyID's from the database that matched the user (or VB) inputed parameter. Jim Broadbent
In the record selection formula you would use this parameter
{table.field} = {?Parameter}
for example: You might create a parameter called "CompanyID" and refer in the record selection formula to a {table.CompanyID}
the above formula would only select companyID's from the database that matched the user (or VB) inputed parameter. Jim Broadbent
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question
- Question