It's possible, but not simple. Relationships, calculation fileds, filtered portals and (possibly) ExecuteSQL might all be involved in setting up this type of report (called a cross tab report).
Much depends on the design details of your database in terms of your tables and existing relationships. You may want to hire a consultant familiar with this reporting method to set it up for you. Especially since, if I understand correctly, you want to omit columns of data where a given supplier does not have any of their product located.
Hi, Thanks for your reply. I figured speaking with a programmer is probably the way to go here. But, as an option, is it possible to select the locations with inventory (maybe via a checkbox, or popup window allowing to choose which locations to include) and then create a script to show only those locations in a new layout? For example, each location would have a checkbox. We'd then click the checkboxes/locations having inventory, click a button to run some kind of script taking the selected locations to a new layout?
Thanks for your help.
It's possible, though the process isn't any simpler and won't actually "take the selected locations to a new layout". The columns of data can be produced with filtered portals so it is possible to manipulate the value in a field that is part of the portal's filter expression in order to select a particular set of records to supply data to that column.