RSSCategory: Reporting

Indicator to specify single page or multi page customer statements

| 09/17/2011 | 2 Comments
Indicator to specify single page or multi page customer statements

Recently, I was assisting a forum user, who had requested an option to provide a visual indicator in the footer of the customer statement report, which indicates if the statement has a single page or multiple pages. After a little thought I had come up with this idea and replied back to the forum user […]

Continue Reading

Recent Updates to Payables HATB Script

| 06/30/2011 | 1 Comment
Recent Updates to Payables HATB Script

Hi all I have posted an updated for the following scripts today. Please make use of these updated scripts for the historical aged trial balance in payables. AP Historical Aged Trial Balance – By GL Posting Date http://msdynamicstips.com/2010/10/09/payables-hatb-report-sql-query/ AP Historical Aged Trial Balance – By Document Date http://msdynamicstips.com/2010/10/08/payables-hatb-using-document-date/ Hope this update helps the community… Until […]

Continue Reading

Excel Pivot Table – Filling Blank Cells

| 02/09/2011 | 2 Comments
Excel Pivot Table – Filling Blank Cells

Hi all Pivot table is most common reporting mechanism used by many users for generating analysis reports. When using Pivot Tables frequently you probably realized it is not very handy to copy the data out of the pivot table and then go line by line and fill all the gaps in the columns from Row […]

Continue Reading

Adding/Removing Reports to/from My Reports

| 11/16/2010 | 3 Comments
Adding/Removing Reports to/from My Reports

Hi all Recently I was working with a community user on an issue where the user was facing an issue in adding reports to the My Reports section on the home page. So I decided to write up this article which throws some light on to how we can add/remove reports to/from the My Reports […]

Continue Reading