Differences
This shows you the differences between two versions of the page.
control_error_-_no_data_found [2019/01/27 11:28] |
control_error_-_no_data_found [2019/01/27 11:28] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | ==Error Message== | ||
+ | |||
+ | |||
+ | |||
+ | Printing a report results in a mostly blank page with the text "No Data Found." | ||
+ | |||
+ | |||
+ | |||
+ | ==Explanation of Error== | ||
+ | |||
+ | |||
+ | |||
+ | To populate a Crystal Report, a query is generated and sent to the database for results. | ||
+ | |||
+ | |||
+ | |||
+ | ==Severity== | ||
+ | |||
+ | **Normal**. | ||
+ | |||
+ | |||
+ | |||
+ | ==Possible Causes== | ||
+ | |||
+ | |||
+ | |||
+ | This occurs when the SQL result set is NULL. This may be caused by: | ||
+ | - Missing data. | ||
+ | - Incorrect linking in the report (specifically, | ||
+ | |||
+ | |||
+ | |||
+ | Example of each of these cases: | ||
+ | - The invoice usually displays the contacts address. | ||
+ | - The Purchase Order could also display the vendor contact information, | ||
+ | |||
+ | |||
+ | |||
+ | ==Resolution== | ||
+ | |||
+ | |||
+ | |||
+ | The solution depends on the specific problem, but general techniques are: | ||
+ | - Add the missing data. Often editing the records involved (e.g., the Order, Customer, and Salesperson records) can help find the missing information. | ||
+ | - Make sure you are running the latest version of the reports. | ||
+ | - Contact Technical Support by [[telephone_support_information|Phone]] or [[mailto: | ||
+ | |||
+ | |||
+ | |||
+ | ==Debugging Tips== | ||
+ | - Open the errant report in preview mode. | ||
+ | - Right click on a blank section of the report title bar (the bar containing the //Setup//, //View Full Screen//, and Page Navigation Buttons. | ||
+ | - Click " | ||
+ | - Open SQL Server Management Studio Express and connect to your SQL Server. | ||
+ | - Select your StoreData database and click "**New Query**" | ||
+ | - Open the SQL Query Text file you saved earlier and paste it into the new query window. | ||
+ | - Execute the query. | ||
+ | - You must correct this query to find how the report is linked improperly. | ||
+ | |||
+ | |||
+ | |||