Create one report for Multiple uses

[CD Tom]

Ok, let's see if I can explain this.
I have a report that can have up to 12 headings, in some cases I wish only to use 6 of the 12 headings.
I could create a additional report for just the 6 headings them I would need to create a report for when I use 7 headings and on up to the max of 12.
I'm wondering if there is a way to use a single report for all the different reports.
I've used the report format to set those columns I don't want to visible = false and that seems to work I have to also move columns around so there isn't a large space left if I eliminate say headings 7 - 12 as there is a total column at the end.
Just wondering is there is a better way.

Just thoughts would be helpful.
Thanks

[NeoPa]

TBF Tom, that sounds exactly what I would have recommended. Remember, what you're talking about isn't a common or simple idea particularly. Some code to take a number of columns and, from that, set up the .Width, .Left & .Visible properties for each column would make good sense.

[PhilOfWalton]

If you really get stuck, I use a pretty complex routine which changes the captions and visibility of labels on forms and reports.

I don't intend to go into too much detail as it is too complex to be dealt with on this website, but the basis is a table that holds the names of the forms and reports to be "messed around with" the relevant control names, the control's visibility and alternative captions.

It does not re-position the controls, but that is just a couple of extra field in the table.

At the moment, the reports are "redesigned" depending on the company using them.

You don't explain what affects which headings you want to change.

Phil

[CD Tom]

Thanks for the reply, I pretty much am doing just what you say, but was hoping there might be an easier way.

Thanks again.

[NeoPa]

@Tom.
You must know by now that adding new questions to an existing thread is neither allowed nor a good idea. I've moved your new question to a new thread (Extra Page in Report).

[CD Tom]

Thank you will try and remember that.

[NeoPa]

: - )