Are reports static?

[Buakaw]

I'm new to reports. I created a report from a query, and formatted it nicely. I expected then when something changed and the query produced a different result, the report would also update and a new column would appear, but this didn't happen.

Can I know how I can make reports dynamic? Is this even possible? Thanks.

[ajetrumpet]

reports are nothing but forms. the same concept. hence, it shows data through the controls you initially created on it. was a report is created, it's bound source does not play a role in adding or deleting controls out of the report. that only happens once, when the report object is created the first time.

[Buakaw]

Thanks, got it.

Next time I generate another report from a query, do I have to redo the formatting every single time? Or is there a way to save the formatting that I've already done and just quickly apply it?

THanks.

[ajetrumpet]

formatting does not change when closing a report.