Earth | North America | United States | California | Long Beach
What do you mean by upper bound?
With regard to the report. The row of data on the report would be based on the location number. So, the rest of the report would be like this...
LocationNum, LocationName, Manager, etc etc.
My problem is with the multiple products per location. I would like each location to take up only one line. I do not care if the line height grows due to this particular field. In fact this field would grow if there were a few products sold at a location.
Alternatively, if there is a better way to track this data (than what I have shown) I would not mind changing the table.
Originally posted by M Owen
Do you have an upper bound? If not, there is no real way to do this since you're trying to convert row data into column data and report-wise column data has to be a fixed number ...