You create a sales report, which requires elevation data to display. The share and sales data are required in different types of databases. Which method you can use to change the elevation data from a subreport to the main report?
Use a two-way formula.
Use a shared variable.
Use a global variable.
Use an inverse formula.
As a default value is used for NULL values â€‹â€‹in a report when you choose to convert the database NULL values â€‹â€‹by Default Options from the File menu Report?
Crystal Reports NULL default
International default settings System
Database NULL default
The default value defined in the DSN
Dynamic recipient of supporting data provider which of the following types of data? (Choose three.)
You must use a formula in a new crystal report that creates an account number for each customer. The account number is composed of the first five alphabetic characters from the Customer Name field and the first five numeric characters from the Phone field. All records contain at least five characters of the correct type for each field. What process do you use to create your account number?
Use the If-Then-Else instructions to return each possible outcome for each field. Create formulas to extract the characters required by the customer name and phone fields and assign the results to global variables. Use a third formula to concatenate the results and display the account number
Create a formula that uses a SELECT statement that is processed on the database server which chains the first five alphabetic characters from the Customer Name field with the first five numeric characters from the Phone field. The last line shows the result of ten characters.
Create a formula with two Do while loops. The first extracts the first five alphabetic characters from the customer name field and the second extracts the first five numeric characters from the field of telephone and chaining them to the five alphabetic characters. The last line shows the result of ten characters.
Use nested If-then-else statements to return each possible outcome for each field. Create a formula to extract the characters required by the If-then-else then view the results concatenated data.
What type of sub report used to enter the information into a report that is generated when a hyperlink is clicked?
Click To link