SSRS 2000 display resultset data

[scabral79]

Hi,

i am new to SSRS so this might seem like a dumb question, but if i have result set that looks like this:

LineItemID LineItemDescription LineItemCount
40 Trust Line of Business 2
65 US Government Entity 40
115 Non-US Bank 11
160 Private Label ATM 120
.
.
.

How do i bind this data to the report in the order that i want with headings in between some of the sections, as follows:

Report Label 1
Trust Line of Business 2
Non US Bank 11
-------------------------------------
SubTotal 13

Report Label 2
Private Label ATM 120
Trust Line of Business 2
--------------------------------------
Subtotal 122

and so on down the report....

is there a way to do this? I was kind of confused as to whether i could use a table control or list control or just throw the fields on a blank form. Neither way seems to be working for me right now.

thanks
Scott

 

[xlbo]

You need to create some form of grouping (preferably in the SQL dataset) that tells SSRS which groups the Line Items belong to - you can then use either a list control or a table to group the data together and create your headings and layout

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question