Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Fields with blank data from SQL stored procedure

Status
Not open for further replies.
judyz

judyz

Technical User
Sep 30, 2003
3
US
I have a Crystal 8.5 report which is using a SQL stored procedure as its data source. A few records are showing some blank fields in the report.

If I run the procedure in SQL query analyzer, all the rows are returned, and there is data in all the fields I am interested in. The same rows are returned in Crystal, but with no data in a few fields of a handful of records. They are not memo fields, and most records are displaying the data properly.

Can anyone think of any reason for a discrepancy between the data returned in SQL vs in Crystal?
 
Status
Not open for further replies.

Similar threads

D
  • Locked
  • Question
Stored Procedure with no Parameters
Replies
1
Views
618
hilfy
hilfy
Kennymc
  • Locked
  • Question
Has anyone used Crystal reports with online Microsoft Dynamics 365
Replies
0
Views
165
Kennymc
Kennymc
David Richardson
  • Locked
  • Question
Adding BLOB Fields to Reports in Crystal Reports Professional 8.5
Replies
7
Views
938
hilfy
hilfy
JustMe24
  • Locked
  • Question
How to select from 2 rows in a table
Replies
1
Views
554
SoftwareRT
SoftwareRT
H
  • Locked
  • Question
Cannot get a sub-report to print without the headers and footers of the main report
Replies
1
Views
247
DjangMan
DjangMan

Part and Inventory Search

Sponsor

Back
Top