Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: is this possible? if yes how Post Reply Post New Topic
Author Message
bryonwoods
Newbie
Newbie


Joined: 15 Feb 2011
Online Status: Offline
Posts: 16
Quote bryonwoods Replybullet Topic: is this possible? if yes how
     Posted: 21 Feb 2011 at 10:44am
recieved an access database layed out this way
 
store id      question1     question2   question3
1                      5                    3              5
1                      4                    2              4
1                      3                    3              2
1                      4                    4              3
2                      3                    5              4
2                      2                    4              4
2                      1                    3              4
3                      3                    2              3
3                      4                    1              2
3                      5                    2              5
3                      4                    3              5
 
I have to make a 3 crosstabs, 1 for each question. I am wondering is it possible to make a one page report with the 3 crosstabs and have it group on store id so when i export it automatically does all the store ids in the group database? The database has 500 ids in it,the results to the questions have to be grouped by store id for % results.  So with 500 stores I really don't want to have to manually go through each store and export that report. I'd like for it to just auto export 500 pages, 1 for each store.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 28 Feb 2011 at 5:01am
if you group on storeid and place the crosstab on the group header or group footer it will only include records for each storeid per footer/header.

Edited by DBlank - 28 Feb 2011 at 5:01am
IP IP Logged
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