-
recent posts
- Reconcile Receivable/Payable agings to the general ledger and voids
- Export Payables Detail Historical Trial Balance to excel from reporting services
- Keeping the header rows visible in SQL reporting services
- FRx launcher run-time error 9 subscript out of range
- In Dynamics GP 2013 R2 you can copy/paste a GL entry from excel directly to the transaction entry window
-
most read posts
- Change fixed assets from fiscal to calendar year end
- General Ledger Year-End Close
- Export group name in SSRS 2008 to worksheet tab name in excel
- Export the Dynamics GP Payables or Receivables Historical Aged Trial Balance to Excel
- Specify connection error in Management Reporter 2012 FRx Migration wizard
- MSXML error after installing FRx 6.7 sp9 on Windows 7
- Projects
- Management Reporter Export Report Definition Listing to Excel
- Importing to Dynamics GP without integration manager or SQL
- Consolidations (of multiple currencies) in FRx
resources
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
3 Comments