Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 936
  • Last Modified:

Formula field to concatenate data in Crystal Report?

Hi, I'm making a crystal report and I have two data fields, "Plan Number" which is something like "001-223" and "Plan Revision" which is something like 1 or 2.  I'd like to create a single text item on my page header (there is only one record supplied to my report) that is formatted something like

"Project Plan No. 001-223, Rev. 2"

is there a way to do this?  What element do I use?  A text box doesn't seem to support this, and a formula field doesn't seem to work either.  

Thanks in advance.
0
riceman0
Asked:
riceman0
1 Solution
 
peter57rCommented:
A formula field should be OK.


Whileprintingrecords;
"Project Plan No. " & {table.Plan Number} & ", Rev. " & {table.Plan Revision}
0
 
mlmccCommented:
Looks good.

You may also be able to do this with a simple text box
Create a text box with "Project Plan No. " as the text
Drag the {table.Plan Number} field into the text box
Click the text box so you can edit the contents (may take a click to select and another to enter edit mode)
Add ", Rev. "
Drag the {table.Plan Revision} field into the text box.

mlmcc
0
 
riceman0Author Commented:

Oh, was using the wizard and didn't see the database fields  Great, thanks!
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now