August 31, 2010 at 1:41 am
Hi All,
I have one SP. This I am not suppose to change. The SP give resultset like
Col1
Col2
type
I am same for Set1
Xyz
A
I am same for Set1
Uvw
B
I am same for Set1
Rst
C
I am same for Set1
Pqr
D
I am same for Set2
…
A
I am same for Set2
…
B
I am same for Set2
…
C
I am same for Set2
…
D
...
…
…
My report will have something like the
first page
--------------
Display Col1,col2 where type=A ßThese are all for SET1
Display Col1,col2 where type=B
Display Col1,col2 where type=C
Display Col1,col2 where type=D
Second page
-----------------
Display Col1,col2 where type=AßThese are all for SET2
Display Col1,col2 where type=B
Display Col1,col2 where type=C
Display Col1,col2 where type=D
How to achieve this?
Thanks
Rajesh Vaswani
August 31, 2010 at 7:54 am
I think some basic SSRS grouping would solve your problem
Col1 & Col2 are your detail
They are grouped by Type
Type is grouped by Set.
They would look something like this
Set1
--Type
----Col1, col2
--Type
----Col1, col2
etc.
Set2
--Type
----Col1, col2
--Type
----Col1, col2
September 1, 2010 at 6:00 am
Thanks Mr. or Mrs. 500
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply