Not all data exporting to excel

(3 posts) (2 voices)

Tags:

No tags yet.

  1. messygr, Member

    I have a report with three main parts:

    1. three 'dbr.text' lines
    2. a table from sql query
    3. three more 'dbr.text' lines

    When exporting to excel part 3 is missing.
    What can be the problem?

  2. myDBR Team, Key Master

    The dbr.text does require a result set to complete. To show them, you can, for now, add an empty result set after it:

    select 'dbr.hideheader';
    select 'dbr.hidefooter';
    select null;
    from dual
    where 1=0;

    --
    myDBR Team

  3. messygr, Member

    Thank you!


Reply

You must log in to post.