How Custom Excel Rendering

Hello Friends, i have sql rs2005 and need custom rendering Excel extension,
some sample?
Tks
My problem is group cell in excel by default extension.
--
----
Microsoft M.V.P en SQLServer
SQLTotal Consulting - Servicios en SQLServer
Email: maxi.da@.gmail.com.nospam
----Have you looked at Software Artisans Officewriter for Reporting Services?
http://officewriter.softartisans.com/officewriter-250.aspx
--
Andy Potter
blog : http://sqlreportingservices.spaces.live.com
info@.(NOSPAM)lakeclaireenterprises.com
"Maxi" <maxi_da@.infovia.com.ar.sacame> wrote in message
news:unCh8YbjHHA.3512@.TK2MSFTNGP06.phx.gbl...
> Hello Friends, i have sql rs2005 and need custom rendering Excel
> extension, some sample?
> Tks
> My problem is group cell in excel by default extension.
> --
> ----
> Microsoft M.V.P en SQLServer
> SQLTotal Consulting - Servicios en SQLServer
> Email: maxi.da@.gmail.com.nospam
> ----
>|||Hi and tks, officewriter dont free :(, same code sample free?
----
Microsoft M.V.P en SQLServer
SQLTotal Consulting - Servicios en SQLServer
Email: maxi.da@.gmail.com.nospam
----
"Andy Potter" <info@.lakeclaireenterprises.com> escribió en el mensaje
news:O7FL9hbjHHA.1900@.TK2MSFTNGP04.phx.gbl...
> Have you looked at Software Artisans Officewriter for Reporting Services?
> http://officewriter.softartisans.com/officewriter-250.aspx
> --
> Andy Potter
> blog : http://sqlreportingservices.spaces.live.com
> info@.(NOSPAM)lakeclaireenterprises.com
> "Maxi" <maxi_da@.infovia.com.ar.sacame> wrote in message
> news:unCh8YbjHHA.3512@.TK2MSFTNGP06.phx.gbl...
>> Hello Friends, i have sql rs2005 and need custom rendering Excel
>> extension, some sample?
>> Tks
>> My problem is group cell in excel by default extension.
>> --
>> ----
>> Microsoft M.V.P en SQLServer
>> SQLTotal Consulting - Servicios en SQLServer
>> Email: maxi.da@.gmail.com.nospam
>> ----
>>
>|||Hey Maxi,
Did you get the sample code for exporting the report to Word format. Could
you please share if you have got it. If not what are the available options?
Send me mail at sravan.kasyap@.proteans.com
Thanks & Regards,
Sravan Kasyap.
"Maxi" wrote:
> Hi and tks, officewriter dont free :(, same code sample free?
>
> --
> ----
> Microsoft M.V.P en SQLServer
> SQLTotal Consulting - Servicios en SQLServer
> Email: maxi.da@.gmail.com.nospam
> ----
> "Andy Potter" <info@.lakeclaireenterprises.com> escribió en el mensaje
> news:O7FL9hbjHHA.1900@.TK2MSFTNGP04.phx.gbl...
> > Have you looked at Software Artisans Officewriter for Reporting Services?
> >
> > http://officewriter.softartisans.com/officewriter-250.aspx
> >
> > --
> > Andy Potter
> > blog : http://sqlreportingservices.spaces.live.com
> > info@.(NOSPAM)lakeclaireenterprises.com
> > "Maxi" <maxi_da@.infovia.com.ar.sacame> wrote in message
> > news:unCh8YbjHHA.3512@.TK2MSFTNGP06.phx.gbl...
> >> Hello Friends, i have sql rs2005 and need custom rendering Excel
> >> extension, some sample?
> >>
> >> Tks
> >>
> >> My problem is group cell in excel by default extension.
> >> --
> >>
> >> ----
> >> Microsoft M.V.P en SQLServer
> >> SQLTotal Consulting - Servicios en SQLServer
> >> Email: maxi.da@.gmail.com.nospam
> >> ----
> >>
> >>
> >
> >
>
>|||I have gone through that article and it was pretty interesting...but i have
one requirement which i am wondering whether OfficeWriter can solve'
Req:
I have report for which i have added tooltip (when u hover mouse on
particular cell) it shows description. Now when i try to export it into Excel
sheet i am not seeing the Tool tip be preserved in Excel.
Will this be solved with Office Writer'
this will help me alot
"Sravan Kasyap" wrote:
> Hey Maxi,
> Did you get the sample code for exporting the report to Word format. Could
> you please share if you have got it. If not what are the available options?
> Send me mail at sravan.kasyap@.proteans.com
> Thanks & Regards,
> Sravan Kasyap.
> "Maxi" wrote:
> > Hi and tks, officewriter dont free :(, same code sample free?
> >
> >
> >
> > --
> >
> > ----
> > Microsoft M.V.P en SQLServer
> > SQLTotal Consulting - Servicios en SQLServer
> > Email: maxi.da@.gmail.com.nospam
> > ----
> > "Andy Potter" <info@.lakeclaireenterprises.com> escribió en el mensaje
> > news:O7FL9hbjHHA.1900@.TK2MSFTNGP04.phx.gbl...
> > > Have you looked at Software Artisans Officewriter for Reporting Services?
> > >
> > > http://officewriter.softartisans.com/officewriter-250.aspx
> > >
> > > --
> > > Andy Potter
> > > blog : http://sqlreportingservices.spaces.live.com
> > > info@.(NOSPAM)lakeclaireenterprises.com
> > > "Maxi" <maxi_da@.infovia.com.ar.sacame> wrote in message
> > > news:unCh8YbjHHA.3512@.TK2MSFTNGP06.phx.gbl...
> > >> Hello Friends, i have sql rs2005 and need custom rendering Excel
> > >> extension, some sample?
> > >>
> > >> Tks
> > >>
> > >> My problem is group cell in excel by default extension.
> > >> --
> > >>
> > >> ----
> > >> Microsoft M.V.P en SQLServer
> > >> SQLTotal Consulting - Servicios en SQLServer
> > >> Email: maxi.da@.gmail.com.nospam
> > >> ----
> > >>
> > >>
> > >
> > >
> >
> >
> >|||I have gone through the article which you have posted and it is pretty
interesting. I have one requirement which I am wondering whether OfficeWriter
can solve'
Requirement:
Is there any way in which I can carry or retain the tooltip value which is
shown on my report into Excel sheet.
I mean when I export the report into Excel sheet, tooltip value is gone'
How can I retain the tooltip value when I export into excel '
Can my problem be solved by purchasing OfficeWriter or do you know whether
is there any way I can do it with the existing reporting services rendering
formats.
thanks alot in advance
"Dia" wrote:
> I have gone through that article and it was pretty interesting...but i have
> one requirement which i am wondering whether OfficeWriter can solve'
> Req:
> I have report for which i have added tooltip (when u hover mouse on
> particular cell) it shows description. Now when i try to export it into Excel
> sheet i am not seeing the Tool tip be preserved in Excel.
> Will this be solved with Office Writer'
> this will help me alot
> "Sravan Kasyap" wrote:
> > Hey Maxi,
> >
> > Did you get the sample code for exporting the report to Word format. Could
> > you please share if you have got it. If not what are the available options?
> >
> > Send me mail at sravan.kasyap@.proteans.com
> >
> > Thanks & Regards,
> >
> > Sravan Kasyap.
> >
> > "Maxi" wrote:
> >
> > > Hi and tks, officewriter dont free :(, same code sample free?
> > >
> > >
> > >
> > > --
> > >
> > > ----
> > > Microsoft M.V.P en SQLServer
> > > SQLTotal Consulting - Servicios en SQLServer
> > > Email: maxi.da@.gmail.com.nospam
> > > ----
> > > "Andy Potter" <info@.lakeclaireenterprises.com> escribió en el mensaje
> > > news:O7FL9hbjHHA.1900@.TK2MSFTNGP04.phx.gbl...
> > > > Have you looked at Software Artisans Officewriter for Reporting Services?
> > > >
> > > > http://officewriter.softartisans.com/officewriter-250.aspx
> > > >
> > > > --
> > > > Andy Potter
> > > > blog : http://sqlreportingservices.spaces.live.com
> > > > info@.(NOSPAM)lakeclaireenterprises.com
> > > > "Maxi" <maxi_da@.infovia.com.ar.sacame> wrote in message
> > > > news:unCh8YbjHHA.3512@.TK2MSFTNGP06.phx.gbl...
> > > >> Hello Friends, i have sql rs2005 and need custom rendering Excel
> > > >> extension, some sample?
> > > >>
> > > >> Tks
> > > >>
> > > >> My problem is group cell in excel by default extension.
> > > >> --
> > > >>
> > > >> ----
> > > >> Microsoft M.V.P en SQLServer
> > > >> SQLTotal Consulting - Servicios en SQLServer
> > > >> Email: maxi.da@.gmail.com.nospam
> > > >> ----
> > > >>
> > > >>
> > > >
> > > >
> > >
> > >
> > >

How create Excel linked server without Security Admin

I need to import excel data to mssql, i am creating linked server and then
selecting from it
Is there a why to create linked server without security admin role or some
other way to import data from excel spreadsheet to MsSQL 2000. It is not
very good security policy to have 10 users with Security administrator
server role :)
--
MusonDTS?
"Muson" <nu@.nu.nu> wrote in message
news:ufic8sc8GHA.788@.TK2MSFTNGP05.phx.gbl...
>I need to import excel data to mssql, i am creating linked server and then
>selecting from it
> Is there a why to create linked server without security admin role or some
> other way to import data from excel spreadsheet to MsSQL 2000. It is not
> very good security policy to have 10 users with Security administrator
> server role :)
> --
> Muson
>|||In SQL Server 2005, you can grant ALTER ANY LINKED SERVER permission, which allow to execute
sp_addlinkedserver. See below BOL URL:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/fed3adb0-4c15-4a1a-8acd-1b184aff558f.htm
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Muson" <nu@.nu.nu> wrote in message news:ufic8sc8GHA.788@.TK2MSFTNGP05.phx.gbl...
>I need to import excel data to mssql, i am creating linked server and then selecting from it
> Is there a why to create linked server without security admin role or some other way to import
> data from excel spreadsheet to MsSQL 2000. It is not very good security policy to have 10 users
> with Security administrator server role :)
> --
> Muson
>

How create Excel linked server without Security Admin

I need to import excel data to mssql, i am creating linked server and then
selecting from it
Is there a why to create linked server without security admin role or some
other way to import data from excel spreadsheet to MsSQL 2000. It is not
very good security policy to have 10 users with Security administrator
server role
MusonDTS?
"Muson" <nu@.nu.nu> wrote in message
news:ufic8sc8GHA.788@.TK2MSFTNGP05.phx.gbl...
>I need to import excel data to mssql, i am creating linked server and then
>selecting from it
> Is there a why to create linked server without security admin role or some
> other way to import data from excel spreadsheet to MsSQL 2000. It is not
> very good security policy to have 10 users with Security administrator
> server role
> --
> Muson
>|||In SQL Server 2005, you can grant ALTER ANY LINKED SERVER permission, which
allow to execute
sp_addlinkedserver. See below BOL URL:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/fed3adb0-4c15-4a1a-8acd-
1b184aff558f.htm
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Muson" <nu@.nu.nu> wrote in message news:ufic8sc8GHA.788@.TK2MSFTNGP05.phx.gbl...een">
>I need to import excel data to mssql, i am creating linked server and then
selecting from it
> Is there a why to create linked server without security admin role or some
other way to import
> data from excel spreadsheet to MsSQL 2000. It is not very good security po
licy to have 10 users
> with Security administrator server role
> --
> Muson
>

How create Excel linked server without Security Admin

I need to import excel data to mssql, i am creating linked server and then
selecting from it
Is there a why to create linked server without security admin role or some
other way to import data from excel spreadsheet to MsSQL 2000. It is not
very good security policy to have 10 users with Security administrator
server role
Muson
DTS?
"Muson" <nu@.nu.nu> wrote in message
news:ufic8sc8GHA.788@.TK2MSFTNGP05.phx.gbl...
>I need to import excel data to mssql, i am creating linked server and then
>selecting from it
> Is there a why to create linked server without security admin role or some
> other way to import data from excel spreadsheet to MsSQL 2000. It is not
> very good security policy to have 10 users with Security administrator
> server role
> --
> Muson
>
|||In SQL Server 2005, you can grant ALTER ANY LINKED SERVER permission, which allow to execute
sp_addlinkedserver. See below BOL URL:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/fed3adb0-4c15-4a1a-8acd-1b184aff558f.htm
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Muson" <nu@.nu.nu> wrote in message news:ufic8sc8GHA.788@.TK2MSFTNGP05.phx.gbl...
>I need to import excel data to mssql, i am creating linked server and then selecting from it
> Is there a why to create linked server without security admin role or some other way to import
> data from excel spreadsheet to MsSQL 2000. It is not very good security policy to have 10 users
> with Security administrator server role
> --
> Muson
>
sql

How can we RETAIN the Tooltip value shown on report into in Excel Sheet

Is there any way in which i can carry or retain the tooltip value which is shown on my report into Excel sheet ...

i mean when i export the report into Excel sheet, tooltip value is gone?? how can i retain the tooltip value when i export into excel ??

is it possible if so ...any hints? thanks a lot in advance

any thoughts on this...at least can anyone suggest me how to control the export feature of report?? i mean can i write custom rendering events etc?

i really appreciate...if some reply to this thread

How can we RETAIN the Tooltip value shown on report into in Excel

Is there any way in which i can carry or retain the tooltip value which is
shown on my report into Excel sheet ...
i mean when i export the report into Excel sheet, tooltip value is gone'
how can i retain the tooltip value when i export into excel '
thanks a lot in advanceOn May 9, 1:23 pm, Dia <D...@.discussions.microsoft.com> wrote:
> Is there any way in which i can carry or retain the tooltip value which is
> shown on my report into Excel sheet ...
> i mean when i export the report into Excel sheet, tooltip value is gone'
> how can i retain the tooltip value when i export into excel '
> thanks a lot in advance
As far as I know, there is not a way to do this. I believe the only
export format that supports tooltips is Web Archive. Sorry that I
could not be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant