Requirements of SQL Server 2005 Stored Procedures for Crystal Report 1

[gtb12314]

Hi All,

I want to learn how to create crystal report off of SQL Server 2005 Stored Procedure. So anybody please let me know from where I can download the documentation on "Requirements of SQL Server 2005 Stored Procedures for crystal report.

I am using Crystal Report XI. Any help is greatly appreciated.

Thank You

 

[dgillz]

I don't think there are any. Under file, options, database tab, make sure that "stored procedures" has a check next to it.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[mikeprog]

Please see

https://www.sdn.sap.com/irj/scn/go/...ary/uuid/40a8a5f2-a81e-2b10-da9f-9282db9fedae

for a simple list of what this looks like. You can place the stored procedure fields on the report just like any other data source. Please be careful with null values.

 

[briangriffin]

Does anyone have a creative way to pass a date range to a SQL Server stored procedure? The SP has two input parameters, StartDate and EndDate. I was thinking that calling the SP from a command object might work, but so far no luck - something like this:

declare @min smalldatetime, @max smalldatetime

set @min = minimum({?Date Parameter}),
@max = maximum){?Date Parameter})

exec spname @min, @max

The user does not want to use two parameters, StartDate and EndDate, but it might have to be that way. Any ideas are welcome.

Thanks.