Fill the balnk Detail Section records with a value in Crystal Reports X1

Hello,

I'm using Crystal reports X1. I have group by "Ticket Number". In the detail section of the ticket number I have a field that stores a date called "SevDate"

This is how it looks like
Ticket Number SevDate
IM44-023502
IM44-023502 03/20/2010
IM44-023502
IM44-023502
IM44-023502 03/21/2010
IM44-023502

What I'm trying to do is get this date repeated or filled in the next detail section of the Ticket Number.
so, basically I'm trying to see the report like the one shown below and this should be in a date format so I can do some other calculation

Ticket Number SevDate
IM44-023502
IM44-023502 03/20/2010
IM44-023502 03/20/2010
IM44-023502 03/20/2010
IM44-023502 03/21/2010
IM44-023502 03/21/2010

Any help is greatly appreciated. Thank you
angel7170Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

peter57rCommented:
Don't have data to test this but this is what i think you need as a formula field.

whileprintingrecords;
datevar prevdate;
if onfirstrecord or {tablename.ticketnumber}<>previous({tablename.ticketnumber})then
(prevdate :={tablename.sevdate};
{tablename.sevdate}
)
else if isnull({tablename.sevdate}) then
prevdate
else
(prevdate :={tablename.sevdate};
{tablename.sevdate}
)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
angel7170Author Commented:
Perfect.  This is exactly what I needed...

Thank you so much
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.