| Author | Message | ||
Happyreddy Junior Artist Username: Happyreddy Post Number: 110 Registered: 02-2010 Posted From: 74.133.162.119 Rating: N/A |
oh sorry..no ssrs knowledge....ignore... | ||
Side Hero Username: Twitter Post Number: 3414 Registered: 10-2009 Posted From: 151.191.175.204 Rating: N/A |
SSRS lo isnull function ledhanukunta , adhi DB lo aithe work auddhi | ||
Happyreddy Junior Artist Username: Happyreddy Post Number: 109 Registered: 02-2010 Posted From: 74.133.162.119 Rating: N/A |
isnull(column, 'NO') should also work anukunta.. | ||
Side Hero Username: Twitter Post Number: 3403 Registered: 10-2009 Posted From: 151.191.175.204 Rating: N/A |
=iif(Fields!ReconAplFiledDate.Value = "",'NO',fieldname.value) try this | ||
Side Hero Username: Twitter Post Number: 3402 Registered: 10-2009 Posted From: 151.191.175.204 Rating: N/A |
b lovi manam em display setthunnam 'Y' or 'N' based on ReconAplFiledDate, check select ReconAplFiledDate WHERE SSN = "edho oka valid ssn ivvu" and somedate <= sysdate see if you see some 0 or 1 by executing this query | ||
Ntr_rocks Hero Username: Ntr_rocks Post Number: 12614 Registered: 04-2009 Posted From: 170.141.177.94 Rating: N/A |
Even this is not working and my expression is =Fields!ReconAplFiledDate.Value If you don't like Something, Change it. If you can't Change it, Change the way you think about it. | ||
Side Hero Username: Twitter Post Number: 3401 Registered: 10-2009 Posted From: 151.191.175.204 Rating: N/A |
SELECT a.RoundNumber, a.DistrictCode, a.CountyCode, a.LastName, a.FirstName, a.MiddleInit, a.SSN, a.ACCENTCaseNo, CONVERT(char(10), a.ApplRegDate, 101) AS ApplRegDate, CONVERT(char(10), a.DateSentToDDS, 101) AS DateSentToDDS, a.DDSDecision, CONVERT(char(10), a.DDSDecisionDate, 101) AS DDSDecisionDate, CONVERT(char(10), a.AssocClmDtFiled, 101) AS AssocClmDtFiled, CONVERT(char(10), a.ACCENTAuthDt, 101) AS ACCENTAuthDt, CONVERT(char(10), a.AssocClmDecDt, 101) AS AssocClmDecDt, a.AssocClmStatus, CASE WHEN a.AssocClmAddlACCENTAction = 1 THEN 'Y' WHEN a.AssocClmAddlACCENTAction = 0 THEN 'N' END AS AssocClmAddlACCENTAction, a.AssocClmAddlACCENTActionTaken, CASE WHEN b.ReconAplFiledDate = 1 THEN 'Y' WHEN b.ReconAplFiledDate = 0 THEN 'N' END AS ReconAplFiledDate, CONVERT(char(10), a.FinalSSADecisionDate, 101) AS FinalSSADecisionDate, a.FinalSSAAppealResult, CASE WHEN a.SAAplAddlACCENTAction = 1 THEN 'Y' WHEN a.SSAAplAddlACCENTAction = 0 THEN 'N' END AS SSAAplAddlACCENTAction, a.SSAAplAddlACCENTActionTaken FROM dbo.SSD a , dbo.SSAAppEAL b WHERE a.SSN = b.SSN and (a.AssocClaim = 1) and b.somedate <= sysdate ORDER BY a.RoundNumber, a.DistrictCode, a.CountyCode, a.LastName } | ||
Ntr_rocks Hero Username: Ntr_rocks Post Number: 12613 Registered: 04-2009 Posted From: 170.141.177.94 Rating: N/A |
One more thing..B table column value display kavatam ledu grid lo...anni NULL display avutunnayi, data vunna kaani If you don't like Something, Change it. If you can't Change it, Change the way you think about it. | ||
Ntr_rocks Hero Username: Ntr_rocks Post Number: 12612 Registered: 04-2009 Posted From: 170.141.177.94 Rating: N/A |
yes annai...edi aa query lo ekada insert cheyali...? If you don't like Something, Change it. If you can't Change it, Change the way you think about it. | ||
Side Hero Username: Twitter Post Number: 3399 Registered: 10-2009 Posted From: 151.191.175.204 Rating: N/A |
Report Text box Expression open sesi =iif(isNothing(fieldname.value),'NO',fieldname.value) try sei | ||
Side Hero Username: Twitter Post Number: 3398 Registered: 10-2009 Posted From: 151.191.175.204 Rating: N/A |
if i got it correctly query lo b.datefeild <= sysdate tho comparision pettukoni thevocchu | ||
Ntr_rocks Hero Username: Ntr_rocks Post Number: 12611 Registered: 04-2009 Posted From: 170.141.177.94 Rating: N/A |
DB lo Column NULL vunte..Report lo No ani print avvali but why it is not printing anything If you don't like Something, Change it. If you can't Change it, Change the way you think about it. | ||
Ntr_rocks Hero Username: Ntr_rocks Post Number: 12610 Registered: 04-2009 Posted From: 170.141.177.94 Rating: N/A |
Annai one more question... How to get the data based on recent updated date from B table.? If you don't like Something, Change it. If you can't Change it, Change the way you think about it. | ||
Ntr_rocks Hero Username: Ntr_rocks Post Number: 12607 Registered: 04-2009 Posted From: 170.141.177.94 Rating: N/A |
annai...Thank you..It works.. If you don't like Something, Change it. If you can't Change it, Change the way you think about it. | ||
Ntr_rocks Hero Username: Ntr_rocks Post Number: 12606 Registered: 04-2009 Posted From: 170.141.177.94 Rating: N/A |
Thank u..I will let you know If you don't like Something, Change it. If you can't Change it, Change the way you think about it. | ||
Side Hero Username: Twitter Post Number: 3395 Registered: 10-2009 Posted From: 151.191.175.204 Rating: N/A |
sorry I don't have access to gmail account at work, so I posted it here , I fwded your mail to my work id from my phone. | ||
Side Hero Username: Twitter Post Number: 3394 Registered: 10-2009 Posted From: 151.191.175.204 Rating: N/A |
I have made changes to the query , it is equi join now , you might need to change the join if the requirement demands. ------------------------------------------------------------ ------------------ SELECT a.RoundNumber, a.DistrictCode, a.CountyCode, a.LastName, a.FirstName, a.MiddleInit, a.SSN, a.ACCENTCaseNo, CONVERT(char(10), a.ApplRegDate, 101) AS ApplRegDate, CONVERT(char(10), a.DateSentToDDS, 101) AS DateSentToDDS, a.DDSDecision, CONVERT(char(10), a.DDSDecisionDate, 101) AS DDSDecisionDate, CONVERT(char(10), a.AssocClmDtFiled, 101) AS AssocClmDtFiled, CONVERT(char(10), a.ACCENTAuthDt, 101) AS ACCENTAuthDt, CONVERT(char(10), a.AssocClmDecDt, 101) AS AssocClmDecDt, a.AssocClmStatus, CASE WHEN a.AssocClmAddlACCENTAction = 1 THEN 'Y' WHEN a.AssocClmAddlACCENTAction = 0 THEN 'N' END AS AssocClmAddlACCENTAction, a.AssocClmAddlACCENTActionTaken, CASE WHEN b.ReconAplFiledDate = 1 THEN 'Y' WHEN b.ReconAplFiledDate = 0 THEN 'N' END AS ReconAplFiledDate, CONVERT(char(10), a.FinalSSADecisionDate, 101) AS FinalSSADecisionDate, a.FinalSSAAppealResult, CASE WHEN a.SAAplAddlACCENTAction = 1 THEN 'Y' WHEN a.SSAAplAddlACCENTAction = 0 THEN 'N' END AS SSAAplAddlACCENTAction, a.SSAAplAddlACCENTActionTaken FROM dbo.SSD a , dbo.SSAAppEAL b WHERE a.SSN = b.SSN and (a.AssocClaim = 1) ORDER BY a.RoundNumber, a.DistrictCode, a.CountyCode, a.LastName ------------------------------------------------------------ -------- | ||
Ntr_rocks Hero Username: Ntr_rocks Post Number: 12603 Registered: 04-2009 Posted From: 170.141.177.94 Rating: N/A |
Can u check ur mail.. If you don't like Something, Change it. If you can't Change it, Change the way you think about it. | ||
Side Hero Username: Twitter Post Number: 3392 Registered: 10-2009 Posted From: 151.191.175.205 Rating: N/A |
ccdbtwitter@gmail.com | ||
Rekkadithe_gani_dokkadadhu Side Hero Username: Rekkadithe_gani_dokkadadhu Post Number: 2393 Registered: 01-2010 Posted From: 165.95.16.204 Rating: N/A |
http://msdn.microsoft.com/en-us/library/ms170246%28SQL.90%29 .aspx It is easy to float along with a smile when life is as sweet as a song, but a man worthwhile is one with a smile when everything goes dead wrong" - S.N. Goenka | ||
Ntr_rocks Hero Username: Ntr_rocks Post Number: 12602 Registered: 04-2009 Posted From: 170.141.177.94 Rating: N/A |
Can u please give me ur email ID If you don't like Something, Change it. If you can't Change it, Change the way you think about it. | ||
Ntr_rocks Hero Username: Ntr_rocks Post Number: 12601 Registered: 04-2009 Posted From: 170.141.177.94 Rating: N/A |
annai query peddaga vuntundi...ekada kastam emo anukuntunna.. If you don't like Something, Change it. If you can't Change it, Change the way you think about it. | ||
Ntr_rocks Hero Username: Ntr_rocks Post Number: 12600 Registered: 04-2009 Posted From: 170.141.177.94 Rating: N/A |
Yes If you don't like Something, Change it. If you can't Change it, Change the way you think about it. | ||
Side Hero Username: Twitter Post Number: 3391 Registered: 10-2009 Posted From: 151.191.175.205 Rating: N/A |
BIDS install chesukunnava ? | ||
Sachin Hero Username: Sachin Post Number: 18759 Registered: 04-2008 Posted From: 198.204.133.208 Rating: N/A |
aaapice lo personal mail pani cheyadu vuncle...eeda ettu question.... | ||
Ntr_rocks Hero Username: Ntr_rocks Post Number: 12598 Registered: 04-2009 Posted From: 170.141.177.94 Rating: N/A |
05...first time reports settunna annai...G lo D avutundi... If you don't like Something, Change it. If you can't Change it, Change the way you think about it. | ||
Ntr_rocks Hero Username: Ntr_rocks Post Number: 12597 Registered: 04-2009 Posted From: 170.141.177.94 Rating: N/A |
nee email id pettu...simple gane vuntadi... If you don't like Something, Change it. If you can't Change it, Change the way you think about it. | ||
Side Hero Username: Twitter Post Number: 3390 Registered: 10-2009 Posted From: 151.191.175.205 Rating: N/A |
report cheyyatam chala easy is it in SSRS 2005 or 08 ? | ||
Sachin Hero Username: Sachin Post Number: 18758 Registered: 04-2008 Posted From: 198.204.133.208 Rating: N/A |
query ayithe helping ki try sethaaa..report ante jump | ||
Ntr_rocks Hero Username: Ntr_rocks Post Number: 12596 Registered: 04-2009 Posted From: 170.141.177.94 Rating: N/A |
Evaraina vunnara....vunte koddiga seppandi...Oka SQL Query rasi report generate cheyali..  If you don't like Something, Change it. If you can't Change it, Change the way you think about it. |