Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2007
    Posts
    1

    Unanswered: anyone had experience creating business view for a stored procedure?

    I am able to create one, but not able to use it in crystal report. I am on Crystal Report XI SP1

  2. #2
    Join Date
    Jul 2007
    Posts
    54
    Why not try populating a table with your stored procedure?

    1/ Your stored procedure would delete all data in the table first (DELETE FROM)
    2/ Next it populates the new snapshot from your stored procedure (INSERT INTO)
    3/ Now you can report on that data with Crystal

    HTH
    Caspar

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •