Emily Crank
- Total activity 113
- Last activity
- Member since
- Following 0 users
- Followed by 2 users
- Votes 1
- Subscriptions 50
Articles
Recent activity by Emily Crank-
Find the SQL Generating a Crystal Report
If you need to view the SQL that is generating a Crystal Report file, you can easily do so from Crystal Reports: Go to the Main Menu and expand the "Database" option. Choose "Show SQL query" ...
-
SQL Commands and Crystal Reports
Crystal Reports allows users to create reports not only by linking tables using the Database Expert screen but also by using SQL Commands. SQL Commands allow the results of a SQL query statement t...
-
Change the Data Source Location in Crystal Reports
To change the database location for a Crystal Report: From the Crystal Reports Main Menu, navigate to Database and select Set Datasource Location. Expand the report item. The report's database con...
-
Order Parameter Prompts in Crystal Reports
In Crystal Reports, parameters can be managed from the Field Explorer panel, under the Parameter Field section on the Crystal Reports designer GUI. While the panel can be anchored to different pla...
-
Using the iEBMS Gatekeeper
Occasionally there may be scenarios in which you want to limit the number of people that are attempting to reach your registration (or SOP or FOP) links at any one time. In those scenarios Momentu...
-
Displaying Notes on a Crystal Report
When displaying notes from Ungerboeck on a Crystal Report, there are two fields available for use from the table CC025_NOTES_EXT. The first is CC025_NOTE_TEXT. This is just the text of the note...
-
Retrieving a Note Class Template
Note classes are very useful for adding a block of text to a Crystal Report or EZWriter page. They are easily changed by Ungerboeck users who have no ability to modify reports, and they can also c...
-
Removing the @NotesLanguage Prompt
The appearance of the @NotesLanguage prompt when running a customized version of a standard report can be easily removed. This prompt appears because the report is no longer receiving the prompt i...
-
Display Multi-Select UDF Values
When a UDF set contains a field that allows users to select multiple values, the field on CR073_ISSUES or other UDF tables shows a NULL value, even when a value is selected. You must include the ta...
-
Retrieving the Actual Value for a User Defined Field (UDF) with a Validation Table
%CUSTOMLIST is unique parameter that allows you to load a validation table into a report drop down. You use %CUSTOMLIST_ValidationTableId. You can use the same one multiple times by appending _Addt...