Is anyone using any BI Software like Microsoft BI for reporting and dashboard reports?   Looking for an alternative to Crystal Reports that will give me a little better insight.
 
Thanks
James

I use Visual Studio since we move to Pervasive V10
I create executables that connect to Pervasive using ADO.net
the exe query the data and export the report to a folder as a PDF and opens it  
 
Imports Pervasive.Data.SqlClient
Module mapp
    Public Const erp_db As String = "Server Name=192.168.0.4;Database Name=MYDBA;"
End Module
 
The Report Tool is quite good, in my opinion better than crystal
 
 

I use MS Access to create queries, then use Excel Power Pivot to create my dashboard reporting from those Access queries.  Using Office 365.  Works well most of the time as all I have to do is hit Refresh-All in Excel, then run a few checks.
 
Haven't figured out how to get total sales in base currency through a query on BKARHINV though, as we invoice in other currencies from time to time.  Happy for someone more familiar with Access to send me some pointers...

Thanks, that's helpful, I think.  I'll have a play when I get a chance.
I don't enter FX rates daily - just not worth the effort for the one or two foreign currency invoices raised per month (if that).  I will have a think about how I can get the relevant FX rate.

correction
 
it should be
 
BKAR_INV_ISCUR=ISIS_MCR_SOURCE_1
BKAR_INV_INVDTE=ISIS_MCR_DATE