Fields suddenly gone

[Former Member]

Post Author: hapax

CA Forum: General

I made a simple report that showed name, address, customer ID. That worked fine.

Then I added some more database tables and their fields, removed the fields in the header, and added a text box with some text. Now suddenly when I generate the report I only the see the textbox text and the print date. The other fields aren't showing any data.

Any suggestions?

[Former Member]

Post Author: jgh1204

CA Forum: General

I am going to guess that when you added the additional tables is when you lost your data. You may have to change the join methods. You can get some weird results when you are joining tables with multiple records for the linked keys.

If possible, try disconnecting the links completely and see if you get your data back.

[Former Member]

Post Author: jaykav99

CA Forum: General

I have a feeling there are numerous reasons for your problem. But Id make sure when you deleted the header fields, that is all you deleted. You can also check one by one the new data youve added, I have come into some reports when adding another field, the report just doenst like it and i will get no results.