[dba-SQLServer] (no subject)

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