ID field looks ok in preview, displays all 1s in the report

[Anonymous]

In one of my SQL Server Data Sources, I have a field called Benefit Plan ID. In the data preview, this field comes out correctly. But in the report, all the values are displayed as 1. Any troublehshooting suggestions

[stretcharm · Accepted solution]

Is it aggregating with a count?

Change the default summarization to Don't Summarize.

If your using a table then you can also change the aggreation using the column properites menu.