Help On Ssrs Reports ..

[rapchik]

[quote name='Little Star' timestamp='1349399169' post='1302583957']
Select * from All Turn Horizontal to Vertical
[/quote]ninu upside down turn chestha [img]http://lh5.ggpht.com/-_AnUjozgVbw/UEJ8xUZw-YI/AAAAAAAA27A/Boit67oQ4JA/s223/1.gif[/img]
[quote name='ghazni' timestamp='1349395874' post='1302583753']

matrix try chesava.........
[/quote]

chesanu bhayya..last ki LIST peti chesi ee expresion tho element nate chesanu...=Fields!RNUM.Value mod 3

thanks for ur support [img]http://lh5.ggpht.com/-H5iLUxrQTfM/TwH5mwaIhtI/AAAAAAAAFsg/tbVvKFrkbmo/s150/Obama-1.gif[/img]

[deals2buy]

[quote name='mtkr' timestamp='1349398304' post='1302583910']
[img]http://oi47.tinypic.com/nd9ddy.jpg[/img]
[/quote]

emo naaku SSRS asalu raadu..idi tool use chesi chesava? query em undada?
[quote name='Little Star' timestamp='1349399169' post='1302583957']
Select * from All Turn Horizontal to Vertical
[/quote]




@Reddy garu: adi query unte post cheyyava mama

[mtkr]

[quote name='ReddyGaru' timestamp='1349400049' post='1302584012']
Adhe bhayya

LIst tesukoni andhulo elements ani alane 3 list prepreare chesa...and elemenated each one by below expression.

=Fields!RNUM.Value mod 3


[/quote]

adi expression lo used aaa!!! r visibility property lonaa???

nen idi use visibility prop lo...


frst list lo..
=iif(RowNumber("DataSet1")<4,False,True)
=iif((RowNumber("dataset1")>9) and (RowNumber("dataset1")<12),False,True)

secnd lo...

=iif((RowNumber("dataset1")>3) and (RowNumber("dataset1")<7),False,True)

[mtkr]

[quote name='deals2buy' timestamp='1349400825' post='1302584059']
emo naaku SSRS asalu raadu..idi tool use chesi chesava? query em undada?



[/quote]


query untadi mama.....

[mtkr]

[quote name='Little Star' timestamp='1349399169' post='1302583957']
Select * from All Turn Horizontal to Vertical
[/quote]
em chepparu guruvugaaruuu.....

[deals2buy]

[quote name='mtkr' timestamp='1349404356' post='1302584247']
adi expression lo used aaa!!! r visibility property lonaa???

nen idi use visibility prop lo...


frst list lo..
=iif(RowNumber("DataSet1")<4,False,True)
=iif((RowNumber("dataset1")>9) and (RowNumber("dataset1")<12),False,True)

secnd lo...

=iif((RowNumber("dataset1")>3) and (RowNumber("dataset1")<7),False,True)
[/quote]


for the query

[mtkr]

[quote name='deals2buy' timestamp='1349404719' post='1302584267']


for the query
[/quote]

but idi lengthy process mama...
column lo rec ekkuva unte idi wrk out avvadhu emooo..... konni recs e aithe we r good...

reddysaab cheppindhi try chesthe error ostundhiii...

[ghazni]

nenu ee post open chestey na browser motham struck avtundi enduku....... plug ins ani break avtunayi........

[mtkr]

[quote name='ghazni' timestamp='1349404938' post='1302584278']
nenu ee post open chestey na browser motham struck avtundi enduku....... plug ins ani break avtunayi........
[/quote]
neek only e thrd... naak AFDB motham...

[rapchik]

[quote name='mtkr' timestamp='1349404938' post='1302584277']
but idi lengthy process mama...
column lo rec ekkuva unte idi wrk out avvadhu emooo..... konni recs e aithe we r good...

reddysaab cheppindhi try chesthe error ostundhiii...
[/quote]
Mundhu oka list tesukuna..... andhulo 3 text boxes create chesukuna....and add columns from dataset.

Later same list replicate chesina same columns attached to same dataset...

denkana mundhu query rasthunapudu


select STREAMTEAM.vw_members.FNAME,
STREAMTEAM.vw_members.LNAME,
STREAMTEAM.vw_members.ADDRESS1,
STREAMTEAM.vw_members.ADDRESS2,
STREAMTEAM.vw_members.CITY,
STREAMTEAM.vw_members.STATE,
STREAMTEAM.vw_members.ZIP,
STREAMTEAM.vw_members."+ FOUR" ,[size=6]ROW_NUMBER() OVER (ORDER BY LNAME) RNUM[/size] from streamteam.vw_members
GROUP BY STREAMTEAM.vw_members.FNAME,
STREAMTEAM.vw_members.LNAME,
STREAMTEAM.vw_members.ADDRESS1,
STREAMTEAM.vw_members.ADDRESS2,
STREAMTEAM.vw_members.CITY,
STREAMTEAM.vw_members.STATE,
STREAMTEAM.vw_members.ZIP,
STREAMTEAM.vw_members.TAG,
STREAMTEAM.vw_members."+ FOUR"
HAVING ((STREAMTEAM.vw_members.TAG)=1)
order by LNAME


Row number add chesuko so that it assumes each list as a row.....


epudu deploy chesthe u can see all the data vertically in 3 column
L1 L2 L3
1 1 1
2 2 2
3 3 3
4 4 4
Apudu list 1 loo neeku filter untadhi

andhulo velli filter add cheyi....expression ( =Fields!RNUM.Value mod 3 ) change the dropdown to integer and value (1) ---------------->(bracket lo unayi akada rayi

List 2 lo ( =Fields!RNUM.Value mod 3 ) change the dropdown to integer and value (2)

List 3 Lo ( =Fields!RNUM.Value mod 3 ) change the dropdown to integer and value (0)
and excute it...

u would get it

L1 l2 l3

1 2 3
4

screen shot pedham ante kudthratledhu..site chepu bhayaa post chestha

[pavan_613]

(.!2 (.!2

[littlestar]

[quote name='mtkr' timestamp='1349404547' post='1302584261']
em chepparu guruvugaaruuu.....
[/quote]ade cheppindi

[vikuba]

can we do a TRANSPOSE of DATA in SSRS...
jus throwing an idea..I dont know the solution..
but doing the TRANSPOSE will fulfill your requirement

[littlestar]

[quote name='Aamphat' timestamp='1349418890' post='1302584739']
can we do a TRANSPOSE of DATA in SSRS...
jus throwing an idea..I dont know the solution..
but doing the TRANSPOSE will fulfill your requirement
[/quote]yes..Transplant does the purpose

[vikuba]

[quote name='Little Star' timestamp='1349418944' post='1302584743']
yes..Transplant does the purpose
[/quote]
aapu nee ads...