HowTo create a Summary page of Totals (Sum/Count) from SQL...

  • 3 November 2015
  • 2 replies
  • 7 views

Badge +10

Ok. so if my SQL Table where I'm inserting information.... for example Car Makes/ Car Models / Car Posts...

 

we have a universe of 40,000 cars entered in Car Posts... and I like to create a summary homepage for reporting.

 

Perhaps from SQL some querys like:

 

cars from 2010 and higher

cars between 2000-2010

cars older than 2000

 

Perhaps like to display a sql query where the query does a select count /group by Car Make. So I can know how many cars I do have from each make in the database...

 

Long story short, how would it be possible to achieve return that information into a smartobject to create a summary page ??

 

THX Dino.


2 replies

Badge +9

Stored procedures?

Badge +10

I was able to create a View from the table returning the Totals and use as kind of Dashboard.

 

CREATE VIEW FRD_Operating_Customers(Customer_Table,Customer_Count)
AS
SELECT Customer_Table, COUNT(Customer_Table) FROM SOME_TABLE
GROUP BY Customer_Table;

 

Thank you.

Reply