As you can see below we are showing 8 companies, as well as grouping the data by year and I didn't have to make 8 of everything! All it took was 2 globals and 2 relationships, one for the year and one for the category. While this version will not have any data entry involved, that is also possible using javascript to pass the data to FileMaker using either the new REST API or using FMP URLs. In this example, I'm going to build a crosstab report using HTML and CSS and display the results in a web viewer. However, data entry and printing are going to be easier using this technique, and you have the advantage of not having to learn any other technologies. That's a lot of work just to show 3 columns, and not very realistic as chances are you're going to have a lot more than 3 companies in your system. The example below is built all with native FileMaker and involved creating 3 globals, 3 relationships, and 3 calculations and is limited to only showing 3 companies at a time. This is why crosstab reports are so powerful.
Below you can see an example of 2 reports showing the exact same data, but the crosstab report makes comparing company yearly sales much easier. There is a reason people love their spreadsheets, it makes comparing values in one group with values in another group really easy.
If this sounds like an excel spreadsheet, that's because it is. Crosstab reports format groups of data into an easy to read grid format.
0 kommentar(er)
