asked on
Sql Server Stored Procedure and Crystal Reports
I am using CR 9.2 and Sql Server 2005. I want to create a new crystal report...I go and set the location in the report to my sql server. I then go to the database expert and navigate to my stored procedure I just created. I hit > to add it to the "Selected Tables" and hit OK. On my crystal designer I see the stored procedure under the Database Fields but there are no fields to select to put on my report. Can someone please help me with this.
Thanks
Thanks
Crystal Reports
Last Comment
rvinicky
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
I have the same issue. My stored procesure needs to create some tables before running. Is that an issue?
rvinicky - You will better results if you ask your own question
mlmcc
mlmcc
mlmcc, thanks for your reply. As I said in my previous post, I have the same issue posted initially by tbailey922: "I see the stored procedure under the Database Fields but there are no fields to select to put on my report"
.... My stored procedure needs to create some tables before running. Is that an issue?
.... My stored procedure needs to create some tables before running. Is that an issue?
rvinicky - What about my post didn't you understand?
mlmcc
mlmcc
Forget it. I don't need your help anymore.