Using totals in reports
I've dabbled in Microsoft Access for many years and am used to their Querys. I'm having a dickens of a time figuring out how to do similar things in Quick Base. I have a table that contains 3 field...
Forum Discussion
Rob,
MS Access. I remember having to hook Crystal Reports......
No matter what DB you are in, at some point you exceed the limits of its ability to natively do reporting. Most DB's have no native capability and you have to use a reporting tool to get to anything. If you are reporting needs are exceeding QB have you considered Tableau or PowerBI? There is a PowerBI connector to Quick Base so you can get to some basic data pretty easy.
If you want to curate to optimize you will need to do an extract which we can help you with. Reach out if a SQL answer is appropriate.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
MS Access. I remember having to hook Crystal Reports......
No matter what DB you are in, at some point you exceed the limits of its ability to natively do reporting. Most DB's have no native capability and you have to use a reporting tool to get to anything. If you are reporting needs are exceeding QB have you considered Tableau or PowerBI? There is a PowerBI connector to Quick Base so you can get to some basic data pretty easy.
If you want to curate to optimize you will need to do an extract which we can help you with. Reach out if a SQL answer is appropriate.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
And thank you, Don, for your idea about PowerBI and Tableau - I haven't heard of either of those before. Where could I find more information about PowerBI and how it connects to Quick Base? And about doing an extract? Those types of things sound like they'll be very helpful for the types of apps I'd like to develop for the company I work for.
Really appreciate the help you and Mark have given!
------------------------------
Rob Reiterman
------------------------------
Really appreciate the help you and Mark have given!
------------------------------
Rob Reiterman
------------------------------
- Rob,
The number of options in the Business Intelligence/Business Analytics is very large. Two of the most popular are Tableau and PowerBI. I have different clients that use each of them.
Tableau is now owned by SalesForce. www.Tableau.com
PowerBI is owned by MicroSoft https://powerbi.microsoft.com/en-us/
PowerBI has a free version. Are you going to be the consumer of this report or do you need to distribute the info? The smaller the number of users for the Analytics part of your system you can avoid additional subscriptions or having to embed the Analytics back in Quick Base
There are three ways to get data over to the tools.
CSV Exports. If your data is flat and you do not need to refresh it often, then you can do the infamous Save as a Spreadsheet option in Quick Base
The PowerBI connector
https://help.quickbase.com/user-assistance/power_bi_with_quick_base.html
Extract and make a SQL DB also known as Sqlization. This is the gold standard but is the most work. Once your QB data is out then you can do anything you could want but that is conventional development and not as fast or easy as Quick Base work.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
