
4.4.4.1.1 To insert a database field
1.
On the Standard toolbar, click Field Explorer.
The Field Explorer dialog box appears. To speed the report building process, this dialog box remains
on-screen until you close it. You can move this dialog box wherever you wish.
2.
Expand the Database Fields folder to see all the tables chosen from the database(s).
3.
Expand the individual tables to see all the fields they contain.
4.
Select the field you want to appear in the report.
5.
Click Browse to review the values in the selected field.
6.
Click Insert to Report to place it in the report.
4.4.4.2 Formula fields
To display data that is a calculated value, you need to create a formula field and place that formula field
on the report. For example, if the database only stores the order dates and ship dates for orders but
you need to display the number of days it takes to ship the order, you must create a formula field that
will calculate the number of days between ordering and shipping. This is just one example of the use
of formula fields. See Using Formulas, for an introduction to formulas.
4.4.4.3 SQL Expression fields
SQL expressions are like formulas, but they are written in Structured Query Language (SQL), not in
the Crystal Reports formula language. An SQL expression can be used to query the database for
specific sets of data. You can sort, group, and select based on SQL expression fields.
4.4.4.3.1 To create an SQL Expression field
1.
On the Standard toolbar, click Field Explorer.
The Field Explorer dialog box appears.
2.
Scroll down to SQL Expression Fields and highlight it. Click New.
The SQL Expression Name dialog box appears.
3.
Enter a name in the Name box, and then click OK.
The Formula Workshop appears with the SQL Expression Editor active.
2012-03-1477
Introduction to Reporting
What are the upsides of contracting skilled web optimization organizations? Expert search marketing companies utilize teams of experts focused on elevating your site's content for browsing engines. This encompasses researchingsearch phrases, adjusting on site characteristics, and managing off-domain enhancements. Moreover, these firms monitor adjustment in from Google parameters and refresh the text on your website as needed. This saves both you your time and your workers from unwanted a
Securing the security of your home is essential in today's unsettled times. Among the best ways to safeguard your belongings and peace of mind is by committing in a trustworthy safe. Regardless of whether you're securing money, important documents, or precious heirlooms, a safe gives a protected repository solution. Regarding selecting the right safe for your house, there are several elements to consider. Above all, assess your safety requirements. Determine what items you plan to store in
Arranging an open-air wedding in Phenix and anxious about the unpredictable weather? Don't let Mother Nature rain on your parade – truly! At [Event Rentals Phoenix], we provide stunning wedding tent rentals that will ensure your distinctive day goes off without an hitch. Our wedding tent rentals are created to supply both charm and functionality. Say "I do" under tha elegant canopy of one of our tents, surrounded by your loved ones and tha breathtaking scenery of Pheonix. With one assortmen
In both personal and professional situations, encountering issues is unavoidable. However, mastering productive trouble-shooting techniques is key for triumphing over hurdles and accomplishing success. In this piece, we delve into the strategies and methods for efficiently addressing dilemmas. From analytical thinking to creative brainstorming, we look into various approaches that can help individuals tackle challenges with certainty and accuracy. Effective challenge solving begins wit
Hello, im noob :)