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 'dbr.report', '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 'dbr.report', '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 support@mydbr.com

Reply

You must log in to post.