Report and iFrame method problem

[mariorog]

I have generated a simple Report and I use a "Run" object to display it.

Now ... IF I set "Method: Button" the output (new window ) is perfect including labels and fields derived from Sql, BUT if I set "Method: iFrame" the output report shows ONLY labels and NOT field values: how is it possible ?
Many thanks in advance for your support.

[kev1n]

Hi,

I can't replicate this issue on my end using "Method: iFrame". All values are displayed.
I really have no idea what's going wrong. Maybe someone else?

[mariorog]

Dear Kev1n,

thanks for your replay.
I understand that this issue is a little bit strange.
The only different between the two outputs is the setting of the method.

In order to provide more input details to the community ... attached the Query SQL and screenshots of the the setting.

Grazie.

[mariorog]

Hi,

I can't replicate this issue on my end using "Method: iFrame". All values are displayed.
I really have no idea what's going wrong. Maybe someone else?

Kev1n,

in order to replicate this issue from your side, I would just suggest to include in your SQL query a simple clause " .... WHERE myTable.myField = '#abcdef#' ".
Of course, you should have somewhere the Field #abcdef# (Input Text object) in your Form.
I am asking to do this test because from my side I tried to modify my SQL query with (for example) " .... WHERE myTable.myField = 12345 " and it worked perfectly. Apparently the only Method:iFrame does not pick up Field values from Form.

Many thanks in advance for your support.

[kev1n]

Okay, I understand the issue. Maybe Steven (the developer) can look into it?

[kev1n]

Ciao, have you found a solution yet?

[mariorog]

Ciao, have you found a solution yet?

Ciao Kev1n ... unfortunately still I did not find a solution.
I hope strongly Steven may have a look into this issue and give us some indication.

To me this is an important point because I am re-writing in "Nubuilder Forte v4" a previous huge "Nubuilder v3" application (written in 2016) because, starting from middle June 2019, when Chrome, Firefox, Opera made an update of the browser ... ALL Reports of my application stopped to work correctly (see below a screenshot). Safari browser, instead apparently still has no problem with Nubuilder v3.

I am crossing the fingers.

[admin]

mariorog,

Upload a copy of your database and we'll take a look.

Steven

[kev1n]

Hi Steven,

I've attached a sample that illustrates the issue.

If the report is run in a new tab (Run object, Method Button), all values are shown.

run_report_tab.png

If the report is run within an iFrame (Run object, Method iFrame), no values are shown (root cause: hash cookie field00 is not replaced)

run_report.png

In the SQL, the field00 Hash Cookie is referenced. Its value is set to "calc" in the form.

Code: Select all

SELECT
    zzzzsys_object.*

FROM
    zzzzsys_object where sob_all_type = '#field00#'

[mariorog]

Hi Steven,

I've attached a sample that illustrates the issue.

If the report is run in a new tab (Run object, Method Button), all values are shown.

run_report_tab.png

If the report is run within an iFrame (Run object, Method iFrame), no values are shown (root cause: hash cookie field00 is not replaced)

run_report.png

In the SQL, the field00 Hash Cookie is referenced. Its value is set to "calc" in the form.

Code: Select all

SELECT
    zzzzsys_object.*

FROM
    zzzzsys_object where sob_all_type = '#field00#'

Dear Kev1n,

EXACTLY !!! Your example has perfectly replicated my issue.


@Steven: unfortunately I cannot send to you a copy of the database because it includes "sensitive" data (name, surname, addressess, ... ). But Kev1n has well identified the problem. In anycase I will provide again a donation in order to support this forum & Nubuilder sw.

Have a nice day.