I'm assuming the report is a crosstab report? Could you exclude all the rows from the report dataset where the value is 0? If you omit the data for the column then the column will never be generated in the first place. There might even be some performance increase as well.
John G. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of MB Software Solutions, LLC Sent: Tuesday, September 08, 2009 18:20 To: [email protected] Subject: Re: VFP9SP1 report -- need suggestions on alternative approach Rafael Copquin wrote: > a) to show or not a column, put a condition that will make it > visible/invisible if the count exists (whatever you mean by that) > > something like thisform.grid1.column5.visible = (yourcondition = .t.) > > b) build a textbox class that would check for the above condition and > replace the column's textbox with your new class > > Is this what you want? > > Rafael Copquin You're right on (a), but I don't want some kludgey nightmarish code that any dev would shoot me (or I'd fall on my sword for) with nasty IIFs out the wazoo....and I need the columns built left-to-right with no gaping holes. The challenge is how to achieve this without some insane IIF scenarios. I suppose I could build some UDFs to be called at runtime from the FRX, but that's all I can come up with. -- 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/01a501ca3101$3244abd0$96ce03...@net ** 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.
