422,757 Members | 1,365 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 422,757 IT Pros & Developers. It's quick & easy.

Create one report for Multiple uses

P: 416
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.
Sep 10 '17 #1
Share this Question
Share on Google+
6 Replies

Expert Mod 15k+
P: 30,741
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.
Sep 10 '17 #2

Expert 100+
P: 1,116
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.

Sep 10 '17 #3

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

Thanks again.
Sep 10 '17 #4

Expert Mod 15k+
P: 30,741
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).
Sep 19 '17 #5

P: 416
Thank you will try and remember that.
Sep 20 '17 #6

Expert Mod 15k+
P: 30,741
: - )
Sep 20 '17 #7

Post your reply

Sign in to post your reply or Sign up for a free account.