How To Add Parameter In Crystal Report

Creating and Using Parameter Fields in Crystal Reports

Business concern Objects, Crystal Reports

When setting upward layouts in Crystal Reports, the parameter field tin can be a tremendously helpful feature. Every bit with a parameter query in Microsoft Admission, information technology gives the study a significant degree of flexibility. The report'due south basic construction and purpose are the aforementioned, just the ability to change, say, the range of dates, ways a unmarried study tin can answer a larger number of related questions with reasonable efficiency. Since the user can input anything the field allows, parameter fields simply need to handle the necessary data type.

Once you lot have a file open, yous commencement past going to the Field Explorer, correct-clicking the Parameter Fields detail, and clicking New.

The dialog box which opens will ask for the name, type (of data), and whether the field should be dynamic or static—significant whether information technology should become choices from the database, or from a dissever list you load in.

The critical thing is, if yous want to hook the blazon to a value from somewhere, regardless, the type of the field and the type of the value accept to exist the same—number to number, cord (text) to string, and then on, for the same reason that ii railroad cars take to ride on the same guess runway and have the couplers at the same height. If they don't, they can't work together.

One time you've told the field what kind of data, you lot should enter a prompt text or phrase. Well-nigh times a user will know what the input should exist about. Only setting up a prompt is still a good idea. Even someone who uses the report may not use it for a while, you lot see.

Parameter fields can even work in or side by side to text objects. They tin can exist labels specific to the written report you're running. You lot tin can put them near anywhere yous demand the viewer to see what the study is reporting on. So fifty-fifty your labeling is flexible.

To acquire more about this, have a expect at our Crystal Reports classes.