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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I have a 2 datasources for my repor

Status
Not open for further replies.
latwv

latwv

Programmer
Nov 19, 2001
16
US
I have a 2 datasources for my report. Both are SQL Server 2000 stored procedures. They link by one field called a systemid. The first stored procedure has normal field and the second one has 3 text fields and 3 other string fields. My problem is that my report shows the SystemID and the fields from the first stored procedure and the three string fields from the second stored procedure for each systemid, but the 3 text fields don't update. They stay the same as the info from the first systemid for all systemids. I check the stored procedures and they are returning the correct information. Does anyone know of a bug with crystal updating text fields on a report?

Thanks in advance
Lori
 
Status
Not open for further replies.

Similar threads

dgillz
  • Locked
  • Question
Outlook as a Datasource?
Replies
0
Views
433
dgillz
dgillz
Ivan Kok
  • Locked
  • Question
Crystal Reports Runtime causing AS/400 DB2 Database ID to be disabled intermittently
Replies
0
Views
456
Ivan Kok
Ivan Kok
Insulations504
  • Locked
  • Question
Crystal Reports duplicating invoices
Replies
1
Views
480
dgillz
dgillz
s_reddibathuni
  • Locked
  • Question
export multiline address field from crystal to excel
Replies
3
Views
562
hilfy
hilfy
semsel
  • Locked
  • Question
Checking if a value exists in an Array for conditional suppression
Replies
0
Views
548
semsel
semsel

Part and Inventory Search

Sponsor

Back
Top