How can CR XI not find a field value that I know is there?

[Former Member]

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.

Bill Ault

[abhilash_kumar · Accepted solution]

Hi Bill,

The 'Browse' option in the Field Explorer is not quite the right place to see if all the values are being returned in the report.

It only shows 500 values at a time (unique or non-unique) depending on what option you've set in the File > Options tab.

Drop the field on the details section instead and see if all the field values are there.

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash,

Ah ha!  That showed all the values like you said it would.  Thank You!

So CR does see the fields, it is just not being selected for the report & I don't know why.

The majority of cases are just fine - maybe 85% accurate.

My problem is that I don't know how to find out WHY they are not matching & printing out.