Category Archives: SQL reporting

Export Payables Detail Historical Trial Balance to excel from reporting services

Microsoft provides an accounts payable detail historical aging report in SQL report services that I have modified to easily export to excel, here’s what the output looks like: This report originates from the standard report Dynamics GP provides when you … Continue reading

Posted in Dynamics GP, SQL reporting | Leave a comment

Keeping the header rows visible in SQL reporting services

Have you every had problems where your reporting services report loses it’s header row as you scroll?  Take a look at this video – It helped the look and feel of my reports significantly.

Posted in SQL reporting | Leave a comment

Export group name in SSRS 2008 to worksheet tab name in excel

Recently, I tried to name a worksheet tab in excel from each group in SQL Reporting Services 2008.  I found that the group name needs to be entered into the tablix member group called “PageName”. The first screenshot shows the … Continue reading

Posted in SQL reporting | 6 Comments