November 28, 2011 at 12:29 am
Hi guys and girls
I presently have a table for which the data is displayed as the following:
G P A
1:04 |15 34 |5.1
01:04 |150 9 |13.5
01:04 |25 14 |3.5
01:04 |250 7 |17.5
01:04 |35 13 |4.55
01:04 |45 13 |5.85
01:04 |55 23 |12.65
01:04 |550 |4 22
01:10 |125 |2 2.5
01:10 |125 |2 2.5
01:25 |75 |2 1.5
A |HWH 75 | 9 6.75
B |55 |8 4.4
C |attrak 55 |5 2.75
Is there some clever person among you that can display the data like the following: Next to each other grouped as rows of fours(4).
G P A G P A G P A G P A
01:04 |15 34 |5.1 01:04 |35 13 |4.55 01:10 |125 |2 2.5 01:25 |75 |2 1.5
01:04 |150 9 |13.5 01:04 |45 13 |5.85 01:10 |125 |2 2.5 A |HWH 75 | 9 6.75
01:04 |25 14 |3.5 01:04 |55 23 |12.65 01:10 |75 |2 1.5 B |55 |8 4.4
01:04 |250 7 |17.5 01:04 |550 |4 22 01:25 |125 |2 2.5 C |attrak 55 |5 2.75
...
Kind regards and thank you for your assistance.
Fred
P.S. This is the code I use to generate the above code in ssrs:
SELECT orbpd.BettingPoolNumber
,orbpd.[Name] + ' ' + CONVERT(NVARCHAR(MAX),(orbpd.BettingAmountPerPigeonOrPigeonGroup * 100)) AS G
,orbpd.[RaceId]
,orbpd.[OrganizationId]
,orbpd.[OrganizationHierarchyId]
,[TotalPoolAmount] AS A
,(SELECT SUM(NumberOfPigeonsPooled)
FROM MemberRaceBettingPoolData
WHERE RaceId = orbpd.[RaceId]
AND LevelNumber = o.[OrganizationBettingPoolLevelNo]
AND PoolNumber = orbpd.[BettingPoolNumber]) AS P
FROM [OrganizationRaceBettingPoolData] orbpd
INNER JOIN [Organization] o
ON orbpd.[OrganizationId] = o.[OrganizationId]
AND orbpd.[OrganizationHierarchyId] = o.[OrganizationHierarchyId]
WHERE orbpd.RaceId=@RaceId
AND orbpd.OrganizationId=@OrganizationID
November 28, 2011 at 2:00 am
duplicate post, please direct answer to here http://www.sqlservercentral.com/Forums/Topic1211822-391-1.aspx
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply