Wiki

SAP BUSINESS ONE

None Defined

Columns in Report Preview hidden when updating the Selection Criteria of Financial Statement Reports

http://wiki.scn.sap.com/wiki/pages/viewpage.action?spaceKey=PEQ&original_fqdn=wiki.sdn.sap.com&title=Columns+are+not+displayed+correctly

1.Find the formid, itemid of the problematic grid. a) Open SBO, find the problematic grid in a form. b) Enable the System/Debug information(Go to Menu→View, check System/Debug information). c) Put the mouse on any field of the problematic grid, find the formid (The number after `Form=`) and the itemid(The number after `Item=`) on the status bar at the left bottom of SBO. d) Record this formid and itemid. 2.Close SBO. Make sure no SBO clients are connected to the server. (This step is very important! If SBO is not closed, this solution won`t work.) 3.Open SQL Analyzer, run the update query below.

      Before running the query, do please replace:
       /!Formid found in Step 1!/  to the formid found in step 1.
       /!Itemid found in Step 1!/  to the itemid found in step 1.
       /!Problematic User Code!/   to the user code of problematic user.

1. -begin
   1. -delete all the user settings

         delete cprf where formid=`/!Formid found in Step 1!/` -- for this form
           and itemid=`/!Itemid found in Step 1!/` -- and this document
           and usersign =
          (
                select internal_k from ousr where
                user_code = `/!Problematic User Code!/`
            )
       --end

4. Open SBO, and check whether the issue is solved.

Solution

17 Mar 2014