Tina Currie wrote: > 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
Yeah, this is what I'm thinking also! Thanks for confirmation of that idea. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ 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/[email protected] ** 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.
