Print Page | Close Window

Crystal subreport Oracle Table View where 0=1

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17440
Printed Date: 21 Apr 2025 at 1:10am


Topic: Crystal subreport Oracle Table View where 0=1
Posted By: alcutri
Subject: Crystal subreport Oracle Table View where 0=1
Date Posted: 29 Aug 2012 at 2:25am
Hi,

We have a problem with table view oracle and subreport crystal, well.

   When we runinng the report with this subreport the same send is sent to database the following instruction:

    select * from view_table_oracle where 0=1

    Same we sending the parameter on the subreport
    exemple:
       select id_name, name, sector
       from view_table_oracle
       where id_name={?P_IdName}
       
    




Replies:
Posted By: hilfy
Date Posted: 29 Aug 2012 at 3:31am
I think this is being sent to the database as a way of verifying that all of the fields in the view are what Crystal expects them to be.  So, I think this will go away if you open the subreport and Select Report Options then turn off "Verify on First Refresh". 
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: alcutri
Date Posted: 29 Aug 2012 at 6:46am
 
   The parameter "Verify on First Refresh" is unchecked.
 
 
Thanks.

Posted By: alcutri
Date Posted: 29 Aug 2012 at 6:47am
Originally posted by alcutri

 
   The parameter "Verify on First Refresh" is unchecked in the subreport.
  
 
Thanks.

Posted By: hilfy
Date Posted: 29 Aug 2012 at 6:50am
Is it unchecked in the main report?  Thinking about it, the subreport data is verified when main report verifies data.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: alcutri
Date Posted: 29 Aug 2012 at 8:19am
It is now unchecked in main report and subreport, in the test in the crystal developer donīt showed any more, but still we needs to test the report with our system.
 
Thanks a lot.


Print Page | Close Window