myDBR Forums » General discussion

NULL as a constant in a linked report

(2 posts) (2 voices)

  1. situ, Member

    Hi,

    Can you pass NULL as a constant in a linked report?

    For example I would like to do the following

    select 'dbr.report','mySharedReport','new_window','myInt1=-1','myInt2="NULL"','myInt3=-4';

    The variables are all integers. My testing has been unsuccessful as I can only get mydbr to see it as a column heading or a text string.

    Your doing a great job :-) Great tool. My clients are demanding but happy :-)

    Thanks

  2. myDBR Team, Key Master

    Null constants are not supported. You can pass a magic number and convert it to NULL inside the report.

    --
    myDBR Team


Reply

You must log in to post.