InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How Do We Connect To The Database? |
|
Answer» Answer :There are two ways of creating the report: – Use crystal report BUILT in query. Use the tool ‘ Crystal SQL Designer’ provided by crystal report. When you create report using crystal report built in query then it asks for the data SOURCE name that you have CREATED. When you run the report, then for the first time it will ask for the user id and password. After that it will store the same. When you create ‘.qry’ using ‘Crystal SQL’ Designer then at that time it will ask for the user id and password. When you run the report for the first time instead of asking for the user id and password it will ask for the ‘.qry’ file location. You can CHANGE the query location also. For that open the report, select ‘Set Location’ option in Database menu item, and set the location. |
|