Return a Table from a Stored Procedure

Question

Return a Table from a Stored Procedure

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

goodguy SSCertifiable Points: 5456 More actions · Answer 1

Hi, guys, sorry to bother you again but I need help from any Crystal Reports pros here. What is the proper format to pass date values to DateTime variables in the sproc via CR8?

I normally use the standard format:

[Code]CR1.ParameterFields(0) = "FromDate;Date(" & Format(DTPicker.Value, "YYYY,MM,DD") & ");True"[/Code]

This is rendered as an invalid format sprocs. I've tried other formats to no avail. Any help will be appreciated.

Regards,

goodguy

Experience is a bad teacher whose exams precede its lessons

mrpolecat SSCertifiable Points: 7014 More actions · Answer 2

I don't know about CR but I would suggest starting a new thread for the question so people who do can answer it. You may also want to post it under a topic like programming or reporting so you get the right people looking at it.

goodguy SSCertifiable Points: 5456 More actions · Answer 3

I fixed it somehow; I don't know why CR was displaying the parameters in an order different from the one required by sproc, so I reordered them.

Thanks to all.

Regards,

goodguy

Experience is a bad teacher whose exams precede its lessons

John Esraelo-498130 SSCertifiable Points: 5914 More actions · Answer 4

The SP returns the data-set as a tabular and good for RDL or crystal reports. But, this sp is really not returning a "table" value set as in Functions.

In another word, if you are in another TSQL or a process you may not call the SP with

...

select * from SP_XYZ..

only

exec SP_XYZ or SP_XYZ is allowed.

Make sense?

Cheers,
John Esraelo