AGING REPORT IN CRYSTAL REPORT

[IT_ANGEL]

its possible to connect this Aging PLD report to Crystal report
i cant find the table im gonno use as ENTER PARAMETERS to connect to Database it said Field Unknowed

[william_vonzangenberg · Accepted solution]

To connect your Aging PLD report to Crystal Reports, you'll need to identify the correct table and fields to use as parameters. Since you're getting a "Field Unknown" error, let's troubleshoot together:

# Step 1: Verify the Database Connection
Ensure that your Crystal Reports is connected to the correct database and schema.

# Step 2: Identify the Correct Table
Check your database schema to find the table that stores the Aging PLD data. Common table names might include:

- `Aging_PLD`
- `PLD_Aging`
- `Accounts_Payable_Aging`
- `Aging_Report`

Verify the table name and its fields.

# Step 3: Map Fields to Parameters
In Crystal Reports, go to the "Database Expert" and select the table you identified. Then:

1. Click on the "Parameters" tab.
2. Create a new parameter by clicking the "New" button.
3. Select the field from the table that corresponds to the parameter you want to use (e.g., `Date`, `Customer_ID`, etc.).
4. Map the field to the parameter.

Repeat this process for each parameter you need.

# Step 4: Update the Report
After creating the parameters, update your report to use these parameters. You can do this by:

1. Going to the "Report" menu.
2. Selecting "Report Options".
3. Checking the "Use Parameters" box.

Save and refresh your report.

# Troubleshooting Tips
If you're still encountering issues:

- Verify that the table and fields exist in the database.
- Check the database connection and schema.
- Ensure that the parameter fields are correctly mapped.
- Try using a different table or field to see if the issue persists.

If none of these steps resolve the issue, please provide more details about your report, database, and error message, and I'll do my best to assist you further.