Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: break date in Crystal Reports XI Post Reply Post New Topic
Author Message
fsilvabrasil
Groupie
Groupie
Avatar

Joined: 08 Jul 2013
Location: Brazil
Online Status: Offline
Posts: 42
Quote fsilvabrasil Replybullet Topic: break date in Crystal Reports XI
    Posted: 27 Jan 2014 at 1:47am
good day
 
hello I have a difficulty in the crystal which is quwe how do I break the date the crystal.

example

Data shows that in crystal form.

01/01/2014   05/01/2014    06/01/2014   01/02/2014    03/02/2014

I want a formula with the crystal it shows only on the date thus I need.

example

01                   05                  06                    01                 03
IP IP Logged
lolly54
Groupie
Groupie
Avatar

Joined: 25 Sep 2011
Online Status: Offline
Posts: 58
Quote lolly54 Replybullet Posted: 27 Jan 2014 at 3:41am
if you want to show the "day" only, you can right click on the field, and select [Format Field].
Then, go to the [Date] tab, click on [Customize].

You can then Format the Month, Day, Year.
Change Month and Year to None.
Change Day to 01.

You will then see the result you want. Smile



Edited by lolly54 - 27 Jan 2014 at 3:44am
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 27 Jan 2014 at 4:53am
you could also use a formula like:
day({table.field})
IP IP Logged
fsilvabrasil
Groupie
Groupie
Avatar

Joined: 08 Jul 2013
Location: Brazil
Online Status: Offline
Posts: 42
Quote fsilvabrasil Replybullet Posted: 27 Jan 2014 at 5:45am
okay

to appear horizontally in the header.
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 27 Jan 2014 at 5:48am
if this is being used in a cross tab, the formula will be fine...only caveat, if you span more than 1 month, it will start combining the same dates together.

IP IP Logged
fsilvabrasil
Groupie
Groupie
Avatar

Joined: 08 Jul 2013
Location: Brazil
Online Status: Offline
Posts: 42
Quote fsilvabrasil Replybullet Posted: 27 Jan 2014 at 5:54am
this is how I want apareçar in the report. is to show an example of the formula would be like.
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 27 Jan 2014 at 5:57am
hte formula example would be:
day({table.field})

this will display the day of the month as displayed in the date. If you wanted the month instead, it would be:
month({table.field})
IP IP Logged
fsilvabrasil
Groupie
Groupie
Avatar

Joined: 08 Jul 2013
Location: Brazil
Online Status: Offline
Posts: 42
Quote fsilvabrasil Replybullet Posted: 27 Jan 2014 at 6:02am
I've done this test you spent more only gets the first date in the report which also want to show other. in the header when you enter data in the period filter.

example that shows the crystal.

01/01/2014 05/01/2014 07/01/2014 30/01/2014 02/02/2014 04/02/2014

what I need is so

01                05                07               30                  02                  04
IP IP Logged
fsilvabrasil
Groupie
Groupie
Avatar

Joined: 08 Jul 2013
Location: Brazil
Online Status: Offline
Posts: 42
Quote fsilvabrasil Replybullet Posted: 28 Jan 2014 at 1:23am
Hello

dear friends someone to help with this problem. grateful for the help and tips that appear.
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.