I am having a bit of a dilemma figuring out the best way to output some data the way I want most efficiently.
As i can't post images to the list, I have uploaded a word doc here with an example. www.satachi.com/russ/lists/yf_sample.doc This is basically market research data that can be National, regional or local. If the locale is national, the data applies only to countries. If the locale is regional, the data applies to regions of countries. If the local is local, the data applies to a specific ity of a specific region of a specific country. Any factor may thus have any number of rows of data in the DB as it's data could be acros smany countries or regions, or just for a single city. There will be one row for each column of data in the output, which is made up of a country (required), region(optional) and city (optional). The output needs to be groupe dby the factorID. As you can see form my example, the factor called "regional test" has 4 columns as it has been recorded for multiple regions in the UK. The "students" factor only has data for 1 region, and thus will only have 1 column to output. In the same way, other factors could more or less columns. I this respect I think I probbaly cannot have a single heading for everything and will need to have new headings for each factor, otherwise they will not line up. Grouping my cfoutput doesn't achieve what I want in my tests as I can't tabulate it properly. Anyone else got any suggestions? thanks -- Russ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228705 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
