matrix - Summarize multiple rows in crosstab -


my crosstab has erp users row, , available security roles column. roles appear on top of report vertically, , users on left side horizontally.

suppose every user has different , multiple roles erp. myself have three. in report, under summarized values, want have character 'y' appear in front of name , under roles. how can configure this?


Comments

Post a Comment

Popular posts from this blog

string - Using python and postgres, variables within execute function? -

i had question regarding usage of variables inside python function accesses postgresql server. example, following: def delete(): cur.execute( """delete potluck name = var_1;""" however, if wanted update function take in variables var_1, how so? for example, want function in form: def delete(var_1): cur.execute( """delete potluck name = %s;""", (var_1)) however, typing didn't work. in addition, how in case when: def delete(name, var_1): cur.execute( """delete potluck %s = %s;""", (name, var_1)) where don't want "name" have quotation marks when inserted string? any appreciated! to pass identifiers use psycopg2.extensions.asis from psycopg2.extensions import asis def update(table_name, var_1, var_2): cur.execute(""" update %s set %s = 'y' %s = 'john'; ...
Read more

android - How to get the Uri path from a ImageView? -

i trying create wallpaper application. images come internet. before of set background, need crop image. , this, using api named androidimagecropper. api need of uri object execute crop. how can uri imageview? because image internet. image not on drawable folder. confusing. maybe guys can me. public class mainactivity extends appcompatactivity { private networkimageview imageview; private uri mcropimageuri; public static final string url_photo = "http://cdn.wonderfulengineering.com/wp-content/uploads/2016/02/iron-man-wallpaper-42-610x1084.jpg"; @override protected void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); setcontentview(r.layout.activity_main); imageview = (networkimageview) findviewbyid(r.id.image_view); // singleton volley api, load image internet imageloader loader = mysingleton.getinstance(this).getimageloader(); loader.get(url_photo, imageloader.getimagelistener(imageview, r.drawable.temp_picture, ...
Read more