Jump to content


Check out our Community Blogs

Register and join over 40,000 other developers!


Recent Status Updates

View All Updates

Photo
- - - - -

How To Create Microsoft Sql Database Report

SQL

  • Please log in to reply
1 reply to this topic

#1 caulson

caulson

    CC Lurker

  • Just Joined
  • Pip
  • 1 posts

Posted 22 May 2012 - 07:31 PM

HI,

im going to design a report use microsoft SQL database.


the example layout is below


Date On hand balance Usage
1/1 10 3
2/1 7 3
3/1 4 3
4/1 1 3




is anyone can tell me how to use the SQL function to caculate the date and on hand balance for each ?


thank you.

Edited by caulson, 22 May 2012 - 07:40 PM.

  • 0

#2 WingedPanther73

WingedPanther73

    A spammer's worst nightmare

  • Moderator
  • 17757 posts
  • Location:Upstate, South Carolina
  • Programming Language:C, C++, PL/SQL, Delphi/Object Pascal, Pascal, Transact-SQL, Others
  • Learning:Java, C#, PHP, JavaScript, Lisp, Fortran, Haskell, Others

Posted 23 May 2012 - 02:49 PM

Without knowing the data, table structure, or reporting tool, probably not.
  • 0

Programming is a branch of mathematics.
My CodeCall Blog | My Personal Blog

My MineCraft server site: http://banishedwings.enjin.com/






Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download