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!
-
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!
-
CR returning 6 lines for every record in Details section
No, no other tables in the SELECT statement. -j- frogger55
- Post #9
- Forum: Business Objects: Crystal Reports 2 Data Access
-
CR returning 6 lines for every record in Details section
Connectivity was ODBC. Changed to OLE DB. Did not change the results. Verified the database. Received message, "The database is up to date." Reversed the direction of the join between Agent and Broker. Same results. There are several hundred records in my Broker table. I...- frogger55
- Post #7
- Forum: Business Objects: Crystal Reports 2 Data Access
-
CR returning 6 lines for every record in Details section
Hmmm. Linking appears to be the same. Agent.OfficeID equal join to Broker.OfficeID and Agent.AgentID equal join to Member.AgentID just 3 tables, just 2 links. I can re-create the report as a new report with the same linking and it works. But, I cannot get the old report to come up with...- frogger55
- Post #3
- Forum: Business Objects: Crystal Reports 2 Data Access
-
CR returning 6 lines for every record in Details section
Hi Everyone, I have several reports that I created in CR 8.0. I have just upgraded to CR 9.0. When I went to Refresh them in CR9, it now returns 6 times the amount of data. Each record is listed 6 times in the Details section, so my summaries in the footers are also off by 6x's the amount...- frogger55
- Thread
- Replies: 20
- Forum: Business Objects: Crystal Reports 2 Data Access
