Need PHP Dashboard using Stimulsoft Dashboard product. I need it to read data from a SQL Server table that contains a Seq number, ForDate and ForStores (which is a comma separated column like 1,2,3,4,5).
I need the php script to look at the Seq number that is being passed via URL, read the record that has the date and store numbers in it, and then produce the dashboards (one for each store) and export to a pdf file.
The dashboard datasources will be two SQL Server stored procedures, one which returns one row and it's data is put into the dashboard, and the other Stored Procedure returns 31 rows which needs to create a graph in the dashboard.
This is basically a proof of concept, so if this can be done, I am planning on changing for my exact needs.
You must have Stimulsoft Dashboard experience, PHP, and SQL Server experience