locked
Crystal Report in web-based application ? RRS feed

  • Question

  • User1929035129 posted

    I am working on a web based Inventory Management System, and i have discussed with someone for report part and decided to use Crystal Report. So i want to ask if Crystal Report will be fine in web application or it can cause some problem in deployment, or client side dependency issue.

    I am new to Crystal Report please suggest me.

    Thursday, October 18, 2012 2:17 AM

Answers

  • User-578610739 posted

    Hi Tdmca,

    Crystal report is good to use, it gives good formating option. But now there is alternate option is sql reporting or SSRS.

    There is no problem with delployment (It is depend on your reporting version, .net framework as well as server configuration).

    In future, if you have any issue then in this forum you definately get the answer.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, October 22, 2012 3:19 AM

All replies

  • User-179079940 posted

    refere this link

    http://www.aspdotnet-suresh.com/2012/01/crystal-reports-sample-in-aspnet.html

    and ddl problem than find crystal report dll in c drive/proframfile and this dll put your bin folder

    Thursday, October 18, 2012 2:20 AM
  • User1929035129 posted

    Ok kaushik,

    i am started working on creating sample Report.

    I have two tables stockin stcokout like following

    date     materialid     quantity     

    in report i have to show like this:

    date                   material                 in               out

    12/11/2012         Soap                    5

    12/11/2012         Soap                    2

    12/12/2012         Soap                                         2

    12/12/2012         Soap                                         2

    --------------------------------------------------------------

    Total                                               7                  4

     -------------------------------------------------------------

    InStock                                                                3                                                                         

    At present i have queried like this: 

    select entrydate,materialid, quantity, 'In' as Direction from stockin 

    union

    select entrydate, materialid, quantity,'Out' as Direction from stockout

    But i have to show separate columns for in and out

    Can you please refer me some link for any tutorial on how to change columns like this in report 

    Thursday, October 18, 2012 2:55 AM
  • User-578610739 posted

    Hi Tdmca,

    Crystal report is good to use, it gives good formating option. But now there is alternate option is sql reporting or SSRS.

    There is no problem with delployment (It is depend on your reporting version, .net framework as well as server configuration).

    In future, if you have any issue then in this forum you definately get the answer.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, October 22, 2012 3:19 AM
  • User-179079940 posted

    select * from stockin inner join stockout where stockin.meterialid=sockout.meterialid

    Monday, October 22, 2012 3:22 AM