Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: null headings on crosstab reports Post Reply Post New Topic
Author Message
bizu
Newbie
Newbie
Avatar

Joined: 14 Mar 2007
Location: United Kingdom
Online Status: Offline
Posts: 1
Quote bizu Replybullet Topic: null headings on crosstab reports
    Posted: 14 Mar 2007 at 10:26am

i'm new to crystal reports, only got crystal 12 yesterday and have found it very simple to create crosstab reports, but i can't seem to get my unanswered columns to display anything other than null in the heading ie

 
                        |                      | Single    |   Married    |
 -------------------------------------------------------------------
 <20                 |     10             |    5         |     32         |
 
i want it to read:
 
 
                        | Unanswered  | Single   |      Married  |
 --------------------------------------------------------------------
 <20                 |     10              |    5       |        32        |
 
 
i know that using SQL i could use isnull but i need a way using the tools
 
Many thanks in advance for your help.
sorry if its not very clear.
 
Regards
Ross
IP IP Logged
satcire
Newbie
Newbie
Avatar

Joined: 07 Mar 2007
Location: Canada
Online Status: Offline
Posts: 6
Quote satcire Replybullet Posted: 15 Mar 2007 at 4:55am
Hi,
 
You have the fonction IsNull (fld), where fld is the field that you want to test.  I hope that will hepl.  If not, give us more detail.
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 15 Mar 2007 at 11:17am
If you look in my free online chapter about crosstabs, I talk about manipulating the cross-tab object during runtime and examining its properties. Look in the last half of the chapter for more info.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
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.015 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.