User ID issue after moving from v8 to v9

This public forum is for user-to-user discussions of ASP Report Maker. Note that this is not support forum.

User ID issue after moving from v8 to v9

Postby yeehoy » Fri Jan 13, 2017 7:03 am

I recently moved from ASPRM v8 to ASPRM v9. All I did was reload the .arp files from v8 and regenerated in v9. My project uses the User ID Security on field ClientID. With v9 in the Extended filter for dropdowns it is showing all records irrespective of the User ID security.

I noticed that it's been a while since v9 had an update. Are there any recent fixes in the template that I can download?

THanks...
yeehoy
 
Posts: 96
Joined: Wed Nov 21, 2012 11:14 am

Re: User ID issue after moving from v8 to v9

Postby motfs » Tue Jan 17, 2017 3:25 pm

Try to add the following codes to usercode.js (in this folder "C:\Program Files (x86)\ASP Report Maker 9\src"):

SYSTEMFUNCTIONS.LookupSql.replace('Call ewr_AddFilter(sWhereWrk, UserIDFilter)', 'Call ewr_AddFilter(sWhereWrk, Page.UserIDFilter)');
motfs
 
Posts: 710
Joined: Tue Sep 08, 2015 4:55 pm

Re: User ID issue after moving from v8 to v9

Postby yeehoy » Wed Jan 18, 2017 6:00 am

Thanks motfs.
yeehoy
 
Posts: 96
Joined: Wed Nov 21, 2012 11:14 am


Return to General Discussion (ASP Report Maker)