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 come i can't add a domain user?

how come when i try to add a domain user/group i get this error:
Error 15401: Windows NT user or group 'MYDOMAIN\Domain Users' not found.
Check the name again.Hi,
See the reply from Bill from a old postregarding the same issue.
Hi Biva,
I see this is a complex problem as usually the suggestions should work.
The Enterprise Manager will use sp_grantlogin to grant permissions. When we
use sp_grantlogin to grant the permissions to a NT User, the stored
procedure calls
LookupAccountSid function and that function looks in the SID cache on the
local
computer before it goes to a domain controller. If the SID in the cache is
incorrect, then the problem would occur. This problem may occur if we
rename the User account. As far as I know, the only method is to reboot the
computer. However, you may check with Windows 2000 newsgroups for
suggestions, e.g. microsoft.public.win2000.gener­al,
microsoft.public.win2000.activ­e_directory.
In addition, this indicates that domain names are not resolved properly.
Please check in Administators Group in Computer Management. If domains
accounts that are members 'ARE NOT' showing up like this,
domain\account
Instead, they show up as a long string of numbers, then it indicates that
it is not resolved properly. Please check with Windows 2000 newsgroups to
see if they have any suggestions.
This posting is provided "AS IS" with no warranties, and confers no rights.
Regards,
Bill Cheng
Microsoft Support Engineer
Thanks
Hari
"James" <See.My.Sig@.The.Bottom.com> wrote in message
news:s1wIe.13389$Bx5.11303@.trnddc09...
> how come when i try to add a domain user/group i get this error:
> Error 15401: Windows NT user or group 'MYDOMAIN\Domain Users' not found.
> Check the name again.
>
>|||thank you, i found my problem tho, i needed to apply ISA 2004 standard
server's service pack 1. isa doesn't like win2003's sp1... isa's firewall
was stoping rpc.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OTxmREUmFHA.2852@.TK2MSFTNGP15.phx.gbl...
> Hi,
> See the reply from Bill from a old postregarding the same issue.
> Hi Biva,
>
> I see this is a complex problem as usually the suggestions should work.
>
> The Enterprise Manager will use sp_grantlogin to grant permissions. When
> we
> use sp_grantlogin to grant the permissions to a NT User, the stored
> procedure calls
> LookupAccountSid function and that function looks in the SID cache on the
> local
> computer before it goes to a domain controller. If the SID in the cache is
> incorrect, then the problem would occur. This problem may occur if we
> rename the User account. As far as I know, the only method is to reboot
> the
> computer. However, you may check with Windows 2000 newsgroups for
> suggestions, e.g. microsoft.public.win2000.gener­al,
> microsoft.public.win2000.activ­e_directory.
>
> In addition, this indicates that domain names are not resolved properly.
> Please check in Administators Group in Computer Management. If domains
> accounts that are members 'ARE NOT' showing up like this,
> domain\account
>
> Instead, they show up as a long string of numbers, then it indicates that
> it is not resolved properly. Please check with Windows 2000 newsgroups to
> see if they have any suggestions.
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> Regards,
>
> Bill Cheng
> Microsoft Support Engineer
>
> Thanks
> Hari
> "James" <See.My.Sig@.The.Bottom.com> wrote in message
> news:s1wIe.13389$Bx5.11303@.trnddc09...
>> how come when i try to add a domain user/group i get this error:
>> Error 15401: Windows NT user or group 'MYDOMAIN\Domain Users' not found.
>> Check the name again.
>>
>>
>

How come i can't add a domain user?

how come when i try to add a domain user/group i get this error:
Error 15401: Windows NT user or group 'MYDOMAIN\Domain Users' not found.
Check the name again.Hi,
See the reply from Bill from a old postregarding the same issue.
Hi Biva,
I see this is a complex problem as usually the suggestions should work.
The Enterprise Manager will use sp_grantlogin to grant permissions. When we
use sp_grantlogin to grant the permissions to a NT User, the stored
procedure calls
LookupAccountSid function and that function looks in the SID cache on the
local
computer before it goes to a domain controller. If the SID in the cache is
incorrect, then the problem would occur. This problem may occur if we
rename the User account. As far as I know, the only method is to reboot the
computer. However, you may check with Windows 2000 newsgroups for
suggestions, e.g. microsoft.public.win2000.gener_al,
microsoft.public.win2000.activ_e_directory.
In addition, this indicates that domain names are not resolved properly.
Please check in Administators Group in Computer Management. If domains
accounts that are members 'ARE NOT' showing up like this,
domain\account
Instead, they show up as a long string of numbers, then it indicates that
it is not resolved properly. Please check with Windows 2000 newsgroups to
see if they have any suggestions.
This posting is provided "AS IS" with no warranties, and confers no rights.
Regards,
Bill Cheng
Microsoft Support Engineer
Thanks
Hari
"James" <See.My.Sig@.The.Bottom.com> wrote in message
news:s1wIe.13389$Bx5.11303@.trnddc09...
> how come when i try to add a domain user/group i get this error:
> Error 15401: Windows NT user or group 'MYDOMAIN\Domain Users' not found.
> Check the name again.
>
>|||thank you, i found my problem tho, i needed to apply ISA 2004 standard
server's service pack 1. ISA doesn't like win2003's sp1... isa's firewall
was stoping rpc.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OTxmREUmFHA.2852@.TK2MSFTNGP15.phx.gbl...
> Hi,
> See the reply from Bill from a old postregarding the same issue.
> Hi Biva,
>
> I see this is a complex problem as usually the suggestions should work.
>
> The Enterprise Manager will use sp_grantlogin to grant permissions. When
> we
> use sp_grantlogin to grant the permissions to a NT User, the stored
> procedure calls
> LookupAccountSid function and that function looks in the SID cache on the
> local
> computer before it goes to a domain controller. If the SID in the cache is
> incorrect, then the problem would occur. This problem may occur if we
> rename the User account. As far as I know, the only method is to reboot
> the
> computer. However, you may check with Windows 2000 newsgroups for
> suggestions, e.g. microsoft.public.win2000.gener_al,
> microsoft.public.win2000.activ_e_directory.
>
> In addition, this indicates that domain names are not resolved properly.
> Please check in Administators Group in Computer Management. If domains
> accounts that are members 'ARE NOT' showing up like this,
> domain\account
>
> Instead, they show up as a long string of numbers, then it indicates that
> it is not resolved properly. Please check with Windows 2000 newsgroups to
> see if they have any suggestions.
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> Regards,
>
> Bill Cheng
> Microsoft Support Engineer
>
> Thanks
> Hari
> "James" <See.My.Sig@.The.Bottom.com> wrote in message
> news:s1wIe.13389$Bx5.11303@.trnddc09...
>

How come i can't add a domain user?

how come when i try to add a domain user/group i get this error:
Error 15401: Windows NT user or group 'MYDOMAIN\Domain Users' not found.
Check the name again.
Hi,
See the reply from Bill from a old postregarding the same issue.
Hi Biva,
I see this is a complex problem as usually the suggestions should work.
The Enterprise Manager will use sp_grantlogin to grant permissions. When we
use sp_grantlogin to grant the permissions to a NT User, the stored
procedure calls
LookupAccountSid function and that function looks in the SID cache on the
local
computer before it goes to a domain controller. If the SID in the cache is
incorrect, then the problem would occur. This problem may occur if we
rename the User account. As far as I know, the only method is to reboot the
computer. However, you may check with Windows 2000 newsgroups for
suggestions, e.g. microsoft.public.win2000.generXal,
microsoft.public.win2000.activXe_directory.
In addition, this indicates that domain names are not resolved properly.
Please check in Administators Group in Computer Management. If domains
accounts that are members 'ARE NOT' showing up like this,
domain\account
Instead, they show up as a long string of numbers, then it indicates that
it is not resolved properly. Please check with Windows 2000 newsgroups to
see if they have any suggestions.
This posting is provided "AS IS" with no warranties, and confers no rights.
Regards,
Bill Cheng
Microsoft Support Engineer
Thanks
Hari
"James" <See.My.Sig@.The.Bottom.com> wrote in message
news:s1wIe.13389$Bx5.11303@.trnddc09...
> how come when i try to add a domain user/group i get this error:
> Error 15401: Windows NT user or group 'MYDOMAIN\Domain Users' not found.
> Check the name again.
>
>
|||thank you, i found my problem tho, i needed to apply ISA 2004 standard
server's service pack 1. isa doesn't like win2003's sp1... isa's firewall
was stoping rpc.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OTxmREUmFHA.2852@.TK2MSFTNGP15.phx.gbl...
> Hi,
> See the reply from Bill from a old postregarding the same issue.
> Hi Biva,
>
> I see this is a complex problem as usually the suggestions should work.
>
> The Enterprise Manager will use sp_grantlogin to grant permissions. When
> we
> use sp_grantlogin to grant the permissions to a NT User, the stored
> procedure calls
> LookupAccountSid function and that function looks in the SID cache on the
> local
> computer before it goes to a domain controller. If the SID in the cache is
> incorrect, then the problem would occur. This problem may occur if we
> rename the User account. As far as I know, the only method is to reboot
> the
> computer. However, you may check with Windows 2000 newsgroups for
> suggestions, e.g. microsoft.public.win2000.generXal,
> microsoft.public.win2000.activXe_directory.
>
> In addition, this indicates that domain names are not resolved properly.
> Please check in Administators Group in Computer Management. If domains
> accounts that are members 'ARE NOT' showing up like this,
> domain\account
>
> Instead, they show up as a long string of numbers, then it indicates that
> it is not resolved properly. Please check with Windows 2000 newsgroups to
> see if they have any suggestions.
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> Regards,
>
> Bill Cheng
> Microsoft Support Engineer
>
> Thanks
> Hari
> "James" <See.My.Sig@.The.Bottom.com> wrote in message
> news:s1wIe.13389$Bx5.11303@.trnddc09...
>

How can you tell whether a DB is corrupt?

Hi group,
is the corruption of a database always associated with its being not able to
be accessed? If not, how can one tell, so that one can deal with the
corruption?
QS
You can run the DBCC commands to check the integrity of the database. See
DBCC CHECKDB in Books Online to start with.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Question on SQL" <qs@.who.com> wrote in message
news:uwDzqaihEHA.2540@.TK2MSFTNGP10.phx.gbl...
Hi group,
is the corruption of a database always associated with its being not able to
be accessed? If not, how can one tell, so that one can deal with the
corruption?
QS
|||Hi,
Most of the corruptions allow you to access the database. The error will
only come while you access the corruption part.
The corruption can be identified by running.
DBCC CHECKDB('dbname')
Thanks
Hari
MCDBA
"Question on SQL" <qs@.who.com> wrote in message
news:uwDzqaihEHA.2540@.TK2MSFTNGP10.phx.gbl...
> Hi group,
> is the corruption of a database always associated with its being not able
to
> be accessed? If not, how can one tell, so that one can deal with the
> corruption?
> QS
>
|||Thank you both for the response.
QS
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uF5xkdnhEHA.3632@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Hi,
> Most of the corruptions allow you to access the database. The error will
> only come while you access the corruption part.
> The corruption can be identified by running.
> DBCC CHECKDB('dbname')
> Thanks
> Hari
> MCDBA
> "Question on SQL" <qs@.who.com> wrote in message
> news:uwDzqaihEHA.2540@.TK2MSFTNGP10.phx.gbl...
able
> to
>

How can you tell whether a DB is corrupt?

Hi group,
is the corruption of a database always associated with its being not able to
be accessed? If not, how can one tell, so that one can deal with the
corruption?
QSYou can run the DBCC commands to check the integrity of the database. See
DBCC CHECKDB in Books Online to start with.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Question on SQL" <qs@.who.com> wrote in message
news:uwDzqaihEHA.2540@.TK2MSFTNGP10.phx.gbl...
Hi group,
is the corruption of a database always associated with its being not able to
be accessed? If not, how can one tell, so that one can deal with the
corruption?
QS|||Hi,
Most of the corruptions allow you to access the database. The error will
only come while you access the corruption part.
The corruption can be identified by running.
DBCC CHECKDB('dbname')
Thanks
Hari
MCDBA
"Question on SQL" <qs@.who.com> wrote in message
news:uwDzqaihEHA.2540@.TK2MSFTNGP10.phx.gbl...
> Hi group,
> is the corruption of a database always associated with its being not able
to
> be accessed? If not, how can one tell, so that one can deal with the
> corruption?
> QS
>|||Thank you both for the response.
QS
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uF5xkdnhEHA.3632@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Most of the corruptions allow you to access the database. The error will
> only come while you access the corruption part.
> The corruption can be identified by running.
> DBCC CHECKDB('dbname')
> Thanks
> Hari
> MCDBA
> "Question on SQL" <qs@.who.com> wrote in message
> news:uwDzqaihEHA.2540@.TK2MSFTNGP10.phx.gbl...
able[vbcol=seagreen]
> to
>

How can you tell whether a DB is corrupt?

Hi group,
is the corruption of a database always associated with its being not able to
be accessed? If not, how can one tell, so that one can deal with the
corruption?
QSYou can run the DBCC commands to check the integrity of the database. See
DBCC CHECKDB in Books Online to start with.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Question on SQL" <qs@.who.com> wrote in message
news:uwDzqaihEHA.2540@.TK2MSFTNGP10.phx.gbl...
Hi group,
is the corruption of a database always associated with its being not able to
be accessed? If not, how can one tell, so that one can deal with the
corruption?
QS|||Hi,
Most of the corruptions allow you to access the database. The error will
only come while you access the corruption part.
The corruption can be identified by running.
DBCC CHECKDB('dbname')
Thanks
Hari
MCDBA
"Question on SQL" <qs@.who.com> wrote in message
news:uwDzqaihEHA.2540@.TK2MSFTNGP10.phx.gbl...
> Hi group,
> is the corruption of a database always associated with its being not able
to
> be accessed? If not, how can one tell, so that one can deal with the
> corruption?
> QS
>|||Thank you both for the response.
QS
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uF5xkdnhEHA.3632@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Most of the corruptions allow you to access the database. The error will
> only come while you access the corruption part.
> The corruption can be identified by running.
> DBCC CHECKDB('dbname')
> Thanks
> Hari
> MCDBA
> "Question on SQL" <qs@.who.com> wrote in message
> news:uwDzqaihEHA.2540@.TK2MSFTNGP10.phx.gbl...
> > Hi group,
> >
> > is the corruption of a database always associated with its being not
able
> to
> > be accessed? If not, how can one tell, so that one can deal with the
> > corruption?
> >
> > QS
> >
> >
>