Saturday May 27th 2017

Categories

Insider

Archives

‘Excel 2007’ Archives

Data Analyst

Data Analyst

Data Analyst-OPE0000008Q Description Company Profile:   Direct Energy is one of North America's largest energy and energy-related services providers with over 5 million residential and commercial relationships.  Direct Energy provides customers with choice and support in managing their energy costs through a portfolio of innovative [...]

Export to Excel 2007 with Crystal Reports

Export to Excel 2007 with Crystal Reports

This post about export Crystal Reports data to MS Excel 2007.  Although you can export to MS Excel (97-2003) but exporting to Excel 2007 requires extra step and presented below; 1-       Go to export option in Crystal Reports 2-       Export it MS Excel (97-2003) 3-       Once exported open it with MS Excel [...]

Pivot Table with Excel 2007 with data from Sql Server

This post is about using pivot table with excel 2007 with invoice payments received data from sql server. In this case company’s payment mechanism was changed from full 1 payments to breakup in 4 to 5 payments. We created a new table named payments received and linked it to the Invoices table. Whenever payment for certain invoice received it [...]