Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Multiple views based on a single query Post Reply Post New Topic
Author Message
Erik0067
Newbie
Newbie


Joined: 26 Aug 2016
Location: Netherlands
Online Status: Offline
Posts: 1
Quote Erik0067 Replybullet 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..

I'm using Crystal reports version 14.1.4.1327

TIA!
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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.

Edited by DBlank - 14 Oct 2016 at 8:21am
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.016 seconds.