Results 1 to 2 of 2

Thread: Report failing

  1. #1
    Join Date
    Feb 2004
    Posts
    106

    Unanswered: Report failing

    I have a crystal report that uses several tables and views from the same data source. I added a stored procedure to the mix and I get the following error: "More than one data source or a stored procedure has been used in this report. Please make sure that no SQL Expression is added and no server-side group-by is performed". The report runs fine if I don't use any of the fields from the stored procedure, but when I use a field the report fails and I get a "not supported" message. Please help.

  2. #2
    Join Date
    Jun 2004
    Posts
    10
    Hello,

    This had a very similar problem myself with a report and using a stored procedure. Didn't exactly find out what was happening but got around it by creating a new SQL table and then amending the stored procedure with TRUNCATE and INSERT commands to populate my new table from the stored prcoedure.

    Hope this helps.

    Cheers
    Neal

Posting Permissions

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