Memo field displays wrong data

[dovmod]

Hi,

I am new to Crytsal Reports. I am using CR 10 and my datasource is always ODBC connection to 4D Server.

My problem is that one text or memo field will not display the correct information. The field is an address field and it seems to pick up one address and does not refresh as I move to other records.

The links are:

Reporting on the SalesTransactionHeader
Left Outer Join to SalesAccount
Left Outer Join to Company.

The address is in the Company table.

All other fields that I display from the Customer table display and refresh correctly.

 

[Madawc]

What fields are you using to link?

Have you checked that the company table has the right data? Maybe do a quick Crystal report to show it on its own.

Madawc Williams (East Anglia, UK)

 

[dovmod]

Thank you for your reply.

I am using the prime index fields on each table.

so [SalesTransactionHeader]SalesAccount links to [SalesAccount]ID.

[SalesAccount]Company links to [Company]ID.

They are all indexed in the database.

I have created a quick report in CR, using just the [Company] table as you suggested, but that shows all the addresses correctly.

As I said in my first post all other fields from the company table show correctly. Just on the Address field, it seems to pick up the first address it finds. There is always an address showing, but never the correct one.

BTW I am displaying the address in the group header based on [Company]Name. I have tried to group on [Company]ID but it makes no difference.

 

[lbass]

Your BTW comment holds the answer. If you are displaying a field in the group header, it will only show the first instance of a field in the group based on your sort. What criteria determine which address field you want displayed?

-LB

 

[synapsevampire]

I'd guess that you either don't understand the joins correctly, or you're experiencing row inflation.

You might consider reversing the tables/links so that you have The Company as the main table. the sales account as it's child using a left Outer, and then the transaction header using a left outer.

Had to say without exploring/knowing what's in the database.

-k

 

[dovmod]

Thanks everyone for your replies.

I changed the address field in the database to a string and it solved the problem. All the addresses now show correctly.

I just dont understand why a text field wont display but a string field will.