| GP Reports Viewer Excel Reports Released to Beta
It's not too late to get in on the beta release of Excel reports
|
|
 Over the last few months I have talked to many of you about our next big GP Reports Viewer feature - Excel Reports. Everyone I talk to can't wait to use this exciting new feature! We are shipping the beta version now, so if you are interested, it is not too late to be part of the beta program. Please email us to become a beta tester.
Using Excel reports with GP Reports Viewer allows your users to launch refreshable Excel reports directly from Dynamics GP. Below are just some of the additional benefits:
- Launch Excel reports based on SQL stored procedures, tables, views, or code embedded directly into the Excel report
- Link Excel reports to any Dynamics GP window and automatically pass parameters from fields on the window to your report
- Email Excel reports directly from Dynamics GP
- No additional permissions need to be set up in SQL, all security can be handled inside Dynamics GP.
Remember the three beta testers that participate the most will each get a $50 Amazon.com gift card.
|
Blank Page at the End of a Crystal Report
How to get rid of the blank page at the end of a Crystal Report
I recently created a slew of Crystal reports for a new project and have had to revisit this topic more than once. Often, when you have groups in a report and you set up the paging to have a New Page After the group footer, you will have a blank page at the end of the report.
To fix this, you can go to the Section Expert and add the following formula next to the New Page After option on the group footer:
not OnLastRecord
This will suppress the new page after the last group on your report.
|
How to Use a Top # Parameter in SQL Coding
How to allow the user to select how many 'top' records to show |
|
We wanted to create a variation of the 'Top 20 Customers' report. The variation was that the user wanted to choose the 'top' number. Typically, they would use the old standby of the top 20 customers, but sometimes they might want to see the top 100, or they might want to select the top 100,000 to see all customers.
To accomplish this, in the SQL stored procedure for the report we added an integer parameter called @top.
Then to determine the top customer list (in this case by revenue) we used the following formula:
select
top (@top) row_number() over(order by Revenue desc) RowNum,
Customer
from SalesTotals
order by Revenue desc
SalesTotals in this case was a table with the revenue totals already calculated by customer. Hope this helps with your SQL coding!
|
