Using Stored Procedure with CR 11
I'm using Crystal Reports 11 and was wondering if it's possible use Stored Procedures with it? I have a report in which I have no idea how to show the data just by creating Formulas. I need to "Count" data but the data is derived from several SQL Server Tables. I'm clueless as to how to accomplish this.
Any ideas or other solutions are helpful!
Thanks,
Re: Using Stored Procedure with CR 11
May be you can user Crystal report's fomula field to count data !
Re: Using Stored Procedure with CR 11
I'm not good with complex formulas...
Re: Using Stored Procedure with CR 11
can you give some example like what will be your i/p and what's expected o/p ?
Re: Using Stored Procedure with CR 11
can't do that due to company security policies...
Re: Using Stored Procedure with CR 11
Yes, It's possible to create a report from Stored Procedures in a SQL Server
When You select the DataSource for the report You will see in the DataExplorer, the tables, views and StoredProcedures that are in the SQL Server, and You can select and relate them