To select data in Crystal Reports, follow these steps:
Open the Crystal Reports program and create a new report or open an existing one.
Click on the "Database" menu and select "Show SQL Query."
In the SQL Query window, write a SELECT statement that specifies the fields you want to retrieve from your database. For example: SELECT CustomerName, OrderNumber, OrderDate FROM Orders
Add any necessary WHERE clauses to filter the data. For example: WHERE OrderDate >= '1/1/2020' AND OrderDate <= '12/31/2020'
Click on the "Database" menu and choose "Verify Database" to ensure that the query runs correctly.
Preview the report to see the selected data.
Note: You can also use the "Select Expert" tool in Crystal Reports to specify more complex selection criteria.
Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss
Asked: 2023-07-03 22:07:46 +0000
Seen: 13 times
Last updated: Jul 03 '23
How can a crystal report be created from a dataset in Vb.Net?
How can the access violation in crystal reports be expressed differently?
How can one suppress certain details sections on Crystal Reports based on the page number?
How can I export an XML string as a text file in Crystal Reports?
How can Pytorch circular padding be used to implement Floquet-Bloch boundary conditions?
How can the LCD (I2C) display the sum of money inserted into the coin acceptor?
How can details sections in Crystal Reports be suppressed depending on the page number?
What is the process of generating a class instance using a string name in Crystal?