itgroup

Hi, We have a dataset like this with the first 3 columns. We want to add the 4rth calculated field "Difference". Seems simple, but can't make it work. The years (2015, 2016) are part of column measures ... so potentially there would be more than 2 ... which I assume is what makes this hard. Any ideas? Thanks! Customer20152016DifferenceCustomer A500600100Customer B1000800-200

Lol. user = postgres original password = postgres But anyone else facing this problem should look at marianol's answer.

Lol. user = postgres original password = postgres

I changed the password for db username = postgres It appears that JasperReports had the old password in some config(s) file and now it doesn't work. What do I need to do here? I'm guessing I need to find the relevant config files and update them? If so, which ones? If not, what do I do?

SOLVED: For other users out there, superuser, and every other user needs ROLE_USER to function. I didn't have a dbuser password so: Dropped into user postgres to find pg_hba.conf (for me it was in /var/lib/pgsql93/data/pg_hba.conf)Added this to the first line: local all all trustlocal all all trustlocal all all trustlocal all all trustlocal all all trust (security alert!! this needs to be reverted back right away when you are done - you might want to use whitelisted IPs only in your firewall config when doing this)psql -U postgresgave postgres a new password (and this caused me problems I'm still working on)connect jasperserverUPDATE jiuserrole SET roleid = 5 WHERE userid = 10;Now superuser is back to ROLE_USER Now I have to figure out where to add the new password for postgres in the relevant configs because Jasper is now not working due to that changed password. EDIT: Regarding #4, the original password for postgres is ... drumroll .... "postgres".

I was experimenting with roles and noticed that Superuser only had ROLE_USER. I removed ROLE_USER and added ROLE_SUPERUSER Now when I log in, I don't have permission to view anything nor do I have access to the Manage tab. ????? How is this even possible? Shouldn't superuser always have access? Is this just bad design? How do I fix this? Can I add/remove roles from the db. If so, can you please tell me how?