Excel 2007 linked to SQL Server

Shows how Excel 2007 can be linked to SQL Server to create a powerful financial reporting tool

---

Closed Caption:

XJL use a user-friendly
all the bomb for 10 reporting tool
linking Excel
to a powerful SQL Server Reporting
database
update reports from the database is easy
select the date tap and hit the refresh
your butt
you can see the report been updated
in the bottom right hand corner report
shows
a summary trial balance going down
reveals a piano needle stuck to reformat
cooling down
further reveals the individual general
ledger accounts
headings commute clubs back to the
summer level
this report uses the county conventions
buddies on negative for example income
habits are posited
I E expenditure and outgoings scrolling
down the report reveals
the balance sheet games you see close
individual accounts to capitol me its
I'm total assets
and finally total liabilities
some levels can be shown again by claps
beheadings a grand total to me I did
use in the report options different
financial periods can be selected
using the drop-down bill two boxes the
grand total changes to reflect the pay
be selected
headings and bread lines can be added
the worksheet you just like a normal
spreadsheet to do calculations
calculations you make within the
worksheet
you the date all from the reporting
database a unique feature
txt else except is the professional data
mining at the
decided uses sophisticated data mining
tools
on date all directly from reporting
database
specific a ticking retreat from the
reporting date
base by double clicking on a cell this
polls the data into a separate sheet
the analyzed appears
reveals the powerful analytical tools
finally
can I bring your tensions the total
technical result $85 million
highlighted agree which is used in dem
empty
thank you