You should be able to use anything as a datasource for a report. You just pass it in. You just don't get the benefit of the fields automatically being available in design mode. You have to know the names being passed in. Constanty “Connie” DeCinko III Web Architect, Webmaster, Web Developer Lone Jet Enterprises Glendale, Arizona www.LoneJet.com
-----Original Message----- From: Andrew Peterson [mailto:[EMAIL PROTECTED] Sent: Monday, April 11, 2005 8:26 AM To: CF-Talk Subject: Report Builder Subreports and Stored Procedures 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:202179 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