Using Stored Procedures and Crystal Reports

[clydejones]

Hello,

I have a complex report I need to create. Actually, there will be serveral of them. I have been suggested (from this forum)to use Store Procedures to create my data sets. My doubt is how do I populate the fields in Crystal with the correct data. I believe I can handle the Store Procedure and attaching it to the report. I'm just a little confused as to how populate the fields in Crystal. Any help (especially example code) would be appreciated.

Thanks In Advance,
Clyde

 

[konad]

) in your procedure you will have included your fields, and when you go to crystal and add the new database table "Stored Procedure" you will see all of the fields you selected in your SP, then you can use it like the others and simply drop down the box of listed fields to insert into your report.