Blog • DataDriven Reporting: Automate Personalized Crystal Reports

Smart Report Organizer Blog

What if one Crystal Report could automatically generate personalized reports for every customer, department, or recipient?

With DataDriven, Smart Report Organizer takes Crystal Reports automation a step further. Instead of configuring a separate report job for every customer or business unit, you can use the results of a database query to drive multiple report executions from a single ReportJob.

From One ReportJob to Many Personalized Reports

A traditional ReportJob runs a Crystal Report using its configured parameters and delivery settings. DataDriven adds a powerful step before that execution: Smart Report Organizer runs a user-defined database query and processes the returned records one by one.

Imagine a query that returns 100 customer invoices. DataDriven can use those 100 rows to execute the same ReportJob 100 times, applying the values from each row to the corresponding report execution.

  1. The existing schedule triggers the ReportJob.
  2. Smart Report Organizer executes the configured DataDriven query.
  3. The query returns the records to process.
  4. Each record supplies values for an individual report execution.
  5. The existing ReportJob handles report generation, exporting, and distribution.

The important difference is that you configure the reporting workflow once, while the data determines how many personalized executions are needed.

Use Your Own Database Query

A DataDriven definition connects to a database and runs a query that returns the information needed for your reporting workflow. For example, a result might include a customer ID, invoice number, language, and email address.

There is no need to rename database columns to special Smart Report Organizer field names. You can reference the returned fields directly in the ReportJob using expressions such as {{ID}}, {{Email}}, or {{InvoiceNumber}}.

Personalize Parameters, File Names, and Emails

DataDriven expressions can be used in multiple parts of the ReportJob configuration. A Crystal Report parameter can receive the current customer's ID, while an export file name can include that customer's invoice number.

  • Report parameter: {{ID}}
  • Export file name: Invoice_{{InvoiceNumber}}
  • Email recipient: {{Email}}
  • Email subject: Invoice {{InvoiceNumber}}
  • Email message: Include customer-specific information directly in the body.

Expressions can also be combined with regular text. For example, Invoice {{InvoiceNumber}} - {{CustomerName}} produces a meaningful, personalized value for each record.

Preview the Results Before Running the Job

When configuring DataDriven, it is useful to see both the expression you entered and the value it produces. Smart Report Organizer provides a preview based on the selected query record, so you can inspect how report parameters, export settings, and email fields will resolve.

For HTML email messages, a rendered preview makes it easier to review the personalized content rather than reading only the HTML source.

Keep Your Existing Scheduling Workflow

DataDriven does not replace the Smart Report Organizer scheduler. Your job still runs according to its configured schedule. Once triggered, DataDriven retrieves the records and the normal ReportJob execution logic processes them individually.

This keeps the workflow familiar: you continue to configure the report, schedule, export destinations, and email delivery in Smart Report Organizer, while DataDriven supplies the values for each execution.

When Is DataDriven Useful?

  • Sending individual invoices or statements to customers
  • Creating department-specific or branch-specific reports
  • Distributing personalized sales or performance summaries
  • Generating reports for a changing list of recipients
  • Reducing the number of nearly identical ReportJobs you need to maintain

Smarter Crystal Reports Automation

DataDriven turns a single configured ReportJob into a flexible, data-driven reporting workflow. Instead of manually maintaining many similar jobs, you can let your database query determine which reports are generated and where they are delivered.

Learn more about the feature on our DataDriven page, or explore the Smart Report Organizer video tutorials.

Your Smart Report Organizer Team

Share Post: