BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

Crystal Reports not returning same amount of entries as SQL


 
Search this topic... | Search Legacy Crystal Products... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Legacy Crystal Products  Previous TopicPrint TopicNext Topic
Author Message
marilynginger
Forum Member
Forum Member



Joined: 27 Feb 2019

Posts: 1



PostPosted: Wed Feb 27, 2019 12:45 pm 
Post subject: Crystal Reports not returning same amount of entries as SQL

I have a Crystal report that has a command object (SQL). When I run the SQL in the command object in SQL Server it returns more entries than when I run the same code in Crystal 16.

I tried to select just 1 certain entry in Crystal, it does not pull anything. SQL does pull that 1 record.

I am lost as to why? I would appreciate any help on this.
Back to top
kevlray
Forum Associate
Forum Associate



Joined: 23 Jun 2010

Posts: 974
Location: California


flag
PostPosted: Wed Feb 27, 2019 1:53 pm 
Post subject: Re: Crystal Reports not returning same amount of entries as

I have never seen this behavior unless the datasource on Crystal Reports was pointing to a different database than on SQL Server.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Legacy Crystal Products  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0269 seconds using 18 queries. (SQL 0.0031 Parse 0.0008 Other 0.0230)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo