Regarging Crystal reports

Question

Hi experts (Using access database!)Now i have situation  i need to create a billing software . I have created a crystal report in vs 2008. I have added a dataset which contains the lists of tables and i have a report template created  then i have added the fields needed to be shown in the report. Now what i need is when creating the dataset i added the database field to it by directly selecting the database from my local system . I have a doubt that when i deploy the project to the client's machine if the database file gets installed to some other location?. Can they still have the report generated properly or will there be any problem?

Sriram Ramani · Answer

Thank you all so much. It worked well. Now i have one more thing i need to design in such a way that the user enters the standard(class like 1st  2nd etc) t studentname  month details . Now depending on the value the user enters the parameters must search from the database and return the appropriate details . Based on this result i must be able to print a bill.. What i have already done is that having two parameters in the report template. Now i need to check those values with the corresponding in the database. What should i do now?

Nilanka Dharmadasa · Answer

Hi Sriram Great. Now you have a crystal report template and you have added a dataset to the report. Eventhough you have conncted it with your local database if you pass a dataset from your code to the report the report will show the data set passed by the code. Not the dataset which was set at the creation of the report. So if you deploy your database at any location make sure to access it and get a dataset and pass it to the report through the code. If you pass a dataset the report will show it. If you dont pass anything the report will try to connect to you local database and get the dataset from that DB. Hoe you got my point. If this answer answers your problem please spend a few seconds to accept this answer.

Arumugam A · Answer

no need to worry It will work fine as of now. but u have to change the server name in the connection string