Crystal Report Developer

Crystal Report Developer Interview Questions and Answers

Updated 17 Jun 2023

Q1. What is the difference of table formate and crosstab? Crosstab is an in built structure which is use like pivot and unpivot. Table as per the client manuelly we can draw the table as customer required fields.

Ans.

Table format is manually drawn by the user with required fields, while crosstab is an in-built structure used for pivoting and unpivoting data.

Table format is manually created by the user based on customer requirements
Crosstab is an in-built structure similar to pivot tables in Excel
Crosstab allows for dynamic aggregation and summarization of data
Table format is static and requires manual adjustments for changes in data

Q2. What is the difference between stored procedures and functions

Ans.

Stored procedures are precompiled SQL queries that can perform multiple operations, while functions are reusable code blocks that return a single value.

Stored procedures can execute multiple SQL statements, while functions can only return a single value.
Stored procedures can have input and output parameters, while functions can only have input parameters.
Stored procedures can be used to perform complex operations, while functions are typically used for calculations or data ma...read more

View 1 answer