Link to home
Start Free TrialLog in
Avatar of essjaybee
essjaybee

asked on

MS Reporting Services - how to show details horizontally not vertically ?

I am writing my first report using MS Reporting Services.
I have created the report using the wizard and it gives me a basic layout like this:-

Header1
        detail1
        detail2
        detail3
Header2
        detail1
        detail2
Header3
        detail1

Each detail is a very short piece of text but there are a lot of them, making the report long and not that user friendly. How can I get the detail to print horizontally like this instead ?

Header1
        detail1, detail2, detail3
Header2
        detail1, detail2
Header3
        detail1

Is this possible in MS Reporting Services ?
many thanks for your help,

SJ




Deleted by Vee_Mod, no points refunded:  8/6/2008 9:05:18 AM
ASKER CERTIFIED SOLUTION
Avatar of Yurich
Yurich
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Chris McGuigan
Chris McGuigan
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
FYI: https://www.experts-exchange.com/Database/Reporting_/ is the best zone to use for reporting services (SSRS)
Avatar of essjaybee
essjaybee

ASKER

Hi,
Thanks but I tried using the matrix but it didn't fit the data that I had.
Using your example above I don't the dimension of the years.
I only have:-
Alberta
    1234
    2345
    3456
    2456
British Colombia
    6541
    5432
    5489
    3548
Manitoba
    1236
    1532
    1564
    1465
Saskatchewan
    2365
    2645
    2984
     1564

But I want it to look like this:-
Alberta
    1234, 2345, 3456, 2456
British Colombia
    6541, 5432, 5489, 3548
Manitoba
    1236, 1532, 1564, 1465
Saskatchewan
    2365, 2645, 2984, 1564

Do you see what I mean ?
Using the matrix it would let me have nothing across the X axis.
Does anyone else have any ideas ?
Thanks.


SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi Vee_Mod,
Am I missing something here?
I've answered this question! We have a good question/answer session going on here.

Apart from preferring it to be in the SQL Reporting zone, I don't see what's wrong with this thread to warrant deleting it.

Chris
No solution
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
This is getting a little surreal.

In what way did I try and "Self-close" this thread.
All I've done is answer the question.

Thanks for your help.
I'm not quite sure what went on here but the solution from Yurich worked really well, many thanks.
no problem essjaybee,
sanity returned in the form of angelIII.

I think some cross posting was going on?

Glad you got your answer!
The rownumber and ranking functions in SQL are really useful especially for work arounds if you think laterally enough.

Chris
if you want to know...

- vee_mod was trying to get in hold of essjaybee, as he requested to close the call (or not - whatever)

- after a few days vee_mod deleted a question

- I posted in Support area objecting about his/her decision

- S/he said that there is nothing s/he could do else :-0

- I explained, that there was ...

- The question was reopened, forced closed by angelIII, and points distributed

- end of story

Cheers,
Yurich