Linked Report Parameters causing "Missing security hash in report url" - due to # symbol

(5 posts) (2 voices)
  1. brycedcamp, Member

    I am passing a bunch of parameters to a linked report for editing. One of the fields frequently contains a "#" symbol which causes problems for the popup linked report.

    This is how I am trying to pass that data:

    select '', 'sp_DBR_activejobsshop_edit', 'Job #[jobnum]', 'popup', 'inJobNum<=jobnum', 'inPurchNotes<=purchnotes' ........

  2. myDBR Team, Key Master

    The column reference should only contain the column reference, not the visible column name. Try the following format:

    select '', 'sp_DBR_activejobsshop_edit', '[jobnum]', 'popup', 'inJobNum<=jobnum', 'inPurchNotes<=purchnotes'...

    myDBR Team

  3. brycedcamp, Member

    I tried that but it didn't help. The only way I can get around this is to remove the "#" from the column in the database, but the users would like to retain that character.

  4. myDBR Team, Key Master

    Could you run the report with '&export=sql' added to the URL and send the output to support email. The '#' character should not cause any problems.

    myDBR Team

  5. brycedcamp, Member

    Sent via attachment to


You must log in to post.