[dba-SQLServer] (no subject)

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




More information about the dba-SQLServer mailing list