ipaddress0 Posted March 18, 2015 Report Posted March 18, 2015 2 months wfh, 1 montha vacation man... enjoy mayya :police:
Darling999 Posted March 18, 2015 Report 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
loveindia Posted March 19, 2015 Report 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
ipaddress0 Posted March 19, 2015 Report Posted March 19, 2015 thanks man, you also enjoy man... tondarloney nenu kuda one house vaadni avta.. appudu enjoy start chesta :D atb mayya
vizagpower Posted March 19, 2015 Report 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 ??????
loveindia Posted March 19, 2015 Report 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...
mtkr Posted March 19, 2015 Report 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....
vizagpower Posted March 19, 2015 Report Posted March 19, 2015 lyk oka query nundi vache count reslt ni ela ola column count laaaga chupinchaali ani askng....
vizagpower Posted March 19, 2015 Report 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 ?
vizagpower Posted March 19, 2015 Report 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 ?
loveindia Posted March 19, 2015 Report 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...
manjunath455 Posted March 20, 2015 Report Posted March 20, 2015 why can't we use case statement in dynamic sql statement? Evarikaina teliste pls cheppandi :3D_Smiles_38:
Darling999 Posted March 20, 2015 Report 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
Recommended Posts