locked
How to Create Crystal Report in window application using MS access 2007 RRS feed

  • Question

  • User1392654446 posted

    Hi,

    How to Create Crystal Report in window application using MS access 2007??

    Please Suggest me procedure step by step.

    Thanks in Advance.

    Tuesday, July 19, 2011 8:12 AM

Answers

All replies

  • Tuesday, July 19, 2011 10:39 AM
  • User1196771204 posted

    hi juhi_it,

    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

    :-) 

    Wednesday, July 20, 2011 11:48 PM
  • User1392654446 posted

    Hi,

    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.

    Thursday, July 21, 2011 7:44 AM
  • User1196771204 posted

    hi juhi,

    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

    Thursday, July 21, 2011 11:28 PM
  • User1392654446 posted

    Hi,

    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??

    Friday, July 22, 2011 5:47 AM
  • User-1694870838 posted

    Hi,

    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

    Best Regards,

    Damon

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, July 28, 2011 1:05 AM
  • User1392654446 posted

    Hi,

    I have created crystal report but can you tell me how to make group in crystal report???????

    Thanks in Advance.

    Saturday, July 30, 2011 5:11 AM
  • User-1694870838 posted

    Hi,

    you can use Group Expert to make group in the crystal report wizard ,please refer to the  picture and link following:

    Figure_16.jpg

    http://www.codeproject.com/KB/aspnet/Crstalreportusingvs2010.aspx

    Best Regards,

    Damon

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, August 1, 2011 1:24 AM