How do I add a single column heading row in the detail section?

Could somebody please tell me how to do this?
I've created a report with the wizard that lists Managers. You toggle
a Manager and a detail section of employees opens for that Manager. I
want to put a row of column names at the top of the detail section when
it's opened (not showing when the detail is closed). I've succeeded in
adding a row that shows above each detail record, but that's not what I
want. I just want a single row of column headings.
I've tried looking everywhere, including the Help system, and I can't
find how to do this. Probably simple, right?
Thanks, JulieHi Julie,
Highlight the Managers group, right click and select Insert Row Below.
That will add another row for that group, but since the group only gets
repeated once for each manager this is what you want. Toggle this new
row on the Manager and you're good to go.
take care,
Michelle|||Michelle, thank you, that's what I've been trying to do. That just
leaves me to figure out how to hide this new detail header when the
Manager group is not toggled. Setting the visibility of the detail
header to False makes it invisible all the time. I want it to become
visible when the Manager is toggled, and only for any Manager(s)
toggled.
Michelle wrote:
> Hi Julie,
> Highlight the Managers group, right click and select Insert Row
Below.
> That will add another row for that group, but since the group only
gets
> repeated once for each manager this is what you want. Toggle this
new
> row on the Manager and you're good to go.
> take care,
> Michellesql

How can I tell which SP is in error when trying to Export?

I am trying to Export a database to another using the export wizard. It
states that it found an invalid column name on one of the stored procedures
but doesn't say WHICH strored procedure, which is problematic since there
are nearly a thousand of them.
Does anyone know how to tell which sp is in error?"Tom" <nfr@.nospam.com> wrote in message
news:uyu4zBFOEHA.204@.TK2MSFTNGP10.phx.gbl...
> I am trying to Export a database to another using the export wizard. It
> states that it found an invalid column name on one of the stored
procedures
> but doesn't say WHICH strored procedure, which is problematic since there
> are nearly a thousand of them.
> Does anyone know how to tell which sp is in error?
There must be Details button I think...
Else it is safe to generate script of all of your procedures (Select them in
EM - all tasks -> generate script) and run it on same database from Query
Analyzer - you will see what is the exact error and where.
Bojidar Alexandrov

How can I tell which SP is in error when trying to Export?

I am trying to Export a database to another using the export wizard. It
states that it found an invalid column name on one of the stored procedures
but doesn't say WHICH strored procedure, which is problematic since there
are nearly a thousand of them.
Does anyone know how to tell which sp is in error?"Tom" <nfr@.nospam.com> wrote in message
news:uyu4zBFOEHA.204@.TK2MSFTNGP10.phx.gbl...
> I am trying to Export a database to another using the export wizard. It
> states that it found an invalid column name on one of the stored
procedures
> but doesn't say WHICH strored procedure, which is problematic since there
> are nearly a thousand of them.
> Does anyone know how to tell which sp is in error?
There must be Details button I think...
Else it is safe to generate script of all of your procedures (Select them in
EM - all tasks -> generate script) and run it on same database from Query
Analyzer - you will see what is the exact error and where.
Bojidar Alexandrov

How can I tell which SP is in error when trying to Export?

I am trying to Export a database to another using the export wizard. It
states that it found an invalid column name on one of the stored procedures
but doesn't say WHICH strored procedure, which is problematic since there
are nearly a thousand of them.
Does anyone know how to tell which sp is in error?
"Tom" <nfr@.nospam.com> wrote in message
news:uyu4zBFOEHA.204@.TK2MSFTNGP10.phx.gbl...
> I am trying to Export a database to another using the export wizard. It
> states that it found an invalid column name on one of the stored
procedures
> but doesn't say WHICH strored procedure, which is problematic since there
> are nearly a thousand of them.
> Does anyone know how to tell which sp is in error?
There must be Details button I think...
Else it is safe to generate script of all of your procedures (Select them in
EM - all tasks -> generate script) and run it on same database from Query
Analyzer - you will see what is the exact error and where.
Bojidar Alexandrov