I have several reports in Crystal 2016. Has anyone created interactive dashboards using crystal reports? The Business Insight Dashboard is canned and not really customizable. Sage Intelligence isn't all that friendly. Your still trapped in a little box. Is anyone using a dashboard tool where you can drag and drop crystal reports and post as a sage 100 user dashboard?
Thanks
Hi Tom,
Your query based analytics offering looks interesting. I was unable to find any pricing on your site. Does this mean it's open source and free?
I been using Excel's Power query. They are completely automatic and there's no VBA coding required, but I use a small macro to disconnect the data connections for external distribution. I did these sales…
I have created a few reports with parameters that can be changed dynamically from the preview window and had the report layout and contents change appropriately based on parameter values. The parameter needs to be to Editable as seen below.
This allows you to toggle the display of the parameters using this button in the preview window.
You can set a report up to be optimized for on screen viewing rather than printing and set the page size to be as big you need to.
However, i haven't done much with crystal report's charting and graphics so i can vouch for how robust or capable it is.
Business Insights Explorer views are pretty flexible and also allow some charting so that is something else to consider if you are looking to stay within the sage 100 toolset rather than look at another third party solution.
I have created a few reports with parameters that can be changed dynamically from the preview window and had the report layout and contents change appropriately based on parameter values. The parameter needs to be to Editable as seen below.
This allows you to toggle the display of the parameters using this button in the preview window.
You can set a report up to be optimized for on screen viewing rather than printing and set the page size to be as big you need to.
However, i haven't done much with crystal report's charting and graphics so i can vouch for how robust or capable it is.
Business Insights Explorer views are pretty flexible and also allow some charting so that is something else to consider if you are looking to stay within the sage 100 toolset rather than look at another third party solution.
