如何在Crystal Report中创建列？及按次图样式打印展示首图日期？

Hey there! Let's break down your two Crystal Reports questions with clear, actionable steps:

Creating columns in Crystal Reports is straightforward—whether you're using existing database fields or building custom calculated columns:

• Adding a database-bound column

  1. Open your report in the Crystal Reports Designer.
  2. Locate the Field Explorer panel (if it's hidden, go to View > Field Explorer).
  3. Expand the Database Fields folder, find the specific field you want to turn into a column.
  4. Drag the field directly into the Details section (or Header/Footer sections, depending on your report layout). Crystal Reports will auto-generate a column with the field's name and data.

• Creating a custom calculated column

  1. In the Field Explorer, right-click Formula Fields and select New.
  2. Name your formula (e.g., TaxCalculatedTotal) and click OK to open the Formula Editor.
  3. Write your calculation logic—for example:

     {Orders.SubTotal} * 1.08  // Calculates 8% tax on subtotal
     

  4. Save the formula, then drag it from Field Explorer into your report layout to add the custom column.

• Tweaking column appearance
  Select the column, right-click it, and choose Format Field to adjust width, alignment, font style, or border settings to match your report's design.

To reformat the date from your first image to match the second image's style, use one of these two methods:

• Direct field formatting (quickest option)

  1. Select the date field in your report.
  2. Right-click and choose Format Field to open the Format Editor.
  3. Switch to the Date and Time tab.
  4. Pick a pre-built style from the list that matches your target image, or click Customize to define a custom format string (e.g., dd-MMM-yyyy for 05-Jan-2024, or yyyy年MM月dd日 for Chinese-style dates).
  5. Click OK to apply the new format.

• Using a formula for flexible formatting
  If the pre-built styles don't fit your exact needs, use a formula field:

  1. Create a new Formula Field (as outlined in the first question).
  2. Use the ToText function to define your date format. For example:

     ToText({Orders.OrderDate}, "dd-MMM-yyyy")
     

     Adjust the format string to match the style shown in your second image.
  3. Save the formula, then replace your original date field with this new formula field in the report layout.

内容的提问来源于stack exchange，提问作者Developer12