I am very new to CR. I have exported two SQL Server tables into Excel files and created two other EXCEL files for the data needed to create two reports.
On one report, fields are reported on that are not found when the other report is run, i.e. the first report finds almost all the records it should.
THe second report leaves various records out, like it can't find them.
SO, while in the second program while in the Field Explorer I BROWSE a field that is not being reported on & the field value is not in the list of values in the browse window.
Although, when I use Excel to look at the rows of data, the fields are there.
SO, without a trace capability, how can opne find out what is happening?
Any help would be appreciated.