Help On Ssrs Reports ..

[rapchik]

I have labels in this format


[left]James Smith[/left]
[left]12345 Martin Luther King[/left]
[left]Seattle, WA[/left]

[left]Michael Allen[/left]
[left]8764 5th Ave[/left]
[left]Redmond, WA[/left]

[left]Becky Miller[/left]
[left]7704 25th Ave NE[/left]
[left]Bellevue, WA[/left]


[left]Want to show it in horizontal format [/left]


[left]James Smith Michael Allen Becky Miller[/left]
[left]12345 Martin Luther King 8764 5th Ave 7704 25th Ave NE[/left]
[left]Seattle, WA Redmond, WA Bellevue, WA [/left]

[left]I did do columns to 3 and see the result but it doesnt show up [/left]

[ghazni]

u mean dynamic....

[rapchik]

[quote name='ghazni' timestamp='1349205668' post='1302573825']
u mean dynamic....
[/quote]
I am using Report Builder tool to generate labels ....so these labels are genrated vertically by defauly...so need to change them and make them show in horizontal format when they print on pdf

[Guillaume]

shame to shame doubt

http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/4a4e8d8c-6ed4-4c21-85c8-ec2ac44b8341/

[cherlapalli_jailer]

[quote name='Guillaume' timestamp='1349206533' post='1302573889']
shame to shame doubt

[url="http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/4a4e8d8c-6ed4-4c21-85c8-ec2ac44b8341/"]http://social.msdn.m...8-ec2ac44b8341/[/url]
[/quote]


Good :Post

[ghazni]

[quote name='ReddyGaru' timestamp='1349206342' post='1302573873']
I am using Report Builder tool to generate labels ....so these labels are genrated vertically by defauly...so need to change them and make them show in horizontal format when they print on pdf
[/quote]
'report builder 2 or 3 version.

[rapchik]

[quote name='Guillaume' timestamp='1349206533' post='1302573889']
shame to shame doubt

[url="http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/4a4e8d8c-6ed4-4c21-85c8-ec2ac44b8341/"]http://social.msdn.m...8-ec2ac44b8341/[/url]
[/quote]

chusanu bhayya...andhulu horizontal to vertical anadu...nadhi reverse....adhi workout kavatledhu na case lo
[quote name='ghazni' timestamp='1349206986' post='1302573929']
'report builder 2 or 3 version.
[/quote]

report builder 3

[karna11]

Callin MKTR

[pavan_613]

[ghazni]

[quote name='CITI' timestamp='1349220967' post='1302574940']

[/quote]
y laughing.........

[pavan_613]

[quote name='ghazni' timestamp='1349221046' post='1302574948']
y laughing.........
[/quote]

ahh masteruu kiii ee post eyy ekkuva ....Thanu naaku thelusu leyy

[deals2buy]

SQL Server 2012 lo aithe PIVOT ani edo function undi ga

nenu fedda exfert ni kaanu SQL lo

[deals2buy]

Ee example chudu bhayyo:

[font="Verdana, Arial, Helvetica"][font="Verdana, Arial, Helvetica"][size="2"][color="midnightblue"]Table A

JobID Time(in minutes) Record
1 0:15 2.1
1 0:30 0.1
1 0:45 5.4
2 0:15 2.5
2 0:30 0.7
2 0:45 4.6

I want to achieve the following.

Table B

JobID 0:15 0:30 0:45
1 2.1 0.1 5.4
2 2.5 0.7 4.6[/color][/size][/font][/font]


[font="Verdana, Arial, Helvetica"][font="Verdana, Arial, Helvetica"][size="2"][color="midnightblue"]SELECT jobid, [0:15], [0:30] ,[0:45]
FROM
(SELECT jobid, timemin, record
FROM @t ) ps
PIVOT
(
MAX(record)
FOR timemin IN
( [0:15], [0:30], [0:45])
) AS pvt[/color][/size][/font][/font]

[rapchik]

LTT

[ghazni]

exact ga teliyadam ledu mama ni problem....... ipudu report builder lo aa columns ni ni rows ga chudala..........