Link to home
Start Free TrialLog in
Avatar of bobstery
bobstery

asked on

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
Avatar of bobstery
bobstery

ASKER

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
Avatar of adraughn
adraughn
Flag of United States of America image
what is the criteria that distinguishes why 2625635 belongs in column 2, why 6565567 belongs in column 3, etc.?

adria
Avatar of bobstery
bobstery

ASKER

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
ASKER CERTIFIED SOLUTION
Avatar of adraughn
adraughn
Flag of United States of America 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
Avatar of bobstery
bobstery

ASKER

Its just a saving paper issue.  Thanks for the solution

Brian
Avatar of adraughn
adraughn
Flag of United States of America image
you're welcome.

adria