AakPakKarivePak Posted October 2, 2013 Report Posted October 2, 2013 =IIF(Sum(IIF(Fields!Required.Value, 1, 0), "Details", Recursive)=0,"0 %", Str(Round(Sum(IIF(Fields!Total.Value > 0, 1, 0), "Details", Recursive)/Sum(IIF(Fields!Required.Value, 1, 0), "Details", Recursive)*10000)/100) & " %") e code SSRS report lonidi... HELP
AakPakKarivePak Posted October 2, 2013 Author Report Posted October 2, 2013 [quote name='Kottukusaavandi' timestamp='1380748125' post='1304339978'] 1 min [/quote] Thanks man
prayaanam Posted October 2, 2013 Report Posted October 2, 2013 if { Sum( (if{required is true} then 1 else 0) group by "Details") = 0 -- Donno what is recursive } then "0 %" else { Converttostring(Round(Sum( (if{total>0} then 1 else 0) group by "Details") / Sum( (if{total>0} then 1 else 0) group by "Details") * 1000 )/100) + " %" }
prayaanam Posted October 2, 2013 Report Posted October 2, 2013 Recursive ante theliyadu man...Nenu SSRS kaadu Telerik reporting. I deal with same kind of expressions.. Choostha recursive yento... Payina equation emanna artham kaakapothey adugu... Notepad++ download chesko...braces and loops anni clear ga seperate cheyyachu..
tom bhayya Posted October 2, 2013 Report Posted October 2, 2013 production support issue naa.. YSR ni thaluchuko man ventaney resolve ayipothundhi....
solman Posted October 2, 2013 Report Posted October 2, 2013 [quote name='Alexander' timestamp='1380749216' post='1304340106'] production support issue naa.. YSR ni thaluchuko man ventaney resolve ayipothundhi.... [/quote] [img]http://www.bewarsetalk.net/discus/movieanimated7/ali.kummavga.gif[/img]
AakPakKarivePak Posted October 2, 2013 Author Report Posted October 2, 2013 [quote name='Kottukusaavandi' timestamp='1380749007' post='1304340081'] if { Sum( (if{required is true} then 1 else 0) group by "Details") = 0 -- Donno what is recursive } then "0 %" else { Converttostring(Round(Sum( (if{total>0} then 1 else 0) group by "Details") / Sum( (if{total>0} then 1 else 0) group by "Details") * 1000 )/100) + " %" } [/quote] [quote name='Kottukusaavandi' timestamp='1380749149' post='1304340099'] Recursive ante theliyadu man...Nenu SSRS kaadu Telerik reporting. I deal with same kind of expressions.. Choostha recursive yento... Payina equation emanna artham kaakapothey adugu... Notepad++ download chesko...braces and loops anni clear ga seperate cheyyachu.. [/quote] Thanks man... that makes a lot of sense to me... analyze chesthunna... "Details" ani column ekkada use cheyaledu... is it a temporary column created on the go?
prayaanam Posted October 2, 2013 Report Posted October 2, 2013 [quote name='Ip_Man' timestamp='1380749760' post='1304340170'] Thanks man... that makes a lot of sense to me... analyze chesthunna... "Details" ani column ekkada use cheyaledu... is it a temporary column created on the go? [/quote] I dont think so. Details is a group on the report i believe....and that is grouped by a column ..
k2s Posted October 2, 2013 Report Posted October 2, 2013 [quote name='Kottukusaavandi' timestamp='1380749007' post='1304340081'] if { Sum( (if{required is true} then 1 else 0) group by "Details") = 0 -- Donno what is recursive } then "0 %" else { Converttostring(Round(Sum( (if{total>0} then 1 else 0) group by "Details") / Sum( (if{total>0} then 1 else 0) group by "Details") * 1000 )/100) + " %" } [/quote]
Chitti_Robo_Rebuilt Posted October 2, 2013 Report Posted October 2, 2013 Ya paina evaro chepparu kabatti vadileysaa... lekapothey 10 pages tho explain cheyddam anukunna [img]http://25.media.tumblr.com/4edf07f444d1c672a842a2fca4194e82/tumblr_mqiz99Clrl1spvnemo1_250.gif[/img]
AakPakKarivePak Posted October 2, 2013 Author Report Posted October 2, 2013 [quote name='Chitti_the_ROBO3' timestamp='1380753012' post='1304340485'] Ya paina evaro chepparu kabatti vadileysaa... lekapothey 10 pages tho explain cheyddam anukunna [img]http://25.media.tumblr.com/4edf07f444d1c672a842a2fca4194e82/tumblr_mqiz99Clrl1spvnemo1_250.gif[/img] [/quote] inka clarity ledu man... neku nijanga telisthe seppi pumyam kattuko...
Chitti_Robo_Rebuilt Posted October 2, 2013 Report Posted October 2, 2013 [quote name='Ip_Man' timestamp='1380754634' post='1304340609'] inka clarity ledu man... neku nijanga telisthe seppi pumyam kattuko... [/quote] Inthakee adi ey tech oo ey tool ooo cheyppi oka 3 months time isthey chadivi nerchukoni neeku clear ga explain cheysthaa baa [img]http://25.media.tumblr.com/4edf07f444d1c672a842a2fca4194e82/tumblr_mqiz99Clrl1spvnemo1_250.gif[/img]
Recommended Posts