Can you use a Microsoft SQL Stored Procedure to populate a sub-report (cfr) either by "Embedded Stored Procedure(s)" within the report builder or called by a CFM template? If so, how is this accomplished? We know that you can use a Microsoft SQL Stored Procedure in a CFM template to populate the report. Also, why don't the stored procedure(s) show up under the "Queries" folder for the ODBC data source within the "Query Builder"? Thank you in advance for all of your help!
Gary 8-) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202033 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54