ASP.Net options for creating and sending order reports

Posted on 2012-09-09
Last Modified: 2012-09-14
I have a .Net web application written in c# visual studio 2010 against a SQL Server 2008 database.  Users are able to create and submit orders to our backoffice.  We need to allow the users to download a report of their order at will.  Also when an order is submitted we need to email them an order summary.

We have done this in the past by creating a CSV file but would like to more to a nicer solution; perhaps a PDF or Word file.  Are there any free options we should be considering to allow us to generate attractive reports quickly?
Question by:canuckconsulting
    LVL 38

    Accepted Solution

    A basic Crystal Reports solution comes with the Visual Studio software. From there you should be able to dump that to a PDF printer SW. Then you can e-mail that.
    LVL 30

    Assisted Solution

    I agree with Jimpen. Crystal Reports is the best (or perhaps easiest?) way to do this sort of thing.

    Crystal Reports for VS2010
    It turns out that Crystal Reports for Visual Studio 2010 was released separately, instead of included with the product and Crystal Reports for Visual Studio 2010 will continue to be free, with no registration required.

    Download crystal report from the below mentioned link

    Or just directly paste below link to your address bar and it will ask to save an exe file.

    Examples - easy enough to find these on Google, even showing how to Export a Crystal Report to PDF

    Author Comment

    Thank you for the help!  I have created my report using Crystal and displaying it via the Report viewer control  I have just deployed it to the server but am getting an error "Database Vendor Code: 17 ] Failed to open the connection".

    Before I go further I wanted to confirm something.  Does the web client need to be able to connect directly to the DB?  I hope not as this is to run on the internet so this is not possible.  I am assuming everything is done server side but just need to be sure!

    Thank you again!
    LVL 30

    Expert Comment

    Everything is done on the server side.

    For the error, try this:

    Do the following steps:

    1. Open the report in the CR XI designer.
    2. Select Database -> Set Datasource Location.
    3. Set Datasource Location window will appear and in the replace with section connect to the database and replace these tables with the tables in the current datasource by clicking the update button.
    4. After updating close the Set Datasource Location window.
    5. Go to 'Database menu' and Click 'Verify Database' and click on OK.
    6. Preview the report and the save the report.

    Author Closing Comment

    I have decided to open another question regarding my connectivity issues.  Thank you for your help!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now