Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Crystal subreport Oracle Table View where 0=1 Post Reply Post New Topic
Author Message
alcutri
Newbie
Newbie


Joined: 29 Aug 2012
Location: Brazil
Online Status: Offline
Posts: 4
Quote alcutri Replybullet Topic: Crystal subreport Oracle Table View where 0=1
    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}
       
    


IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet 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
IP IP Logged
alcutri
Newbie
Newbie


Joined: 29 Aug 2012
Location: Brazil
Online Status: Offline
Posts: 4
Quote alcutri Replybullet Posted: 29 Aug 2012 at 6:46am
 
   The parameter "Verify on First Refresh" is unchecked.
 
 
Thanks.
IP IP Logged
alcutri
Newbie
Newbie


Joined: 29 Aug 2012
Location: Brazil
Online Status: Offline
Posts: 4
Quote alcutri Replybullet Posted: 29 Aug 2012 at 6:47am
Originally posted by alcutri

 
   The parameter "Verify on First Refresh" is unchecked in the subreport.
  
 
Thanks.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet 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
IP IP Logged
alcutri
Newbie
Newbie


Joined: 29 Aug 2012
Location: Brazil
Online Status: Offline
Posts: 4
Quote alcutri Replybullet 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.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.