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!
Sincerely, Andrew ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202174 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54