Report Builder and stored Procs

[LanceS]

Is it possible to use a stored proc instead of query in report builder. This
tool lacks any documentation that I can find. I have tried both: cfstoredproc
proceedure='myProc' and CFQUERY exec myProc niether seem to work. Thanks in
Advance for any help.

[Dean Harmon]

Yes, it can absolutely use stored procs. If you use the advanced query to
create it, however, the builder cannot automatically introspect the result
set. Using SQL Server syntax for queries, though, you could simply type
"exec myCoolStoredProc" in the text area of the query builder and it will
work (this is what gets wrapped up inside of a cfquery block).

Dean

"LanceS" <webforumsuser@macromedia.com> wrote in message
news:d0ne3l$92h$1@forums.macromedia.com...

> Is it possible to use a stored proc instead of query in report builder.

This

> tool lacks any documentation that I can find. I have tried both:

cfstoredproc

> proceedure='myProc' and CFQUERY exec myProc niether seem to work. Thanks

in

> Advance for any help.
>