How to show line numbers in the first column of the report

Hi,
I want to show line numbers on report page in the first column of my
report. I am working on microsoft reporting services 2000.
How i can do this.
Regards
DineshOn Mar 9, 11:59 pm, "Dinesh" <dinesh...@.gmail.com> wrote:
> Hi,
> I want to show line numbers on report page in the first column of my
> report. I am working on microsoft reporting services 2000.
> How i can do this.
> Regards
> Dinesh
This should work: =RowNumber("DataSourceName") as an expression in the
Value property of the first column.
Regards,
Enrique Martinez
Sr. SQL Server Developer

How to show a line between table column headers and the details

I am using table object to present report.

table row1 has all the column names and table row2 has the data.

How can i put a horizontal line between column names and the data rows.

Thank you very much.

Would adding a solid border to the bottom of the row having the column headers in it work?

Jarret

How to set SQL Profiler via command line

Hello,

How can I set SQL Profiler to capture the logs via command line?

This is what I have:

I already have a SQL Profiler Template (fooTemplate.tdf) which tells what I need SQL to capture.

C:\>"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\PROFILER90.EXE" /Sfoo /Dfoo /E /T"c:\fooTemplate.tdf" /Oc:\mysql.out

What other parameters am I missing?

Thanks!

J

Trace automation is done with the sp_trace_create and it's assocciated procedures, not through the profiler gui.

Books Online: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/fd605a61-ade1-49d6-8174-cbe789b6d342.htm

How to set SQL Profiler via command line

Hello,

How can I set SQL Profiler to capture the logs via command line?

This is what I have:

I already have a SQL Profiler Template (fooTemplate.tdf) which tells what I need SQL to capture.

C:\>"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\PROFILER90.EXE" /Sfoo /Dfoo /E /T"c:\fooTemplate.tdf" /Oc:\mysql.out

What other parameters am I missing?

Thanks!

J

Trace automation is done with the sp_trace_create and it's assocciated procedures, not through the profiler gui.

Books Online: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/fd605a61-ade1-49d6-8174-cbe789b6d342.htm

|||How about if the SQL Server I used is 2000, I've checked it b4 but cannot find the Profiler90.exe, only Profiler.exe is exist which don't hv output file path I can specified. Pls help. Thanks.|||

Please read the following to find out how to monitor SQL Server using Profiler Traces.

http://yukonspace.blogspot.com/2007/09/server-side-profiler-traces.html

The EXE for SQL Server 2000 Profiler is Profiler.exe and for SQL Server 2005 is Profiler90.exe

How to set SQL Profiler via command line

Hello,

How can I set SQL Profiler to capture the logs via command line?

This is what I have:

I already have a SQL Profiler Template (fooTemplate.tdf) which tells what I need SQL to capture.

C:\>"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\PROFILER90.EXE" /Sfoo /Dfoo /E /T"c:\fooTemplate.tdf" /Oc:\mysql.out

What other parameters am I missing?

Thanks!

J

Trace automation is done with the sp_trace_create and it's assocciated procedures, not through the profiler gui.

Books Online: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/fd605a61-ade1-49d6-8174-cbe789b6d342.htm

|||How about if the SQL Server I used is 2000, I've checked it b4 but cannot find the Profiler90.exe, only Profiler.exe is exist which don't hv output file path I can specified. Pls help. Thanks.|||

Please read the following to find out how to monitor SQL Server using Profiler Traces.

http://yukonspace.blogspot.com/2007/09/server-side-profiler-traces.html

The EXE for SQL Server 2000 Profiler is Profiler.exe and for SQL Server 2005 is Profiler90.exe

How to set SQL Profiler via command line

Hello,
How can I set SQL Profiler to capture the logs via command line? I wanted to
this just before my testing.
This is what I have:
I already have a SQL Profiler Template (fooTemplate.tdf) which tells what I
need SQL to capture.
C:\>"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\PROFILER90.EXE"
/Sfoo /Dfoo /E /T"c:\fooTemplate.tdf" /Oc:\mysql.out
What other parameters am I missing?
Thanks!
Read the below article about server side tracing.
http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm
http://www.dbazine.com/sql/sql-articles/larsen6
THanks
Hari
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OThA6%23tZHHA.1388@.TK2MSFTNGP05.phx.gbl...
> Read up on "Server Side Trace".
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "MS" <MS@.discussions.microsoft.com> wrote in message
> news:301D495F-1B3F-4694-B9CA-6A3417F7CDEF@.microsoft.com...
>
|||On 15 Mar, 14:14, "Hari Prasad" <hari_prasa...@.hotmail.com> wrote:
> Read the below article aboutserverside tracing.
> http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm
> http://www.dbazine.com/sql/sql-articles/larsen6
> THanks
> Hari
> "Tibor Karaszi" <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote in
> messagenews:OThA6%23tZHHA.1388@.TK2MSFTNGP05.phx.gb l...
>
>
>
>
>
>
> - Show quoted text -
That was very useful.. Thanks hari..
-PrasannaKRao