?
Solved

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

Posted on 2007-08-03
6
Medium Priority
?
766 Views
Last Modified: 2008-01-09
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
0
Comment
Question by:bobstery
  • 3
  • 3
6 Comments
 

Author Comment

by:bobstery
ID: 19624617
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
 
LVL 13

Expert Comment

by:adraughn
ID: 19625678
what is the criteria that distinguishes why 2625635 belongs in column 2, why 6565567 belongs in column 3, etc.?

adria
0
 

Author Comment

by:bobstery
ID: 19625714
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 13

Accepted Solution

by:
adraughn earned 1000 total points
ID: 19625918
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
 

Author Comment

by:bobstery
ID: 19626164
Its just a saving paper issue.  Thanks for the solution

Brian
0
 
LVL 13

Expert Comment

by:adraughn
ID: 19626342
you're welcome.

adria
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question