Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Across and then down layout Post Reply Post New Topic
Author Message
joshdanhall
Newbie
Newbie


Joined: 21 Dec 2011
Location: Australia
Online Status: Offline
Posts: 4
Quote joshdanhall Replybullet Topic: Across and then down layout
    Posted: 21 Dec 2011 at 11:13pm
Hi there,

The requirement I have is to display the result set across the page, rather than down the page. I have figured out a major part of this is using the 'Across and then down' layout. To illustrate, I'm getting the flow I want, Eg. :-


John Naomi Peter
M    F     M
1980 1990 1970
Red Black Blonde

Aaron Betty Charles
M     F     M
1980 1990 1970
Red   Black Blonde


However, what I can't figure out is how to add Field labels to just the beginning of each row. Eg :-


Name: John Naomi Peter
Sex: M    F     M
DOB: 1980 1990 1970
Hair: Red Black Blonde

Name: Aaron Betty Charles
Sex: M     F     M
DOB: 1980 1990 1970
Hair: Red   Black Blonde


I'm using Crystal Reports XI. Anybody have a solution for this?

Many thanks,
Josh.
IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet Posted: 22 Dec 2011 at 11:32am
you could try to use crosstab


IP IP Logged
joshdanhall
Newbie
Newbie


Joined: 21 Dec 2011
Location: Australia
Online Status: Offline
Posts: 4
Quote joshdanhall Replybullet Posted: 22 Dec 2011 at 1:46pm
Thanks for your reply. I had a try, but that seems to be geared towards cross referencing multiple dimensions in the dataset. In my case, it's just a straight single repeating group, so I could not get it to behave how I'd like it to using a Cross-Tab.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 22 Dec 2011 at 3:21pm
I have not tested the idea out but what comes to mind would be conditionally suppressed text boxes. You will know how many records are set to display on a row based on your width design. You could insert a running total and come up with an algorithm using mod or remainderagainst that running total to determine when to suppress the text. E.g show text every 5th row.

Edited by DBlank - 22 Dec 2011 at 3:23pm
IP IP Logged
joshdanhall
Newbie
Newbie


Joined: 21 Dec 2011
Location: Australia
Online Status: Offline
Posts: 4
Quote joshdanhall Replybullet Posted: 23 Dec 2011 at 11:35am
It's a nice suggestion, however the side effect would be that I would end up with gaps between each dataset item where the text boxes were suppressed.
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 28 Dec 2011 at 10:11am
how about a silly idea,
layout the page for a basic column style report, then rotate the labels so that when everything prints, it would print in such a way that everything lines up the way you desire...the labels at the end would just be the normal headers, but rotated.
 
The biggest problem is things like page headers and footers as they would run the 'wrong' way.
 
It is a different approach, and not guaranteed to work.
 
just thinking crazy thoughts
IP IP Logged
joshdanhall
Newbie
Newbie


Joined: 21 Dec 2011
Location: Australia
Online Status: Offline
Posts: 4
Quote joshdanhall Replybullet Posted: 28 Dec 2011 at 11:08am
I like the lateral thinking, but it might be a bit crazy as you suggested. The deal breaker is the headers.

Thanks for all the suggestions. For now, I've convinced the BA to redesign the layout to a more traditional downward flowing report.

Cheers.
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 29 Dec 2011 at 3:16am
yeah, it's not crazy, it's just different...the twist can lead to a fresh looking report where the title is on the left.
 
if it weren't for titles it would look fine...but it would definitely not be 'traditional'
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.