Print Page | Close Window

joining columns together

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=399
Printed Date: 03 May 2025 at 8:18pm


Topic: joining columns together
Posted By: toolman22
Subject: joining columns together
Date Posted: 25 Mar 2007 at 8:06am
First I would like to say thanks for letting me join this forum. I have very little experience with Crystal so forgive me if I am using the wrong descriptions. Its good to know there is a site like this to help out.
 
I use Cabinet Vision and need to change a report it generates. CV creates a .rpt that separates the whole number and fraction. I have been trying for several hours to figure out how to make the one number instead of being separate. I am sure this is easy to most but I am baffled.
 
Could someone take a few minutes to explain how to do this?
 
Thanks in advance for you help.


Replies:
Posted By: hilfy
Date Posted: 26 Mar 2007 at 2:36pm
Take a look at what's actually in the columns.  Is it a formula or is it a field?  Is the fraction a decimal or a real fraction?
 
If it's a decimal, you can just add the two columns together in a formula or you can follow the instructions below.
 
If it's a fraction, probably the easiest way to do this is to put a text box on the report where you want the combined column to appear.  Drag the numeric field/formula into the text box.  Then drag the fraction into the text box, making sure to place it after the number.  When dragging, you'll hover over the text box until it "activates" before dropping the field into it.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: toolman22
Date Posted: 26 Mar 2007 at 5:20pm
Thanks for your help.
 
It has a box that says whole number and a box that says fraction. Can I drag on over to the other or should I create a new box?

Posted By: toolman22
Date Posted: 26 Mar 2007 at 5:39pm
I inserted a text object and dragged the 2 columns into it and it worked. Thanks again for your help.
 
Gary


Print Page | Close Window