Click here to Skip to main content
Click here to Skip to main content

Tagged as

Quick and dirty reporting solution using Excel

, 21 Apr 2011 CPOL
Rate this:
Please Sign up or sign in to vote.

Problem

Sometimes you must provide quick reporting solution, but at the same moment you don't have proper resources or you are just lazy!

Solution

If your client has MS Excel installed, you can in few steps provide rather slick ad hoc solution which will do the job until you can provide something with more professional feel. Hey, I've done project where most of the reports are done this way and client prefers it. It's a Trade-off with capital T. Smile | :)

Step by step Tutorial for Getting Data from SQL Server

  1. Write appropriate query or view, I'll use view and advise you to do the same.
  2. Create New Excel document on client computer.
  3. Open it, on Data toolbar chose From Other Sources(or Existing Connections, if you have useful existing connection). It will start Data Connection Wizard which will guide you, it's self-explanatory.
  4. When you are done with wizard Import Data dialog will pop out. Leave default values and click OK. Here you go!
    Client can refresh data and manipulate with results, play with charts etc.
You can provide similar results with other data sources as well, try them!

This isn't revolutionary idea, but I think it's neglected.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Oshtri Deka
Software Developer
Croatia Croatia
Software engineer.
 
C/C++ during college, .Net and C# first as a hobby, now it is a full-time job; SQL follows me wherever I go.
 
ASP.Net, JavaScript, HTML they were necessity, but slowly become my bread and butter.
Hopefully I'll:
1. master F#
2. find practical use for my Python knowledge
3. return to C
 

I like to think I am mature intermediate programmer Smile | :) .

Comments and Discussions

 
-- There are no messages in this forum --
| Advertise | Privacy | Mobile
Web04 | 2.8.141022.2 | Last Updated 21 Apr 2011
Article Copyright 2011 by Oshtri Deka
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid