Topic: Multiple views based on a single query Posted: 14 Oct 2016 at 4:33am
Hi,
I've created a query and I want to display its data in three different tables.
One table contains details, the other tables show more aggregated
results. The data of all three different views / tables should come from
the same query. I don't want to use cross tabs, I want to use basic
functionality such as Group Headers etc.
The question is: how do you do this? I've considered creating a
subreport yet this forces me to create the same query again and this
shouldn't be necessary since the query already contains all the required
data. There must be an easier way..
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 14 Oct 2016 at 8:20am
Why are you excluding the most obvious answer of the cross-tab?
IMO Where you are heading with your limitations is 3 sub reports or one report run 3 times with run time parameters that define an the way the report will be organized.
Why not a crosstab?
Why not use drill down with the report defaulting to details hidden?
If we understand your objections to these it may help to understand your larger goal.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
