Date Picker bug? How can I refresh the picker's value?

    Date Picker bug? How can I refresh the picker's value?

    Hi,

    as you can see in the attached files I use a date picker that should be used in a dynarange as attribute filter.
    The problem: Whenever I start the report, the excel cell does not have the date picker's value. The user first has to click in to each datepicker, select a (new) date and only then the cell that refers to the datepicker is updated and the report works correctly.
    Whenever the report is started the dynarange's content is wrong because the cell that is used for the attribute filter contains the wrong content...

    Is this a bug?
    Is there a way to refresh this data via macro?

    Thanks for your help!

    Florian

    PS: My jedox:
    Jedox Release 5.1.0
    (Windows NT 6.1)
    Frontend
    Version: 5.1.0.11558
    OLAP Client Version: 5.1.2.2708
    Datum: 2014-07-24 13:54:44 +0200
    Spreadsheet Server
    Version: 5.1.4.7294 (451)
    OLAP Client Version: 5.1.4.2708
    Success Charts Version: 5.1.4.268
    Datum: 2014-07-31 13:01:34 +0200
    OLAP Server
    Version: 5.1.4.5577
    ETL Server
    Version: 5.1.4.4237
    Scheduler Server
    Version: 5.1.316
    Images
    • 2015-11-10 08_22_07-Jedox Web.png

      22.31 kB, 521×381, viewed 115 times
    • 2015-11-10 08_29_05-Jedox Web.png

      16.6 kB, 561×537, viewed 109 times
    Hello Florian,

    I have the same issue before what you can do is to have a macro that will set a default value in the picker once you open the report in my case I used 0 so that whenever I open my report it will not show anything until the user opted desire dates:
    I've use the following code in macro.

    function __open()
    {
    $day = "0";
    define_variable('datapicker1', $day);
    $day2 = "0";
    define_variable('datapicker2', $day);
    }

    function __close()
    {
    $day = "0";
    define_variable('datapicker1', $day);
    $day2 = "0";
    define_variable('datapicker2', $day);
    }


    Hope this helps.

    Thanks
    Rose