Darren DICK
darrend at nimble.com.au
Tue Apr 4 09:41:30 CDT 2006
Hi Francisco Not my code It's the Export to Excel option from reporting services If it calls a SPROC from its 'home' db then I'd love to know about it But AFAIKT it's all 'internal' - IE no access for me to modify <sigh> Darren ------------------------------ T: 0424 696 433 -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Francisco Tapia Sent: Tuesday, 4 April 2006 11:59 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] (no subject) why not tighten up the sproc or view that drives the report? eliminate nulls or empty values On 4/3/06, Darren DICK <darrend at nimble.com.au> wrote: > Hi all > Cross Posted to AccessD list > I am outputting reports to Excel from reporting services (SQL) The > reports have many tables on them with differing column widths When I > output the reports to Excel I find many columns with no data in them > > Is there a way I can write some VBA and have it determine the last row > on the sheet with a value in it determine if there is any data in any > cell from the top to the bottom - if there is no data in the column > delete it. Then 'tighten' all the columns? > > E.G. Column A has data, column B not data, column c has data Delete > column b and move column C to the left > > E.G. AirCode > For my sheet > find last.row with data ' that becomes the base point > find last.column with data ' that becomes a base point loop > through columns & rows > for A to last column > from 1 to last row > if data = null then > delete column currentcolumn > blah blah blah > > Many thanks in advance > > Darren > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > > -- -Francisco http://pcthis.blogspot.com |PC news with out the jargon! http://sqlthis.blogspot.com | Tsql and More... _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com