Crystal Report: Stored Procedure and Temporary Table

Discussion in 'ASP General' started by arock, Jul 12, 2006.

  1. arock

    arock Guest

    I've created a SQL Server stored procedure that uses a temporary table
    (#tempTable) to run some sub-queries within the main SELECT statement.
    This works perfectly fine within the Crystal Designer environment
    (version 9.0). However, when I run this report via an ASP web page the
    fields that are using the temporary table show up blank, while the
    other fields show up fine that are not referencing this temporary
    table. Why does it work fine in the design environment but not on the
    ASP web page? I can provide more details if necessary.
     
    arock, Jul 12, 2006
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. kavitha N via .NET 247

    passing parameters to stored procedure from crystal reports

    kavitha N via .NET 247, Jun 8, 2005, in forum: ASP .Net
    Replies:
    1
    Views:
    10,825
    galahad
    Feb 15, 2011
  2. kenneth xg
    Replies:
    2
    Views:
    7,358
    crdev
    Apr 23, 2005
  3. Mike P
    Replies:
    0
    Views:
    3,312
    Mike P
    Jun 19, 2006
  4. Morten Snedker

    Report, reportviewer and stored procedure

    Morten Snedker, Jan 25, 2007, in forum: ASP .Net
    Replies:
    2
    Views:
    1,131
    Morten Snedker
    Jan 25, 2007
  5. Comfort
    Replies:
    0
    Views:
    558
    Comfort
    Oct 18, 2004
Loading...

Share This Page