Constant Contact Customers: Join our partnership program to save 20-30%. Sign up on our Constant Contact Partnership Portal.

Not a Constant Contact customer? Try it for free. When your trial ends, you'll automatically be enrolled in our partnership program to continue saving.

Page tree


 

Does Report Designer have a tutorial and if so, how do I install it?


Yes, there is a tutorial guide for Report Designer. While the tutorial is an older version, working through the lessons in it will help you learn how to do basic functions in Report Designer. For more information about the tutorial, including how to install it, see Report Designer Learning Resources.

Return to top

 

 

 

Can I import a Report Writer report into Report Designer?


No, the Report Writer file format is not compatible with the Report Designer file format.

Return to top

 

What is a sub-report and when will I need to use it?


A sub-report handles multiple master details. For example, you can use sub-reports to obtain all of an individual’s e-mail addresses, alternate phone numbers, or activities.

Return to top



How do I include individual or family pictures in a report?


You can include individual or family pictures on a report by adding a RDDBImage component, then selecting the picture type.

 To include a picture on a report
  1. On the Report Designer menu, select the report that you want.
  2. In the lower left pane, click Customize.
  3. Create your data source and set your report options.
  4. Click Design Report, choose how many records to use to test, and click OK.
  5. On the Design tab, select RDDBImage, and then place the field in the location that you want in the Detail band.
  6. From the Data Field drop-down list, select the picture type that you want to include.
  7. Right-click the picture field, then select MaintainAspectRatio.
  8. Right-click the picture field then select Stretch.

Return to top



Can I format a report for more than one column?


Yes, you can have more than one column on a Report Designer report.

 To set up a report for more than one column
  1. On the Report Designer menu, select the report that you want.
  2. Click Customize and select your Data Source and Report Options.
  3. Click Design Report>OK.
  4. Click File > Page Setup.
  5. Select the Columns tab.
  6. Enter the number of Columns that you want, or click the up arrow for the Columns field to increase the number of columns.
  7. Select any additional options that you want on the Columns tab.
  8. Click OK.

Return to top



Can I import an external data file into Report Designer to create a report?


No, you can only use data sources created through Advanced Export or the Create a Data Source option in Report Designer.

Return to top

 

How do I put an individual's first and last name together without getting unnecessary spaces?


 To eliminate unnecessary space between an individual's first and last name
  1. On the Report Designer menu, select the report that you want.
  2. Click Customize, and create your Data Source and set your Report Options.
  3. Click Design Report, and then click OK.
  4. On the Design tab, select Variable, and then place the field in the location that you want in the Detail band.
  5. Right-click the Variable component and then select Calculations.
  6. In the Code Toolbox: Data section of the Calculations window, select People.
  7. On the Data tab, click the FirstName field and drag it in the left area of the Calculations window.
  8. Type a plus sign (plus), a single quote ('), a blank space ( ), a single quote ('), and a plus sign (+).
  9. On the Data tab, click the LastName field and drag it in the left area of the Calculations window.
  10. Type a semicolon (;).
  11. Right-click in the left area of the Calculations window and select Compile. A message displays at the bottom of the window indicating any errors in the calculation. Click OK to return to the Design workspace.
  12. Optional: Click the Preview tab to check your calculation.

 

Return to top



How do I suppress blank lines with no data?


You can suppress blank lines with no data, such as Address Line 2, using the ShiftRelativeTo option for a DBMemo component. The ShiftRelativeTo option associates components so that one component prints directly after another. For detailed instructions, see Suppressing a Blank Line.

Return to top

 

Can I group the report I design, and if so, how?


Yes, you can create groups for reports in Report Designer. When groups are created, they are assigned to a field. As the report generates, the group tracks the value of the assigned field. If the field value changes when the report moves from one row of the database table to the next, then the current group ends (the group footer prints) and the next group begins (the group header prints). Group headers always print at the beginning of a report (in order to start the first group) and group footers always print at the end of the report (in order to finish the last group). For more information, see Report Designer Groups.

 To create a group
  1. On the Report Designer menu, select the report.
  2. Click Customize and create your Data Source and set your Report Options.
  3. Click Design Report, and then click OK.
  4. On the Design tab, click Report, then select Groups. The Groups window displays.
  5. In the Groups drop-down list, select the field you want to use. Make sure to select a field you are using to sort your data.
  6. Click Add.
  7. In the Break On section, select Data Field.
  8. Optional: To start a new page each time the group value changes, in the On Group Change section, select Start new page. Select Reset page number if you want the page numbering to start over each time the group value changes.
  9. To reprint the header information on each page for the group, select Reprint group headers on subsequent pages.
  10. Click OK.

Return to top

 



Related Topics