1. 

   spyhunter88, Member

   Hi team,

   I have find this error while my parameter have ampersand symbol (&) inside.

   Do u have any update to fix this or work around?
2. 

   myDBR Team, Key Master

   Hi,
   could you please open a support ticket with SQL export of the report so we can replicate the issue.

   --
   myDBR Team
3. 

   spyhunter88, Member

   I found hard to demonstrate this issue. Please use my sql:
   DROP PROCEDURE IF EXISTS sp_DBR_TEST_Demo $$ CREATE PROCEDURE `sp_DBR_TEST_Demo`(inTCode varchar(30), inCCode varchar(30), inCName varchar(100)) BEGIN

   select 'dbr.javascript', ' function confirmdel(obj) { return confirm(\'Delete Note of Tax Code: \\\'\'+$(obj).parent().children().eq(1).text()+\'\\\'?\'); }';

   select 'dbr.report', 'sp_DBR_AR_update_Note', 'popup_new[]', '[T_Code]', 'inID=ID', 'inCom*=Company', 'inBU*=BU', 'inCenter*=Center', 'inDept*=Dept', 'inGeo*=Geo', 'inTaxCode*=T_Code', 'inCustCode*=C_Code', 'inCustName*=C_Name', 'inDate<=(inDate)', 'inNote<=Note', 'inAction=""'; select 'dbr.report', 'sp_DBR_AR_update_Note', 'popup_new[]', '[del]', 'inID=ID', 'inCom*=Company', 'inBU*=BU', 'inCenter*=Center', 'inDept*=Dept', 'inGeo*=Geo', 'inTaxCode*=T_Code', 'inCustCode*=C_Code', 'inCustName*=C_Name', 'inDate<=(inDate)', 'inNote=Note', 'inAction="Delete"', 'event=click', 'callbefore=confirmdel', '"Delete Note"';

   select 'dbr.subtitle', 'Note List: T Code: 090 - C Code: 9358 - C Name: Công ty TNHH Thương Mại &Dịch Vụ Điện tử Quang Long';

   select 'dbr.column.title', 'T_Code', 'T Code';

   select 'dbr.hidecolumn', 'ID', 'Cust_Code', 'Company', 'BU', 'Center', 'Dept', 'Geo'; select 'dbr.hidecolumn', 'Cust_Name';

   select 'dbr.column.title', 'Date_Note', 'Added Date'; select 'dbr.column.filter', 'Date_Note', 'select'; select 'dbr.column.filter', 'T_Code', 'select'; select 'dbr.column.filter', 'Cust_Name', 'text'; select 'dbr.column.filter', 'Scope', 'select'; select 'dbr.column.filter', 'Imported_Date', 'select';

   select 'dbr.calc', 'percent', '([Total_Over])/[Amount]*100'; select 'dbr.calc', 'percent_7', '([Over_7_Days])/[Amount]*100'; select 'dbr.calc', 'percent_15', '([Over_15_Days])/[Amount]*100'; select 'dbr.calc', 'percent_30', '([Over_30_Days])/[Amount]*100'; select 'dbr.calc', 'percent_60', '([Over_60_Days])/[Amount]*100'; select 'dbr.calc', 'percent_90', '([Over_90_Days])/[Amount]*100';

   select 'dbr.colstyle', 'Note', '[background-color:#FFFF99;]'; select 'dbr.colstyle', 'Amount', '%.0f'; select 'dbr.colstyle', 'Total_Over', '[background-color: yellow;color: red;]%.0f'; select 'dbr.colstyle', 'Over_7_Days', '[background-color: #CCEEFF;color: red;]%.0f'; select 'dbr.colstyle', 'Over_15_Days', '[background-color: #CCEEFF;color: red;]%.0f'; select 'dbr.colstyle', 'Over_30_Days', '[background-color: #CCEEFF;color: red;]%.0f'; select 'dbr.colstyle', 'Over_60_Days', '[background-color: #CCEEFF;color: red;]%.0f'; select 'dbr.colstyle', 'Over_90_Days', '[background-color: #CCEEFF;color: red;]%.0f'; select 'dbr.colstyle', 'percent_7', '[color: grey;]%.2f'; select 'dbr.colstyle', 'percent_15', '[color: grey;]%.2f'; select 'dbr.colstyle', 'percent_30', '[color: grey;]%.2f'; select 'dbr.colstyle', 'percent_60', '[color: grey;]%.2f'; select 'dbr.colstyle', 'percent_90', '[color: grey;]%.2f';

   select 11407 as 'ID[ID]', '20-03-2017' as 'Date Note[Date_Note]', '090' as 'T_Code[T_Code]', '9358' as 'C_Code', 'Công ty TNHH Thương Mại &Dịch Vụ Điện tử Quang Long' as 'C_Name', '123 BB' as 'Scope', '123' as 'Company', '' as 'BU', '' as 'Center', '' as 'Dept', 'HN' as 'Geo', 'FDC HN: 3ergergyyu56 sf wetertwer qwerqweqe as356345' as 'Note', 18 as 'Day_Over', 1 as 'Amount[Amount]', 1 as 'Total_Over', null as 'percent', 1 as 'Over_7_Days', null as 'percent_7', 1 as 'Over_15_Days', null as 'percent_15', 0 as 'Over_30_Days', null as 'percent_30', 0 as 'Over_60_Days', null as 'percent_60', 0 as 'Over_90_Days', null as 'percent_90', '20-03-2017' as 'Imported Date[Imported_Date]', 'delh2' as 'User_Note', 'dbr.purehtml:<div class="i_delete"></div>' as '[del]' union all select 10527, '16-01-2017', '090', '9358', 'Công ty TNHH Thương Mại &Dịch Vụ Điện tử Quang Long', '123 BB', '123', '', '', '', 'HN', '123 BB: nmjhtyutyuut', 22, 1, 1, null, 1, null, 1, null, 0, null, 0, null, 0, null, '16-01-2017', 'delh2', 'dbr.purehtml:<div class="i_delete"></div>' union all select 10148, '05-12-2016', '090', '9358', 'Công ty TNHH Thương Mại &Dịch Vụ Điện tử Quang Long', '123 BB', '123', '', '', '', 'HN', '123 BB: hbfgh sertertrt werw', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'delh2', 'dbr.purehtml:<div class="i_delete"></div>' union all select 10047, '28-11-2016', '090', '9358', 'Công ty TNHH Thương Mại &Dịch Vụ Điện tử Quang Long', '123 BB', '123', '', '', '', 'HN', '123 BB: 345fs gefgty asdfsdfsrt werwer', 30, 1, 1, null, 1, null, 1, null, 0, null, 0, null, 0, null, '28-11-2016', 'delh2', 'dbr.purehtml:<div class="i_delete"></div>';

   select 'dbr.report', 'sp_DBR_AR_update_Note', 'popup_new[]', 'inID="0"', 'inCom<=""', 'inBU<=""', 'inCenter<=""', 'inDept<=""', 'inGeo<=""', 'inTCode*=(inTCode)', 'inCCode*=(inCCode)', 'inCName*=(inCName)', 'inDate<="2017-04-04"', 'inAction=""'; select 'dbr.button', 'Add Note';

   select '1' as '1';

   END $$

   I removed some necessary inputs like inID, inCom ..... Also truncate some sensitive data.
   The inCName contains special symbol "Công ty TNHH Thương Mại &Dịch Vụ Điện tử Quang Long".
   When I click the Add button at the bottom, it shows "Report security hash does not match. Report execution aborted." Error.
   I found it recently appeared in current build (3258), the previous builds worked because my client has some data on this.
4. 

   myDBR Team, Key Master

   The issue came when you had a button which triggered a popup for the parameters and one of the parameters contained an ampersand. This has now been fixed in the latet build. Thanks for pointing this out.

   --
   myDBR Team

Reply

You must log in to post.