What if you made each column on the report a box - rather than a series of lines that join to make a table. You obviously will have a maximum number of "column boxes" you can fit into that space. By the looks of your image, this is 24.
So... lets say you have 30 possible categrories for the grid in the future - to generate the report, you'll need to go and check how many of the categories have counts and need to be displayed - lets say that number is 15 this time - pass each of the names of the 15 relevant categories into an array (these are your headings - need to set them up in your report as variables that refer to each element of the array - making sure to have a "print when" on each of them) Then also each of your column boxes (and the variables within them sitting in the detail band) needs "print when" on it too that corresponds to whether that number element exists in the array. Something like that... or am I as clear as mud also? :-) Tina Currie www.datahouse.com.au > ----- Original Message ----- > From: "MB Software Solutions,LLC" > <[email protected]> > To: <[email protected]> > Sent: Tuesday, September 08, 2009 5:26 PM > Subject: VFP9SP1 report -- need suggestions on alternative approach > > >> Check out this graphic: >> http://mbsoftwaresolutions.com/images/gbr2.png >> >> The part circled in red shows all possible categories for that grid. >> What I want to do (because we may want to add more and we're out of >> horizontal report real estate) is conditionally show columns, and have >> them basically be something like you'd output to Excel if you were doing >> this, but only having columns where counts exist. >> >> Clear as mud? ;-) >> >> tia for ideas! >> >> -- >> Mike Babcock, MCP >> MB Software Solutions, LLC >> President, Chief Software Architect >> http://mbsoftwaresolutions.com >> http://fabmate.com >> http://twitter.com/mbabcock16 >> >> [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/c955ce59230c4dfd8d774b7e76bf6...@tinapc ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
