Crosstab reports - suggested techniques

Discussion created by amsc on Jul 6, 2017
Latest reply on Jul 6, 2017 by SteveMartino

I need to create a series of cross tab reports for our FM solution.  The reports that I'm designing will need to be "adaptive" in that the # of columns and rows will need to accommodate however many inputs are provided (within reason).  These could change based on filters applied (think business regions and product lines). 


I've looked around, and there are several different approaches that can be taken (DB solutions web viewer approach, standard virtual lists, and "dynamic variable instantiation" just to name a few approaches).  


Our solution is FM Cloud hosted with a mixture of FM15 and FM16 clients. 


I was hoping for some insight and suggestions from the Filemaker community. 


Thank you in advance for your suggestions!