Stored Procedure in Report

[hahsia]

Hi,

After my successful attempt to use views for my customized accpac reports, i'm now wondering if i can use stored procedure in my reports.

I actually try it out but not very successful.
Anybody have ever tried this or have any advice please help.

Thanks in Advance.

 

[hahsia]

Can i call an sql stored procedure from accpac macro?
Please advice.

 

[Lancedac]

I know that you can run an Accpac report through crystal that is based on a sql stored procedure. You could probably test your objective by creating such a report in crystal then record a macro from the Accpac desktop that calls it.