Inline Reports showing empty rows

(9 posts) (2 voices)
  1. nsepetys, Member

    Hello myDBR Representative,

    How are you doing? I am trying to do a simple inline report (using myDBR version 4.3.3). I have done multiple tests that reassure me that the report linking (specifically new_window) is working. I'm guessing it has to do with how my browser is interacting with the scripts but even after enabling any and all scripts to run on the page I'm still not seeing anything except a blank row shown beneath where I clicked. The demo's ( )inline reports work fine so I'm not sure why I can't get this working on our server. I do notice that the page can no longer be securely connected via https because there are sources that are "not secure". Not sure if I can work around this if it's the issue.

    I just tried tweaking the "All Countries" demo report on our server but even after switching those new_window linked reports to inline, I cannot seem to get inline working. The code I used for the demo was:

    SELECT '', 'sp_DBR_demo_country', 'inline','inCode=2';

    Any help would be appreciated.


  2. myDBR Team, Key Master

    I do notice that the page can no longer be securely connected via https because there are sources that are "not secure".

    What do you mean by this?

    Do you have a proxy or some other kind of redirect happening in your setup?

    myDBR Team

  3. nsepetys, Member

    Hopefully the screenshot from Chrome is self explanatory:

    I have also used firefox and internet explorer to verify it wasn't just Chrome misbehaving. All browsers behave the same- they show an empty row instead of the inline report.

  4. myDBR Team, Key Master

    How does the http link for the inline linked report look like in Chrome JavaScript debugger?

    myDBR Team

  5. nsepetys, Member

    When I grab the link directly from the source code it works. Here is a snippet from the first link that should have a working inline report. I have omitted some parts of the URL for security reasons but I think the main components of the code are there:

    < a ref="javascript:void(0)"style="color:inherit;"onclick="embed_element('inline','http://*.*.com/mydbr/report.php?r=*&p1=109109&m=*&h=*&i=1','109109',this);">109109< / a>

    Let me know if you need more context.

    PS: Please ignore the funky spacing in the tags. It was the only way I could get this stuff to show in plain text.

  6. myDBR Team, Key Master

    Are you using a reverse proxy or a load balancer?

    myDBR Team

  7. nsepetys, Member

    I was told by our network administrator that we are using a proxy.

  8. myDBR Team, Key Master

    What happens is that myDBR checks the HTTP headers if it is running over secure connection. The proxy you are using does not seems to be confugured in a way that myDBR could detect the protocol being used. Normally this is done via by setting HTTPS, SERVER_PORT or HTTP_X_FORWARDED_PROTO variables.

    You can force myDBR to generate the links to use https by adding following definition to user/defaults.php:

    $mydbr_defaults['https']['https_in_use'] = true;

    Alternatively you can check it the proxy provided headers can be changed.

    myDBR Team

  9. nsepetys, Member

    That was the issue. Inline reports are now working. Thank you for your help!


You must log in to post.