ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> ODBC General Issues >> Business Intelligence Software
http://www.istechforum.com/YaBB.pl?num=1568230547

Message started by BurrKing_Mfg on 09/11/19 at 12:35:47

Title: Business Intelligence Software
Post by BurrKing_Mfg on 09/11/19 at 12:35:47

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

Title: Re: Business Intelligence Software
Post by gtladmin on 01/02/20 at 14:48:30

We are still on Crystal, but would love to know what others are using instead of Crystal.

I've looked at a few options over the years, but most run on a Windows server and we only run Linux. So.....I keep looking, watching, waiting to find something.

Val

Title: Re: Business Intelligence Software
Post by Kelloggs on 01/02/20 at 15:36:08

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

:)

Title: Re: Business Intelligence Software
Post by gtladmin on 01/17/20 at 08:16:07

Sounds interesting, but not for our environment. Glad it works for you!

Title: Re: Business Intelligence Software
Post by AllanMac on 02/24/20 at 14:24:15

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...

Title: Re: Business Intelligence Software
Post by Kelloggs on 03/04/20 at 15:17:50

You will have to "link" the BKARHINV and ISMCR tables

BKAR_INV_ISCUR=ISIS_MCR_BASE
BKAR_INV_INVDTE=ISIS_MCR_DATE

Then do the math (ISIS_MCR_RATE_1*BKAR_INV_SUBTOT), multiply or divide, depending of your base currency

The problem would be is there is no a exchange rate for the invoice date.
Do you enter rates every day?

have fun

Kelloggs

Title: Re: Business Intelligence Software
Post by AllanMac on 03/05/20 at 15:18:18

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.

Title: Re: Business Intelligence Software
Post by Kelloggs on 03/05/20 at 17:31:10

SELECT TOP 1 ISMCR.ISIS_MCR_BASE, ISMCR.ISIS_MCR_SOURCE_1, ISMCR.ISIS_MCR_RATE_1
FROM ISMCR
ORDER BY ISMCR.ISIS_MCR_DATE DESC;

It will show the last entry for each case

BASE = Your currency
SOURCE = what needs to divide/multiply

Kelloggs

Title: Re: Business Intelligence Software
Post by Kelloggs on 03/06/20 at 08:08:05

correction

it should be

BKAR_INV_ISCUR=ISIS_MCR_SOURCE_1
BKAR_INV_INVDTE=ISIS_MCR_DATE