[dba-SQLServer] (no subject)

Francisco Tapia fhtapia at gmail.com
Wed Apr 5 10:36:41 CDT 2006


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



More information about the dba-SQLServer mailing list