Date Ranges

[katididdy]

I am using Crystal XI, and would like to separate my dates into 2 columns. First column from the 1st of the month (parameter selection) to the 15th, then the second column from the 16th to the end of the month (parameter selection). Right now this is what my report looks like:

3/1/2007 26.40 3/1/2007 26.40
3/3/2007 31.20 3/3/2007 31.20

etc until end of the month. How can I create the 2 columns I mentioned? Thank you for any help you can give me.

 

[synapsevampire]

Showing us what isn't right doesn't help, show us what you want the output to be.

If you right click the details section you can select section expert->Format with multiplecolumns and probaly get what you want by adjusting the size.

-k

 

[katididdy]

I apologize for the delay in my response.

The way I want the output to be is:

3/1/07 26.40 3/16/07 14.86
3/2/07 24.50 3/17/07 27.23

The dates on the left should be from the 1st to the 15th of the date paremeter put in, and in the right column from the 16th to the end of the month. Next to the dates are the total net tons for that day.

I hope this helps you to help me!

 

[lbass]

Create a formula {@halfmo}:

if day({table.date}) in 1 to 15 then "First Half" else "Second Half"

Insert a group on this and make it your group #1. Then go to the section expert->details->format with multiple columns->layout tab->select the width and gap (play with this until it forces two columns--you might try something like 3" and .5 gap. Then check down then across and also "format group with multiple columns". Then still in the section expert, select the group footer for {@halfmo}->check "Print at bottom of page". This will force a new column after the first 15 records. You can also suppress the group header and group footer for this group.

-LB

 

[katididdy]

Thank you! That worked.