SQL Server Reporting Services 2005 Show more than one dataset row on the same row

I am using SQL Server reporting services 2005 and need to do the following for a report.  The linked dataset only returns one column for each row. I want to use a table with three columns, the problem being that I need to return three records on the same row within the report.
         Is it possible to do this in the report or do I need to change the stored procedure that it is calling?

Many Thanks
bobsteryAsked:
Who is Participating?
 
adraughnConnect With a Mentor Commented:
oic. why would you want to do that? oh nevermind, i have crazy requirements sometimes too. you will probably have to use a matrix. here is an article on horizontal tables in ssrs:

http://blogs.msdn.com/chrishays/archive/2004/07/23/HorizontalTables.aspx
0
 
bobsteryAuthor Commented:
I thought I'd add an example, in order to fully understand:

Dataset returns one row e.g.

LineID
2543454
2625635
6565567
8676768
8878799
8787878
8787866

I need the report to show the dataset as follows:

item                       item                               item
2543454               2625635                       6565567
8676768               8878799                       8787878
8787866
0
 
adraughnCommented:
what is the criteria that distinguishes why 2625635 belongs in column 2, why 6565567 belongs in column 3, etc.?

adria
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
bobsteryAuthor Commented:
Thats the problem there isn't any I just want each row to show 3 records on the same line in the order of the dataset.

Regards
0
 
bobsteryAuthor Commented:
Its just a saving paper issue.  Thanks for the solution

Brian
0
 
adraughnCommented:
you're welcome.

adria
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.