Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Report Needed Post Reply Post New Topic
Author Message
shefe
Groupie
Groupie


Joined: 09 Feb 2008
Online Status: Offline
Posts: 48
Quote shefe Replybullet Topic: Report Needed
     Posted: 02 Aug 2011 at 10:55am
does anyone know how to add dates to Detail b and detail c

Basically i want my report to look like this and the next date should show under detail b or section but this is not a date field name just a formula showing date


8/1/2011 
8/4/2011




IP IP Logged
sharona
Senior Member
Senior Member
Avatar

Joined: 16 Oct 2008
Location: United States
Online Status: Offline
Posts: 255
Quote sharona Replybullet Posted: 02 Aug 2011 at 11:47am
do you want to have your report grouped by date?
in the formula being uses is the date field most likely
sharona
IP IP Logged
shefe
Groupie
Groupie


Joined: 09 Feb 2008
Online Status: Offline
Posts: 48
Quote shefe Replybullet Posted: 04 Aug 2011 at 11:13am
the formula is Date (2011,08,12) and  i want  the  date to show as follow

8/12/2011 and then under the it 8/12/2011, i will show
8/19/2011

I need for student roster for the next 16 weeks




IP IP Logged
shefe
Groupie
Groupie


Joined: 09 Feb 2008
Online Status: Offline
Posts: 48
Quote shefe Replybullet Posted: 30 Aug 2011 at 9:52am
Anyone with a solution for me

IP IP Logged
CircleD
Senior Member
Senior Member
Avatar

Joined: 11 Mar 2011
Location: United States
Online Status: Offline
Posts: 251
Quote CircleD Replybullet Posted: 30 Aug 2011 at 12:25pm
I'm not real strong on formulas but this should do what you want.

CStr(MM,dd,yyyy)
IP IP Logged
shefe
Groupie
Groupie


Joined: 09 Feb 2008
Online Status: Offline
Posts: 48
Quote shefe Replybullet Posted: 08 Sep 2011 at 7:09am
Thank  you

Does anyone know how to make changes  to this formula classes starts Sept 15th 2011 and ends on Jan 27th 2012 but my formula displays Jan 5th 2011

If {@Day}="Thursday" then DateAdd("d", 112, {@Sept 15th 2011}) else
if {@Day}="Friday" then DateAdd("d", 112, {@Sept 16th 2011}) else
if {@Day}="Saturday" then DateAdd("d", 112, {@Sept 17th 2011}) else
if {@Day}="Monday" then DateAdd("d", 112, {@Sept 19th 2011}) else
if {@Day}="Tuesday" then DateAdd("d",112, {@Sept 20th 2011}) else
if {@Day}="Wednesday" then DateAdd("d", 112, {@Sept 21st 2011})

Someone help

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