Print Page | Close Window

How to display two dates on the same row?

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2016
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22693
Printed Date: 17 Sep 2019 at 1:02pm


Topic: How to display two dates on the same row?
Posted By: BadBoyHouse
Subject: How to display two dates on the same row?
Date Posted: 02 Nov 2018 at 12:28am
I have a report which picks out two target dates from an SQL database.

The dates belong to a Stage table whereby the first date has a Sage Type ID of 2 and the second date has a Stage Type ID of 13 - the Stage Type ID is the key field for the table.

I would like to display the two dates on the same line, rather than one underneath the other.

Can this be done in Crystal Reports? I have included two screenshots which show the current report layout.

Thanks

https://ibb.co/gJgqiL">

https://ibb.co/czV5Hf">



Replies:
Posted By: DBlank
Date Posted: 05 Nov 2018 at 2:26am
if it is just a display issue and you always only have two records for a group you can use a min(date,group) and a max(date,group) summary field to display in the detail section and suppress the field as needed



Print Page | Close Window