sql - Get Next Value within Row Groups in SSRS -


i have problem i'm trying solve getting nextrow value within specific rowgroup.

here's i'm trying do:

if fields!interventions.value not blank , nextrow(fields!dateoccurred.value) within group within 4 hours y else n

and column:

if fields!interventions.value not blank compare currentrow(fields!dateoccurred.value) nextrow(fields!dateoccurred.value) , display differences in hours

but i'm stuck how expression within ssrs.

i saw following question: get previous,current , next record in ssrs report in page issue 1 doesn't work row groups in ssrs.

upon further advise, appears isn't possible in ssrs, possible in query itself.

this query i'm working with:

select      row_number() over(partition r.patientid, pl.chartlocationid order p.dateoccurred asc) row#,     r.namefirst,     r.namelast,     p.dateoccurred,     case p.interventions     when 1 'regular analgesia'     when 2 'heat pack'     when 4 'cold pack'     when 8 'massage'     when 16 'exercise'     when 32 'other'     end interventions      chartentry p left join chartlocation pl on     p.chartlocationid = pl.chartlocationid   inner join resident r on     pl.residentid = r.patientid       p.datedeleted null ,     p.dateoccurred >= '01 jul 2017' ,     p.dateoccurred < '01 aug 2017'

is possible achieve?

here sample data showing results 2 columns: enter image description here

easiest , better way use lag/lead in sql figure out.


Comments

Post a Comment

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

i've set bento/ubuntu-16.04 vagrant box using php 5.6, , getting following error quite few times when try , run shell script: "uncaught reflection exception: class domdocument not exist". i've tried adding following top of script (not together), each no success: "sudo apt-get install php5.6-xml", "sudo apt-get install php5-xml", "sudo apt-get install php-dom" i've tried resetting server "sudo service apache2 restart". does have suggestions?
Read more

vue.js - Create hooks for automated testing -

Image
qa guys complained can't automate frontend testing. because our html looks same outside. lazy hack did this <template> <div :role="$options.name"> ... </div> </template> <script> export default { name: 'vmcomponentname' } </script> which takes name script , applies html. in browser get: <div role="vmcomponentname"> ... </div> line :role="$options.name" goes in every component. is there dry er solutions? please share. additional details i'll explain in details looking for. imagine have vmusercreate form creates user. test case can create user . to automatically test without role, have use following selector: .wrapper > .wrapper > .wrapper > .submit-button the test extremely brittle (will break lot). if use roles can use [role="vmusercreateform"] .submit-button selector. many folds less brittle. so basically, i'm ...
Read more

Add new key value to json node in java -

i have json file : { "id":1, "name":"abc", "addressdetails": { "city":"newyork" } } i wanted add 1 more key-value ("pincode" : "414141") node 'addressdetails'. i tried using : objectmapper mapper = new objectmapper(); jsonnode root = mapper.readtree(new file("d://test.json")); objectnode node = mapper.createobjectnode(); node.with("addressdetails").put("pincode", "414141"); but it's not getting added, there way can ? you can try you should modify file path objectmapper mapper = new objectmapper(); objectnode nodes = mapper.readvalue(new file("d:\\test.txt"), objectnode.class); nodes.with("addressdetails").put("pincode", "414141"); mapper.writer().writevalue(new file("d:\\test.txt"), nodes);
Read more