Disappearing fields in CR 8.5

[DanWalter]

Hello all:
I am running CR 8.5. I have designed maybe a dozen reports, all of which access some common tables. The common tables structures change pretty frequently (a consequence of being in "development" mode), but as long as I verify the database before viewing the report, no problem. I have one report that was completed a month ago. When I opened it yesterday and verified the database, all of a sudden some fields would not display! Using the Browse fields function shows that the data are in the table, they just won't show up on the report. The field and section are not suppressed, and there is no unusual formatting on the field. The structure of the fields in question has not changed. Resizing the fields has no effect. Any ideas much appreciated!
TIA,
Dan Dan Walter
DWalter@zoo.uvm.edu

 

[rnc110]

Dan,
You might have a join problem with your table.

For example:
Is the data that disappered have any records associated with it on the other table. For example you might have an employee table and then a Department table. If the employee table has a Dept number field that links it to the Department table and that field is not populated then it will leave that employee out of the report. If it is a equal join. TO correct it to show all of the employes even if their Dept isn't related to the table make it an outer join.
So goto visual linking expert and change you join to an outer join. It depends left or right depending on how the tables are linked. Try both it will not screw up the report if you change the joins.

Ryan

 

[DanWalter]

The tables are not joined at all. There is only one single record table on the report, and the others are each in their own subreports. The information in each table is not, and cannot, be linked to other tables as the information is unique and not logically related to anything else.

Removing then adding the tables to the report was not effective in this case, as it sometimes has in the past.

Dan Dan Walter
DWalter@zoo.uvm.edu