Darren DICK
darrend at nimble.com.au
Wed Apr 5 17:29:06 CDT 2006
Hi Francisco I have resized all controls to be 2cm, 4cm 6 or 8 cm wide Both on the report and in the tables Nothing else I have really resized all controls to be those sizes and once we export to Excel - I get pretty even results But if I add another table and use the same or similar width structure I realise in reality a control could be 2.000000345cm wide and the one below it is in reality 2.000000346cm wide - so we end up with a new column once we export to Excel Basically the problem comes when I add more than 1 table I should have been more precise in my original post And it's all just text boxes and tables - no matrixes yet - 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: Thursday, 6 April 2006 1:37 AM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] (no subject) Sometimes re-sizing a control can fix that, are you using the table or matrix control? On 4/4/06, Darren DICK <darrend at nimble.com.au> wrote: > Yep on screen it's beautiful > When you export to Excel lots of hidden columns with no data I know > how it happens - I just don't have a solution for it > > Though Shamil form AccessD wrote me lovely piece of code to remove > Certain columns with no data > > I just need to incorporate that code after (or just before) the Excel > doc is created > > 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: Wednesday, 5 April 2006 1:53 AM > To: dba-sqlserver at databaseadvisors.com > Subject: Re: [dba-SQLServer] (no subject) > > so when you view your report on the screen, there are no blank rows? > > On 4/4/06, Darren DICK <darrend at nimble.com.au> wrote: > > 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 > > > > _______________________________________________ > > 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 > > _______________________________________________ > 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