Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Grouping options for a number or a date Post Reply Post New Topic
Author Message
karenb
Newbie
Newbie


Joined: 03 Oct 2007
Location: Australia
Online Status: Offline
Posts: 10
Quote karenb Replybullet Topic: Grouping options for a number or a date
    Posted: 09 Aug 2016 at 7:59pm
Hi there

I want to set up option parameters for the user to choose if they want to group a list of records by either:

Record Identifier (an ordinary string field)
or
Start Date (a TimeDate field)

When I try to enter a formula for Grouping, it does not like the parts that contain the TimeDate field.

Can anyone suggest how I can present this field so that I can use it for a grouping option?

thanks
Karen
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 10 Aug 2016 at 4:02am
I am assuming that you are using a IF statement.  If so, then remember that the results of the IF statement have to be the same data type.

If conditiion then string else string, not if condition then string else date.
IP IP Logged
karenb
Newbie
Newbie


Joined: 03 Oct 2007
Location: Australia
Online Status: Offline
Posts: 10
Quote karenb Replybullet Posted: 10 Aug 2016 at 1:07pm
OK thanks kevlray,

In that case I'll leave the existing group structure in place and just apply a recording sorting parameter.. see if that works!

cheers
Karen
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 11 Aug 2016 at 4:19am
Of course you can always convert one of the values (i.e, date -> string).
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.031 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.