ipaddress0 Posted March 18, 2015 Report Share Posted March 18, 2015 2 months wfh, 1 montha vacation man... enjoy mayya :police: Link to comment Share on other sites More sharing options...
Darling999 Posted March 18, 2015 Report Share Posted March 18, 2015 working from india man... aa manager gadu april h1's time... manam job ichina client letter ani sava godtaaru so april ki postpone cheddam hiring ani cheppadu man... Hmmm Helpless bhayya... India nubdi pani avtubda? Monna poyina 2.5 months ki Konchem kashtam anpinchindi nights Link to comment Share on other sites More sharing options...
loveindia Posted March 19, 2015 Report Share Posted March 19, 2015 enjoy mayya :police: thanks man, you also enjoy man... tondarloney nenu kuda one house vaadni avta.. appudu enjoy start chesta :D Link to comment Share on other sites More sharing options...
ipaddress0 Posted March 19, 2015 Report Share Posted March 19, 2015 thanks man, you also enjoy man... tondarloney nenu kuda one house vaadni avta.. appudu enjoy start chesta :D atb mayya Link to comment Share on other sites More sharing options...
manjunath455 Posted March 19, 2015 Report Share Posted March 19, 2015 #4H# #4H# Link to comment Share on other sites More sharing options...
vizagpower Posted March 19, 2015 Report Share Posted March 19, 2015 SSRS Lo count based on condition ela chestam , I mean say 1000 records unte i need to get count of rows based on conditions say count of all cancelled accounts and count of active accounts based on a flag ?????? Link to comment Share on other sites More sharing options...
loveindia Posted March 19, 2015 Report Share Posted March 19, 2015 SSRS Lo count based on condition ela chestam , I mean say 1000 records unte i need to get count of rows based on conditions say count of all cancelled accounts and count of active accounts based on a flag ?????? elaborate more man... ardam avaledu question... Link to comment Share on other sites More sharing options...
mtkr Posted March 19, 2015 Report Share Posted March 19, 2015 elaborate more man... ardam avaledu question... lyk oka query nundi vache count reslt ni ela ola column count laaaga chupinchaali ani askng.... Link to comment Share on other sites More sharing options...
vizagpower Posted March 19, 2015 Report Share Posted March 19, 2015 lyk oka query nundi vache count reslt ni ela ola column count laaaga chupinchaali ani askng.... Link to comment Share on other sites More sharing options...
vizagpower Posted March 19, 2015 Report Share Posted March 19, 2015 elaborate more man... ardam avaledu question... Say I have three statuses " Approved" , "Pending", "cancelled" , I need to get total of accounts which fall into these 3 categories , say Sno Status Last Quarter previous Quarter percentage change (calculated column) 1 Approved 200 400 (400-200)/200 2 pending 150 50 (50-150)/150 3 Cancelled 25 50 (50-25)/25 Also how can we find the caluclated column for grouping in SSRS ? Link to comment Share on other sites More sharing options...
vizagpower Posted March 19, 2015 Report Share Posted March 19, 2015 elaborate more man... ardam avaledu question... Say I have three statuses " Approved" , "Pending", "cancelled" , I need to get total of accounts which fall into these 3 categories , say Sno Status Last Quarter previous Quarter percentage change (calculated column) 1 Approved 200 400 (400-200)/200 2 pending 150 50 (50-150)/150 3 Cancelled 25 50 (50-25)/25 Also how can we find the caluclated column for grouping in SSRS ? Can i call you today ? Link to comment Share on other sites More sharing options...
JammichettuPandu Posted March 19, 2015 Report Share Posted March 19, 2015 Long thread Link to comment Share on other sites More sharing options...
loveindia Posted March 19, 2015 Report Share Posted March 19, 2015 Say I have three statuses " Approved" , "Pending", "cancelled" , I need to get total of accounts which fall into these 3 categories , say Sno Status Last Quarter previous Quarter percentage change (calculated column) 1 Approved 200 400 (400-200)/200 2 pending 150 50 (50-150)/150 3 Cancelled 25 50 (50-25)/25 Also how can we find the caluclated column for grouping in SSRS ? Can i call you today ? elaborate annanu kada ani india ki call chesestaava man... :P I am in india now... = (IIF(isnothing(Fields!PreviousQuarter.Value), 0, Fields!PreviousQuarter.Value) - IIF(isnothing(Fields!LastQuarter.Value), 0, Fields!LastQuarter.Value)) / IIF(isnothing(Fields!LastQuarter.Value), 0, Fields!LastQuarter.Value) Best solution... if possible nee sql query loney chey aa calculation or else SSRS Xvelocity Engine is not that great... if too many aggregations it will choke... Link to comment Share on other sites More sharing options...
manjunath455 Posted March 20, 2015 Report Share Posted March 20, 2015 why can't we use case statement in dynamic sql statement? Evarikaina teliste pls cheppandi :3D_Smiles_38: Link to comment Share on other sites More sharing options...
Darling999 Posted March 20, 2015 Report Share Posted March 20, 2015 Delete and truncate lo Rollback vaadachu kadaa... only Delete antaaru entii, I can do truncate rollback asloo in the SSMS. some one explain... Loveindia Link to comment Share on other sites More sharing options...
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
Recommended Posts