Last post Aug 01, 2011 01:24 AM by Damon Liu - MSFT
Jul 19, 2011 08:12 AM|juhi_it|LINK
How to Create Crystal Report in window application using MS access 2007??
Please Suggest me procedure step by step.
Thanks in Advance.
Jul 19, 2011 10:39 AM|ayyappan.CNN|LINK
Hi, Try this link
Jul 20, 2011 11:48 PM|necro_mancer|LINK
first of all, I would recommend you to think twice in using Access database in your production environment. Access database is meant for development purposes and you need to convert it to SQL Database once you are ready to go on production mode.
Crystal Report itself is quite "heavy" in terms of it uses more server resources. If you still use Access db, it will add to the server burden. If you went through all the previous posts on this forum, you will will some posts are about the poor Crystal Report
performance. Just for your note: they are using MSSQL database. I cannot imagine if you are using CR with Access database.
I certainly hope you can spend time to upgrade your db to MSSQL to avoid any potential issue in the future. Please mark this response as an "answer" if it helps you. Thanks heaps
Jul 21, 2011 07:44 AM|juhi_it|LINK
But I am working on Window based Application so it is not possible to use MSSql....
So i am using MS access.Except Window application I always like to use MS Sql Server.
Jul 21, 2011 11:28 PM|necro_mancer|LINK
I am not sure if I understand your question. How come a Windows application cannot connect to mssql database? What sort of windows application are you trying to build here?
Pardon me. As far as I am concerned, every Windows-based application should have an ability to work with Microsoft product, especially to SQL Server
Jul 22, 2011 05:47 AM|juhi_it|LINK
Window application can connect MSSql Database but it is not possible to install Msssql Server on perticular computer whenever .exe is runs on perticular Computer...
have you got my point??
Jul 28, 2011 01:05 AM|Damon Liu - MSFT|LINK
You can put data into dataset from MS access 2007 first, then the dataset as your crystal report datasource, about how to generate crystal report you can read this link:http://www.codeproject.com/KB/aspnet/Crstalreportusingvs2010.aspx
Jul 30, 2011 05:11 AM|juhi_it|LINK
I have created crystal report but can you tell me how to make group in crystal report???????
Aug 01, 2011 01:24 AM|Damon Liu - MSFT|LINK
you can use Group Expert to make group in the crystal report wizard ,please refer to the picture and link following: