If your records are properly formed (e.g. in rows and not columns) you will need to base your report on a crosstab query. The nature of a ct query is that the number of columns is based on some sort of grouping and a group can have a different count from one time to the next, hence the number of columns can change and the report will fail. To combat this, your query needs a static group. See this for example.
If that doesn't help it's because "I got stuck" tells us - not much.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.