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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Data connection parameter ?!? 1
- Thread starter FredGexel
- Start date
- Thread starter
- #2
-
1
- #3
You could:
a) Base the report on a stored procedure. Based on the table name parameter that you pass to the stored procedure, execute a different SELECT statement to pass data back to the report.
b) Base the report on an ADO recordset. Pass the appropriate recordset to the report when the user selects the table parameter. Brian J. Alves
Email: brian.alves@worldnet.att.net
VB / ASP / Crystal / SQLServer
a) Base the report on a stored procedure. Based on the table name parameter that you pass to the stored procedure, execute a different SELECT statement to pass data back to the report.
b) Base the report on an ADO recordset. Pass the appropriate recordset to the report when the user selects the table parameter. Brian J. Alves
Email: brian.alves@worldnet.att.net
VB / ASP / Crystal / SQLServer
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question