asked on

Trying to sort and group in ssrs 2008 r2

I am new to ssrs 2008. I am used to Crystal Reports. I am trying to display the following in my report.. (something like this)

order pick location product order qty pick qty
line line
-----------------------------------------------------------------------------------------------------
1 blue shirt 15
13 xxxxx 5
14 xxxx1 6
15 xxxx2 4
----------------------------------------------------------------------------------------------------------
2 green shirt 20
16 yyyyy 10
17 yyyy1 10

I have tried a list and a table and I just can't figure it out?

ASKER CERTIFIED SOLUTION

Howard Cantrell

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

bmorriso99

ASKER

I will try that. Do you know how to make it so that the heading doesn't repeat every time the Order Line # changes? I just want it to display once at the top of the page. But I do want the line to repeat
----------------------------------------------------------------------------------------------------------------

Howard Cantrell

One way would be to place data in the report header only