SQL Server Reporting Services - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

SQL Server Reporting Services

Author

Topic

Dev@nlkss

134 Posts

Posted - 2008-12-11 : 06:18:26

Hi All,
I am using SQL Server Reporting Services first time;
I have some queries

1.How can i display records in grid format
2.What is the use of Pointer,Line and List Controls.
3.How to Generate Sequence Number at report layout

plz help me.
thanks in advance.

Satya

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-11 : 09:59:13

1.use table or matrix container from toolbox
2.line is drawing lines usually used to seperate sections in report or for border,list is used to align lots of tables,matrices,textboxes...
3.use RowNumber() function available in SSRS

Dev@nlkss

134 Posts

Posted - 2008-12-12 : 00:37:16

Hi Visakh,
i am using Table and matrix controls only but not getting in grid format like horizantal and vertial lines
and for RowNumber() its working for groups how can i use it for individual rows.

Satya

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-12 : 09:41:08

quote:
Originally posted by satya@imi

Hi Visakh,
i am using Table and matrix controls only but not getting in grid format like horizantal and vertial lines
and for RowNumber() its working for groups how can i use it for individual rows.

Satya

format like horizontal & vertical lines?? what does that mean?
just give rownumber("your dataset name") or RowNumber(Nothing) for detail rows

Dev@nlkss

134 Posts

Posted - 2008-12-13 : 00:17:45

Hi visakh,
thanks for reply
RowNumber() is working perfectly
and i want to separate each detail row with line and even for header and footer too,Is it possible using line controle.
and how can use subscription option.
ThanQ.

Satya

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-13 : 00:46:20

quote:
Originally posted by satya@imi

Hi visakh,
thanks for reply
RowNumber() is working perfectly
and i want to separate each detail row with line and even for header and footer too,Is it possible using line controle.
and how can use subscription option.
ThanQ.

Satya

for seperating all detail rows and header/footer with line the best way to do is to set cell border style as solid with 1pt and set border color as black.
for setting subscriptions see this

http://www.codeproject.com/KB/reporting-services/reportsthrusubs.aspx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources