Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2001
    Posts
    3

    Unanswered: SQL Expressions can not be used in this report

    CRAXDRT Error Occured on Server. - 2147189177 : SQL Expressions can not be used in this report.

    I wrote crystal report in version 9. In that i created one sql expression field and assigned default value as "1" and put it on web site and used ASP and activeX viewer to view the report. but I got error like this "CRAXDRT Error Occured on Server. - 2147189177 : SQL Expressions can not be used in this report".

    The sql expression objects cause Crystal to blowup at runtime but work fine within the crystal reports designer.

    Can any one of you help me to resolve the same?

  2. #2
    Join Date
    Jun 2004
    Location
    Portland, Oregon
    Posts
    2
    Did you use a Command, or SQL script, to pull the data into the report initially? If so, then there is your problem. There is no need for an SQL expression in a report that uses an SQL script as a data source. If not, then No idear!

  3. #3
    Join Date
    Oct 2001
    Posts
    3
    I do not know what you meant by command or sql script. Let me clearly explain you what we have done in the crystal report and the problem that we are facing at runtime.

    There is details section that has a sql expression field that has the simple
    constant "1" as its value. In the footer a field that sums the count of the
    1's in the details sections. We got the above said error while running the report from js / asp file. The following snippet is used for viewing the report at runtime:
    CRep = Session("oApp").OpenReport (rptPath, 1);
    CRep.Database.Tables.Item(1).SetDataSource(RecordS et,3);

    is there any parameter that needs to be set in order to run the report?

Posting Permissions

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