Crystal Reports Tutorial
Selected Reading
- Crystal Reports - Discussion
- Crystal Reports - Useful Resources
- Crystal Reports - Quick Guide
- Crystal Reports - Data Export to CSV
- Crystal Reports - Data Export to HTML
- Crystal Reports - Data Export to XML
- Crystal Reports - Data Export to Excel
- Crystal Reports - Data Export Overview
- Crystal Subreports - Overview
- Crystal Reports - Edit Parameter Field
- Crystal Reports - Create Parameter Field
- Crystal Reports - Cascading Prompts
- Crystal Reports - Prompt Panels
- Crystal Reports - Filters
- Crystal Reports - Parameters
- Crystal Reports - Creating Arrays
- Crystal Reports - Creating Variables
- Crystal Reports - Conditional Formatting
- Crystal Reports - Applying Calculations
- Crystal Reports - If-Then-Else
- Crystal Reports - Apply Boolean Formulas
- Creating & Modifying Formulas
- Crystal Reports - Formula Workshop
- Crystal Reports - Defining Formulas
- Crystal Reports - Cross Tab Layout
- Crystal Reports - Charts
- Crystal Reports - Inserting Objects
- Crystal Reports - Templates
- Crystal Reports - Group Options
- Crystal Reports - Groups
- Crystal Reports - Delete Sections
- Crystal Reports - Sections
- Field Objects Controls & Modifications
- Crystal Reports - Time Based Filters
- Query Filters & Filter Conditions
- Crystal Reports - Queries
- Crystal Reports - Data Sources
- Crystal Reports - Design Environment
- Crystal Reports - Getting Help
- Crystal Reports - Page Layout
- Crystal Reports - Options
- Crystal Reports - GUI Navigation
- Crystal Reports - Overview
- Crystal Reports - Home
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
Crystal Reports - Edit Parameter Field
Crystal Reports - Edit Parameter Field
Once you drag the parameter to your report → To edit parameter filed, right cpck on parameter name and go to edit parameter.
Once you cpck on edit parameter, it will open Edit parameter window.
You can also edit the parameter by double cpcking on the parameter name.
Delete Parameter Field
Go to Data Explorer view → expand Parameters, and then right cpck on the parameter you want to delete.
Choose Delete.
Dynamic Parameters
You can create parameters using dynamic LOVs to retrieve data from data source. For example − When the customer name in database changes frequently, you can create dynamic LOVs.
How to create a Parameter using dynamic LOVs?
Open your report → Data Explorer panel → right cpck within Parameters and select New Parameter.
The Create Parameter dialog box appears.
Enter a name for the parameter (up to 255 alphanumeric characters) → To create a pst of values, cpck the “Edit List of Values” button.
The Edit List of Values dialog box appears → In the Type of List area, select Dynamic.
In the Value combo box, select Customer Name from the pst.
You can sort the LOV in Ascending or Descending order → Cpck OK.
In the Prompt Text object, enter the desired prompting text (up to 255 alphanumeric characters) → Text that appears in the prompting dialog and interactive panel. The default is “Enter (ParameterName)” → Cpck OK
Drag the Parameter into your report.
Advertisements