Posts

Showing posts from May, 2013

Media Browser show the directory but it doesn't show content in MODX -

i have been encountering following issue , i´m going bit crazy. hope can me: in backoffice, can see media folders when click on it, doesn´t show me content (files) the strange thing happening in folders. , there no restrictions or rules applied ont media browser. some things take in consideration: modx version 2.3 (i upgraded, still not working) ftp folder permissions 777 the media path file source correct i deleted cache + permissions the error.log file isn´t showing visible error. my acl correct, has administrator permissions enter image description here enter image description here please advice. many thanks!! update : the directories corrupted created new directories , rename old directories. not sure if fix particular issue - noticed in media source setup have forward slash (/) before paths after. think in general it's practice have same number of forward slashes have directories listed. include / after last directory, don't include

android - hide toolbar when scrolling recyclerview -

i new in material design,i unable hide toolbar when scrolling list.for more information sharing code given below: 1.common layout app <?xml version="1.0" encoding="utf-8"?> <android.support.v4.widget.drawerlayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:app="http://schemas.android.com/apk/res-auto" android:id="@+id/drawer_layout" android:layout_width="match_parent" android:layout_height="match_parent" android:fitssystemwindows="true"> <android.support.design.widget.coordinatorlayout android:layout_width="match_parent" android:layout_height="match_parent" android:background="@android:color/background_light"> <relativelayout android:id="@+id/main_container" android:layout_width="match_parent" android:layout_height=

Is it possible to clear all cookies in an Android device? -

many apps in android using embedded webviews. is possible clear cookies set in such webviews? if clear cookies browser menu, ones set webviews cleared well? edit: webview documentation page seems cookies of webview kept separate ones of browser, hence suspect user cannot delete cookies set webview: for obvious security reasons, application has own cache, cookie store etc.—it not share browser application's data. is there way delete them via settings or via other tool? thanks to disallow cookies being stored in webview, try following using cookiemanager : cookiemanager.getinstance().setacceptthirdpartycookies(false); you remove them manually yourself: cookiesyncmanager.createinstance(this); cookiemanager cookiemanager = cookiemanager.getinstance(); cookiemanager.removeallcookie(); cookiemanager.setacceptcookie(false); here documentation: http://developer.android.com/reference/android/webkit/cookiemanager.html and removeallcookie() function l

r - Package which is only available in source form, and may need compilation of C/C++/Fortran: ‘ROracle’ These will not be installed -

i tried install roracle package in r. unable install package. giving me following error: package available in source form, , may need compilation of c/c++/fortran: ‘roracle’ these not installed any idea how fix it? when attempted install roracle package cran, received same error message. fix it, found needed install roracle package located on oracle.com website . you'll need sign free account first, , can find searching "roracle". this package can downloaded , installed error-free. worked me.

visual c++ - Will installing VS2015 update 3 VC++ redistributables break other software -

as suggested in this post , if install vc++ redistributables vs2015 update 3 break other software running on same pc built previous updates vs2015? similarly, if stick update 2 release, going broken @ point in future when installs redists update 3? based on bug description reported @ new vc runtime 14.0.24210.0 breaks mfc app built vs 2015 update 2 u3 redistributables indeed break mfc apps compiled u2 or earlier, which: use mfc in dll i.e. not statically linked, and create objects of type cmfctoolbarbutton or derived. from linked page: the problem caused new bool member m_bisdragged in class cmfctoolbarbutton. memory layout differs between update 2 , 3. when initializing m_bisdragged in constructor, (stack) memory behind toolbarbutton overwritten. the problem should arise on classes derived cmfctoolbarbutton: cmfccolormenubutton cmfccustomizemenubutton cmfcdropdowntoolbarbutton cmfcoutlookbarpanebutton cmfcribbongallerymenubut

angularjs - Angular 2 - simple HTTP GET from component not working -

i have angular 2 app has simple component (see below). makes simple call web api endpoint. can call end point using postman when component tries fails. call never made , no errors output. have done wrong? i've followed pattern before. import { component, input } '@angular/core'; import { router_directives, router } '@angular/router'; import { http,response, headers, requestoptions } '@angular/http'; import { domsanitizationservice } '@angular/platform-browser'; import { observable } 'rxjs/observable'; import { itile } '../interfaces/tile'; @component({ selector: 'tile', template: require('../tile/tile.component.html'), styles: [require('../tile/tile.component.css').tostring()], directives: [router_directives] }) export class tilecomponent { @input() tile: itile; constructor(private _http: http) { } onselect(id: string) { this.getprofileimage(id); } getpr

java - Jersey application - Error on start up -

i have jersey application fileupload. , during startup or when upload file in application, below errors in websphere trace logs. error: the registered message body writers compatible mime media type are: application/octet-stream -> com.sun.jersey.core.impl.provider.entity.bytearrayprovider com.sun.jersey.core.impl.provider.entity.fileprovider com.sun.jersey.core.impl.provider.entity.inputstreamprovider com.sun.jersey.core.impl.provider.entity.datasourceprovider com.sun.jersey.core.impl.provider.entity.streamingoutputprovider */* -> com.sun.jersey.core.impl.provider.entity.formprovider com.sun.jersey.core.impl.provider.entity.mimemultipartprovider com.sun.jersey.server.impl.template.viewablemessagebodywriter com.sun.jersey.core.impl.provider.entity.stringprovider com.sun.jersey.core.impl.provider.entity.bytearrayprovider com.sun.jersey.core.impl.provider.entity.fileprovider com.sun.jersey.core.impl.provider.entity.inputstreamprovider com.sun.jerse

mysql - Running Sqoop demo. NoHostAvailableException -

i running sqoop demo datastax enterprise 5.0 , have followed every instruction , seem work fine. when run import sql cql exception nohostavailableexception. please need help. thanks this import options: cql-import --table npa_nxx --cassandra-keyspace npa_nxx --cassandra-table npa_nxx_data --cassandra-column-mapping npa:npa,nxx:nxx,latitude:lat,longitude:lon,state:state,city:city --connect jdbc:mysql://127.0.0.1:3306/npa_nxx_demo --username root --password xxxx --cassandra-host 127.0.0.1 after run errors (image exception ) instead of 127.0.0.1 use hostname: can hostname command: hostname -f

xamarin.android - Android Geofence Trigger Delay/Failure -

i've registered geofences in android app 5-6 locations. the geofence event want, geofence dwell loitering delay of 10 sec. but using this, event triggered in android devices, , doesn't trigger @ in others. so, testing purpose, considered below listed scenarios: 1) reduced loitering delay 3 sec. time results better, triggered in 4 out of 5 devices. 2) testing scenario was, registered geofence enter event (which has no loitering delay), , time triggered in devices. ideally, need geofence dwell event triggered delay of 10 sec, because don't entertain frequent geofence notifications on enter event. please suggest possibly wrong geofence dwell longer delays. appreciated. thanks in advance.

Highstock/Highcharts - yAxis Label top -

Image
using highstock or highcharts, want yaxis label on top. don't want, varying margin between left border of chart , beginning of grid lines. if take @ following fiddle: jsfiddle relevant part is: yaxis: { title: { align: 'high', offset: 0, text: 'rainfall (mm)', rotation: 0, y: -10 } } this correct, offset margin taken label width. if set offset: -41 instead, looks right. problem is, -41 due rendered length of text. if change text of different length, label positioned wrongly again. is there possibility make sure, positions "correct" in above definition of correct, regardless of text length? screenshot, left part wrong, right part correct: i think can use text-anchor property style title. here can find more information text-anchor property: https://developer.mozilla.org/en-us/docs/web/svg/attribute/text-anchor title: { align: 'high', text: 'rainfall (mm)'

javascript - angular ui boostrap Tooltips : Tabular data -

Image
i want implement tooltips in bootsrap, show content in tabular form.can guide me how ? have attached image reference.

Global variable defined outside of javascript file does not work -

i have html file: <body> <?php $rand1 = rand(0,10); $rand2 = rand(0,20); ?> <span id="client-registration-button">registration</span> <script>var checksum = <?php echo $rand1+$rand2; ?>;</script> <script src="/main.js"></script> </body> and in main.js is: $('#client-registration-button').click(function() { alert(checksum); }); but alert shows no value, empty alert window. why there no value of global variable "checksum" displayed?

angularjs - Update Multiple selection dropdown list for a single data in a table -

i have list of students each 1 of them can assign roles them in multiselect dropdown list, buut when select roles 1 or 2 changes students in table, each student indivisual if assign role assistant student should one. <html ng-app="myapp"> <div ng-controller="mycontroller"> <tbody> <tr ng-repeat="s in slist"> <td width="33%">{{s}}</td> <td width="33%"> <div ng-dropdown-multiselect="" extra-settings="dropdownsetting" options="categories" selected-model="categoriesselected" checkboxes="true"> </div> <button type="submit" class="btn btn-primary">submit</button> </td> </tr> </tbody> </div> <script src="../../javascrip

php - on change not working in nested dropdown list -

hello want display data of business3's data according business2's , business2's data according business1's dropdown list on change() of business1 got data in response i didn't second on change() in dropdown list. <!-- ajax code first business starts here --> <script> $(document).on('change', 'select.business1', function(){ var business1 = $('select.business1 option:selected').val(); alert(business1); var value = $(this).val(); $.ajax({ type:"post", data: { business1:business1 }, url: '<?php echo site_url('client_area/select_business_sub_cat'); ?>', success : function (data){ $('#busin

excel - Only make a row visible to a certified person -

i making worksheet people can add issues. want add user access groups in file. i've added column creator of issue has filled in. checking column, excel should determine can see specific row. example: group 1 can see everything group 2 can see , not issue added group 1 group 3 can see , not issue added groups 2 , 1 i first thinking of adding different passwords file. according password, excel knows in group user belongs. (for example password "1" people group 1, password "2" people group 2 , ... ) since i'm new using ms office / vba have no idea if possible. is possible add these passwords or possible make row invisible users depending on input of 1 cell ? what you're asking possible, not simple. require combination of worksheet protections , own subroutines hide , unhide rows accordingly. need use worksheet protection prevent users manually unhiding rows. then, add userform prompts user password. based on password provided, ca

c# - Immediate Window and runtime giving different results for same LINQ statement -

i have piece of code compares 2 collections, , returns items 1 list doesn't belong in other. as these 2 lists contain objects aren't equitable reference, have simple iequatable compares objects on ids. the code running follows: private preferencedefinition[] finduserpreferencestoadd(preferencedefinition[] newdefinitions, preferencedefinition[] olddefinitions) { //get newly selected definitions var newpreferences = newdefinitions.where(def => def.isselected); //get new definitions don't exist in old list var preferencestoadd = newpreferences.where(def => !olddefinitions.contains(def)).toarray(); return preferencestoadd; } the result of preferencestoadd gives me exact same list in newpreferences , despite purposely ensuring newdefinitions contains additional item has been selected. if pass in 7 new preferences, return 7 preferences 'add' - incorrect implementation. however, when run exact same linq statement in immedia

javascript - HighCharts activity gauge populated with series data from a function -

i'm trying populate highcharts dataset results sql server in classic asp. (in examples there numbers , names instead of vbscript variables) the first example without function - , works. http://jsfiddle.net/p40472pz/ $(function () { var n = '<%=n11 %>' if (!highcharts.theme) { highcharts.setoptions({ chart: { backgroundcolor: 'rgba(255,255,255,0.002)' }, colors: ['#666666', '#666666', '#666666', '#666666', '#666666', '#666666', '#666666'], tooltip: { style: { color: '#a0a0a0' } } }); } // */ highcharts.chart('11', { chart: { type: 'solidgauge', margin: [0, 0, 0, 0] }, title: { text: '', style: { fontsize: '12px' } }, tooltip: { borderwidth: 1, backgroundcolor: &#

ImportError: libcudart.so.7.5 when I debug TensorFlow programs using VScode with the python extension? -

i have installed vscode python extension on ubuntu system. have installed tensorflow 0.9, cuda 7.5 , cudnn library correctly. however, when debug tensorflow program using vscode, give error importing tensorflow (import tensorflow) below: importerror: libcudart.so.7.5: cannot open shared object file: no such file or directory i can sure libraries have been installed successfully. because can debug , run python programs in vscode, , can run tensorflow programs using ubuntu terminal. besides, when import tensorflow ubuntu terminal, gives output follows: i tensorflow/stream_executor/dso_loader.cc:108] opened cuda library libcublas.so locally tensorflow/stream_executor/dso_loader.cc:108] opened cuda library libcudnn.so locally tensorflow/stream_executor/dso_loader.cc:108] opened cuda library libcufft.so locally tensorflow/stream_executor/dso_loader.cc:108] opened cuda library libcuda.so locally tensorflow/stream_executor/dso_loader.cc:108] opened cuda library libcurand.so loca

sonarqube - Findbugs and FindSecBugs in Sonar -

i wanted have extensive static analysis of our code chose findbugs sonar profile. want have security analysis can see there's profile called findbugs security audit in sonarqube. there way can use both of them analyse our code without having create custom profile? thanks there not way can apply 2 different rule profiles same project @ same time. can choose 1 or other have rules both you'll either need edit 1 of them or create 3rd profile. note not hard do. create new profile (it's empty @ point) go rules page use quality profile facet search rules active in first source profile - click on profile, , 'active' use bulk change activate them in new profile repeat steps 3 & 4 each source profile. there's no need worry overlaps - rules active in multiple source profiles activated once , once in target profile.

How can i manage layout file in tabbed activity in android? -

explanation: i took tabbed activity while created project. in there single layout file fragments in viewpager.i want set different layout different fragment , add tabbed dynamically dynamic fragment. suppose, have size 5 5 tab created,if have 2 create 2 tab. here mainactivity.java in inner class also public class mainactivity extends appcompatactivity { private sectionspageradapter msectionspageradapter; public viewpager mviewpager; string[] title={"shoes","bag","three","four","five","six","seven","eight","nine","ten"}; @override protected void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); setcontentview(r.layout.activity_main); toolbar toolbar = (toolbar) findviewbyid(r.id.toolbar); setsupportactionbar(toolbar); msectionspageradapter = new sectionspageradapter(getsupportfragmentmanag

ios - Opening facebook share dialog with populated text and url from a web-app via intent? -

i've been searching on google, github , stackoverflow 2 days before i'm asking question, answers old , outdated couldn't solve problem. for twitter, pinterest , google+ found url intents , work fine. example if click url twitter://post?message=${fullmessage} in safari, native twitter share dialog opened link , message. is there documentation (from 2015-2016) work native facebook ios app in same way? thanks!

python - f2py erf function lnk2019 unresolved external symbol error -

i trying use f2py command : c:\python27\python.exe setup.py build_ext --inplace --fcompiler=g95 my fortran file : module test_f90 implicit none real *8 :: delta contains subroutine test_f(val, r) real*8, intent(out) :: val real*8, intent(in) :: r val = 0.5*( 1 + erf(r/delta) ) end subroutine end module test_f90 but have got error : test_fmod.o : error lnk2019: unresolved external symbol __g95_erf_r8 rÚfÚrencÚ d ans la fonction _test_f90_mp_test_f _test_f90.pyd : fatal error lnk1120: 1 externes non rÚsolus error: command "c:\program files (x86)\microsoft visual studio 9.0\vc\bin\link.e xe /dll /nologo /incremental:no /libpath:c:\python27\libs /libpath:c:\python27\p cbuild /libpath:c:\python27\pc\vs9.0 /libpath:c:\python27\libs /libpath:c:\pytho n27\pcbuild /libpath:c:\python27\pc\vs9.0 /export:init_test_f90 build\temp.win32 -2.7\release\build\src.win32-2.7\_test_f90module.obj build\temp.win32-2.7\releas e\build\src.win32-2.7\fortranobject.obj build\t

omnet++ - How do channels work with inout gates? -

first of know inout gates composed of input , output gates stuck together. leads me following questions when channel assigned connection between 2 inout gates in ned, input , output gate share channel, or 2 different channels created? say, had vector of inout gates, if used getbaseid, base id of gates in vector. if iterated through vector gate using each increment on base id inout gate, or input/output gate? what trying is, dynamically add inout gates gate vector, dynamically modify properties of channels of previous inout gates part of vector. started using omnetpp, , have read manual , lot of things on internet, couldn't find answer these. the 2 gates connect 2 independent channel objects there no such thing 'vector of inout gate'. there 2 separate gate vectors. 1 name 'gatename$i' other 'gatename$o' each 1 separate gate vector. (with possibly differet baseids). think mod1.gatea[2] <--> mod2.gateb[5] as shorthand mod1.ga

selenium - How to select the hidden radio button using ruby capybara -

<tr> <td> <div align="right"> <font size="2" face="arial, helvetica, sans-serif" color="red"/> <font size="2" face="arial, helvetica, sans-serif" color="#004891">material type :</font> </div> </td> <td> <input type="radio" onclick="radioinsert='01'" name="rdinserttype"/> <font size="2" face="arial, helvetica, sans-serif" color="#004891"> promotion <input type="radio" onclick="radioinsert='02'" name="rdinserttype"/> important notice </font> </td> i have tried following code : capybara.ignore_hidden_elements = false session.find(:xpath, ".//*[@n

What is the best way to design background jobs in microservices architecture? -

i using microservices architecture. per requirements, there restful services required , background jobs developed. for example of groceries delivery system, customers service - restful service provider service - restful service orderprovision - background service checks whether of customer items got provided different providers. once done, send initiation customer status , initiate delivery system start delivering for case of orderprovision best way implement microservices? in case of .net framework, can create windows service/ scheduler task run in background , checks. if needs deployed on other servers linux, not work. best way code such background tasks in microservices architecture? you can use task queues. take @ following article. although python, concepts can adopted other languages. https://www.fullstackpython.com/task-queues.html

android - Alarm won't stop ringing without killing the app -

i'm trying add alarm app i'm working on, stupid reason, once alarm ringing can't switch off without killing app. the alarm activated togglebutton. if it's on, alarm ring @ scheduled time, , when it's off, won't...or @ least, it's not supposed to. here's onclick code togglebutton: @onclick(r.id.alarmtoggle2) protected void onalarmtoggleclicked(){ if(alarmtoggle.ischecked()){ alarmtimetext.settextcolor(color.green); alarmtimetext.setvisibility(view.visible); //switch on alarm calendar calendar = calendar.getinstance(); calendar.settimeinmillis(system.currenttimemillis()); calendar.set(calendar.hour_of_day, alarmhour); calendar.set(calendar.minute, alarmminute); //it's time set off alarm log.d(tag, "alarm"); alarmreceiverintent = new intent(remindersactivity.instance(), alarmreceiver.class); broadcastintent = pendingintent.get

python - How to join downloaded file parts -

so , trying download single file in parts using python threading module , requests download. now thing able download file 4 separate parts not able join them. i tried using pypdf2 join pdf , ffmpeg join video files no help. not able open of downloaded files explains not getting downloaded correctly. pypdf2 giving error pdfreaderror: eof marker not found what should that able join files correctly. secondly , have use seperate methods join them, or can implement 1 method can used different file formats below download function implemented. def download(threadid, drange, url): headers = {"range":"bytes={0}-{1}".format(drange[0], drange[1])} print headers size = drange[1] - drange[0] print "starting thread {0}".format(threadid) req = requests.get(url, headers=headers, stream=true) download_status[size] = size download_status[threadid] = 0 # return req open('test{0}.mp4'.format(threadid),

c# - Binding to a ContentPresenter's visual elements/children from outside -

first brief "abstracted" short version of problem. not needed discuss solution, below further "optional" infos of real underlying problem i'm having, understand context. so: have contentpresenter using datatemplate generate layout bound items. now, outside of contentpresenter, i'm trying bind within element name within content presenter. assume following pseudo-xaml (maintextblock's binding won't work in practice): <textblock text="{binding text, elementname=mytextblock, source = ???}" datacontext="{x:reference thecontentpresenter}" x:name="maintextblock"/> <contentpresenter content="{binding someitem}" x:name="thecontentpresenter"> <contentpresenter.contenttemplate> <datatemplate> <textblock x:name="mytextblock" text="test"/> </datatemplate> </contentpresenter.contentte

html - Understanding the behavior of overflow: hidden in a flexbox container -

i've been having few issues flex boxes , having them span out of container text/content grows, , applying ellipses when specified max-width of container reached. this isn't ideal because parent container can shrink x pixels , text forces grow max-width not want. looking @ this fiddle , if remove overflow: hidden child1 , apply main , text cut off. if remove overflow: hidden main , apply child1 , behaviour want achieved. if remove overflow: hidden both of them, container , text go on forever. i want know why applying overflow: hidden child1 produces desired behaviour. shouldn't text cut off did overflow on main ? .main { display: flex; border: 1px solid black; height: 200px; padding: 10px; //overflow: hidden; } .child1 { display: flex; border: 1px solid red; height: 100px; overflow: hidden; } .child2 { flex: 1 1 auto; text-align: center; text-overflow: ellipsis; overflow: hidden; white-space: nowrap;

How to get Youtube video views by date range -

i trying youtube video views date range , working fine oauth. using cron script collect data through service account, when try execute script says: error calling https://www.googleapis.com/youtube/analytics/v1/reports?ids=channel%3d%3duc88bq63mdji9szypegfv7ya&start-date=2014-02-01&end-date=2016-06-29&metrics=views : (400) invalid query. query did not conform expectations". could please me resolve issue. in advance. using service account not supported youtube analytics , reporting api the service account flow supports server-to-server interactions not access user information. however, the youtube reporting api , youtube analytics api not support flow . since there no way link service account youtube account, attempts authorize requests flow generate error. unfortunately, need oauth2 report. resources can check information: youtube analytics api php invalid query. query did not conform expectations implement oauth 2.0 authorization

java - Gradle Build failed in Android Studio 2.1.1 : 'app:compileDebugJavaWithJavac' (wrong path) -

Image
i opened application co-worker. if want run app on device comes error: error:execution failed task ':app:compiledebugjavawithjavac'. java.io.filenotfoundexception: c:\users\z565719\androidstudioprojects\drescherbluetoothcancom\app\src\main\java\lib\api_adk.jar i know path not correct it's not possible find file. can change path , error want say? i found several articles same error, for example one, but none of them solve problem. by way, i'm using gradle version 2.1.0 , jdk1.8.0_91! right click on module root , click "open module settings" go dependencies tab , remove dependency causing error. add again correct path.

multithreading - C# SignalR Client -

i'm using signalr client version 2.2.0 nuget. this._connection = new hubconnection(this._url); this._connection.closed += this.connectiononclosed; this._connection.error += this.connectiononerror; servicepointmanager.defaultconnectionlimit = 250; this._client = this._connection.createhubproxy(hubname); this._connection.start(new websockettransport()).wait(); then reuse client every time (multi-threaded): client.invoke<bool>(nameof(this.addifnotexists), key, data, expireafter) parallel.for( 0, 50000, new paralleloptions { maxdegreeofparallelism = 10, }, async (i) => { var result = await client.executedistributedasync( (i % 2).tostring(), timespan.fromseconds(5), async () => { await task.delay(500); return

haskell - How to "compose" Iso's? -

here type: newtype sanedate = sanedate universaltime deriving (show, eq, typeable, generic) makewrapped ''sanedate now need iso type: reprbuild :: iso' (maybe universaltime) (fist sanedate) i did this: reprbuild = iso (\ t -> first (sanedate <$> t) ) (\ sane_first -> fmap (^. _wrapped) $ getfirst sane_first ) but have impression i'm working extra-hard. there (shorter) way of writing reprbuild iso composition of things? recent versions of lens have built in : reprbuild = coerced of course, requires safe coercions available since 7.10; backwards compatibility use manual approach mapping .

javascript - Detect Internet-Loss in Cordova app -

in cordova-app running on android 5 device need know if device goes offline. doing according cordova-documentation : document.addeventlistener("offline", onoffline, false); function onoffline() { // handle offline event } for testing code, have connected android device (which doesn't has mobile-data-connection) wifi-access-point, connected internet. as shutdown wifi-access-point event "offline" gets fired, , application knows it. far good. unfortunately there use case in code-sample doesn't work: image same situation: android-device connected wifi-access point, connected internet. if disconnect wifi-access point (pull lan-cable), leave hotsport running, cordova application never know it. user can't internet related things anymore (because there no internet obviously), "offline" event never gets fired! is there workarround this? how can check if device lost internet-connection, if there still active wifi-connection?

sql - Calculating closing (sums of two views, including the past) -

i trying remaining number of working units each month, of sum between bought number of working unit, , consumed number of working unit. i tried 2 possibilities, both have flaws : in first test, created "months" table contains every month , every year, in order show months in final matrix wish create these data. one, closing whenever there consumed working unit, when there not, column "empty", because not last closing. use otrs_revised select [customer], case when [year] < 2016 1 else [year] end [year], case when [year] < 2016 0 else [month] end [month], [closing] total, sum([closing]) on (partition [customer] order [year], [month] rows unbounded preceding) closing [dbo].[wu_closing_view] [customer] in ('customerlist') group [customer], [year], [month], [closing] union select '' customer, case when [year] < 2016 1 else [year] end [year], case when [year] < 2016 0 else [month] end [month], &