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
