Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Clownkiller
- Order by date
-
Crystal 10 not returning all columns from a stored procedure (SQL2008)
Yay - sorted it! After a day and a half, its come down to the nested stored procedure having a Begin Transaction and a commit/rollback depending on the results. It would seem that Crystal doesn't like this. And handily for me, the developers only had this in for debugging and it can be removed...- Clownkiller
- Post #4
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Crystal 10 not returning all columns from a stored procedure (SQL2008)
Hi Ian, Thanks for your time. I have tried creating a new report pointing at the stored procedure, and I am only getting the one column. With regards your question, yes the left hand panel has all the columns in it, the right hand one contains only the one. However...I have been playing...- Clownkiller
- Post #3
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Crystal 10 not returning all columns from a stored procedure (SQL2008)
Hi - I hope there is someone that will be able to help with my odd little situation with SQL2008 and Crystal Reports 10. I have a stored procedure that returns a whole bunch of columns when run in SQL, and I am happy that it is working fine. However...when Crystal Reports is set to use this...- Clownkiller
- Thread
- Replies: 3
- Forum: Business Objects: Crystal Reports 4 Other topics
