Dynamic report fields

[danchalk]

Hi,
I have done some searching and while there appears to be similar questions none quite get at what I am after.

I have a query which is created using a form that a user selects the criteria they need e.g., select a year and a couple of countries, which then creates a report that shows average, standard deviation, median etc. This is working fine, but what I need now is the ability for a user to select only particular fields to report on i.e., select a year, some countries and average and the report will only show the averages.

I could create multiple reports and have VBA select which report to open however that would mean creating about 35 reports for all the different combinations.

Is there a simpler way to achieve this? I cannot for the life of me work out a solution which works.

Dan

 

[spikepl]

http://allenbrowne.com/ser-62.html

 

[danchalk]

Thanks for the link. I am not sure (and correct me if I am wrong) that this fully achieves what I am after. I already have a form which creates a where statement based on user input and they can click a button which then populates a report with the data they require based on that filter. What I need is the ability to also only report on particular items within that table/query.

So using your link as an example, allow users to fiter out data based on dates, city etc. but then also allow them to select the report to only show ID and company name or Company Name and City or a combination of any of those fields.

Basically I have a heap of summary data which includes average, standard deviation, percentile and so on which users will not always want so they would like the ability to just report on what they need at that time. Is that possible?

Thanks

 

[spikepl]

It's not clear to me what you want.

You have a query which delivers the data you wish based on selections in the form. Now you wish to show only a subset of this data, as in a lesser number of columns than in the original data? That would then be a new query run on top of the old one.

Or is it that you want to hide some columns in the existing report, so everything preserves its place, but some columns just are not displayed? Otehrwise, if you want a dynamic rearrangement of the information in the report, that could be a bit tricky.

I am not sure what you want, but there is also the possibility of usign subreports. If you report has some common information always displayed, that could be in the report, whereas changing data could be in a subreport.

 

[stopher]

Welcome to the forum.

Here's an example of a dynamic report (attached). Just open the form to see the options to run the report.

At the moment it allows the user to choose up to three fields but you can easily tailor it for more.

hth
Chris

 

[spikepl]

#5 Brings missinglinq's motto to mind

 

[stopher]

#5 Brings missinglinq's motto to mind

Yes, as your post #4 eludes, there could be a myriad options here. Depends what the OP is after.