Jump to content

Help On Ssrs Reports ..


Recommended Posts

Posted

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

[img]http://lh3.ggpht.com/-ucThZq7C71k/UGD9AxjfbaI/AAAAAAAAHb8/06kLi9IYhwI/s150/Brahmi-2.gif[/img]

  • Replies 57
  • Created
  • Last Reply

Top Posters In This Topic

  • rapchik

    13

  • deals2buy

    11

  • mtkr

    10

  • ghazni

    6

Top Posters In This Topic

Posted

GP amma, w-p-f evarikanna vaste naku cheppandi, naku kuda help kavali...

report issue solve ayindia.. sCo_^Y

Posted

[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]

ok ok
[quote name='ReddyGaru' timestamp='1349413235' post='1302584666']
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

:0012391: screen shot pedham ante kudthratledhu..site chepu bhayaa post chestha
[/quote]

thankyou ()>> CITI_$D# CITI_y@R

Posted

[quote name='Aamphat' timestamp='1349419098' post='1302584748']
aapu nee ads...
[/quote]I am lifting the thread and helping the needy and homeless, senseless, shameless hopeless ReddyGaru

Posted

bhayya kocham clear ga explain cheyyi ela chesavo

Posted

[quote name='pikki' timestamp='1349419854' post='1302584761']
GP amma, w-p-f evarikanna vaste naku cheppandi, naku kuda help kavali...

report issue solve ayindia.. sCo_^Y
[/quote]


w-p-f ante? sCo_^Y

Posted

[quote name='deals2buy' timestamp='1349450862' post='1302586041']


w-p-f ante? sCo_^Y
[/quote]
wcf wpf antaru kada ademo sCo_^Y

Posted

[quote name='Little Star' timestamp='1349454024' post='1302586358']
wcf wpf antaru kada ademo sCo_^Y
[/quote]


wcf wpf ante? sCo_^Y

Posted

[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]
Nope dude....Matrix kani mostly cheyalemu....ekada manamu motham data transpose avodhu

1
2
3
4
unte

adhi

1 2 3
4
ella ravali

Posted

[quote name='chelsea' timestamp='1349450617' post='1302586004']
bhayya kocham clear ga explain cheyyi ela chesavo
[/quote]
mamulaga table ,matrix vadakunda......list vadi andhulo text box lu add chesanu

then u can see 3 list with same data and then assign them with row number

tharuvatha aa list ki filter condition payana post lo condition petina so that it hides the replicated list

and get the result

first illa utadhi

1

2

3

4


dhani 1 2 3
4
ella techukuntam

Posted

[quote name='deals2buy' timestamp='1349454882' post='1302586410']


wcf wpf ante? sCo_^Y
[/quote]
[color=#000000][font=sans-serif][size=3].NET Framework 3.0 consists of four major new components[/size][/font][/color]

[color=#000000][font=sans-serif][size=3]andhuloo ivvi parts...[/size][/font][/color]Windows Presentation Foundation (WPF),

Windows Communication Foundation (WCF),

Windows Workflow Foundation (WF)

Windows CardSpace,

Dhini gurinchi chalane unayi.... okati feel of page kosam vadithe inkokati particular flow kosam vadutharu...inkokati web-services type thing

chala articles untayi.....
ayina epudu .Net 4.5 vachindhi...evani lite ayipothunayi

Posted

[quote name='Little Star' timestamp='1349454024' post='1302586358']
wcf wpf antaru kada ademo sCo_^Y
[/quote]
[quote name='CITI' timestamp='1349419394' post='1302584754']
[img]http://lh3.ggpht.com/-ucThZq7C71k/UGD9AxjfbaI/AAAAAAAAHb8/06kLi9IYhwI/s150/Brahmi-2.gif[/img]
[/quote]

na thread lo meeku pani emundhi *(*(* *(*(*
[quote name='pikki' timestamp='1349419854' post='1302584761']
GP amma, w-p-f evarikanna vaste naku cheppandi, naku kuda help kavali...

report issue solve ayindia.. sCo_^Y
[/quote]

yep ayindhi baa &.,*

Posted

[quote name='ReddyGaru' timestamp='1349455917' post='1302586496']
[color=#000000][font=sans-serif][size=3].NET Framework 3.0 consists of four major new components[/size][/font][/color]

[color=#000000][font=sans-serif][size=3]andhuloo ivvi parts...[/size][/font][/color]Windows Presentation Foundation (WPF),

Windows Communication Foundation (WCF),

Windows Workflow Foundation (WF)

Windows CardSpace,

Dhini gurinchi chalane unayi.... okati feel of page kosam vadithe inkokati particular flow kosam vadutharu...inkokati web-services type thing

chala articles untayi.....
ayina epudu .Net 4.5 vachindhi...evani lite ayipothunayi
[/quote]


oh ok..naaku asalu .net teleedu..thanks for sharing

×
×
  • Create New...