[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...