Welcome to the nuBuilder forums!

Please register and login to view forums and other content only available to registered users.

Report generates empty page

Locked
johnbertell
Posts: 14
Joined: Thu Oct 24, 2013 6:32 am

Report generates empty page

Unread post by johnbertell »

Hi,
I am trying to build reports for my application but have struggled. Right now my nuBuilder only generates absolutely empty pages for the reports I built. I have tried installing the samplefinancial, and I get the same result on the reports which are there. When I press 'Print to screen' from the criteria form it generates an empty browser. The page source of the new browser page is completely empty. Exactly the same result from Print to PDF.
Anyone having a good idea where I should start troubleshooting?
John
massiws
Posts: 503
Joined: Thu May 24, 2012 2:08 am
Location: Milan, Italy
Contact:

Re: Report generates empty page

Unread post by massiws »

johnbertell, based on my experience, white pages often result from errors in PHP code.
Some suggestions:
  • are you sure about minimal resources required by nuBuilder? (see here);
  • are you sure your code in Report Builder is working right?
  • are you able to build the #dataTable# with all data you need on the report?
Max
johnbertell
Posts: 14
Joined: Thu Oct 24, 2013 6:32 am

Re: Report generates empty page

Unread post by johnbertell »

Thanks Max for quick response.
  • I have the min resources configured just like in the link you sent me
  • I am new to using the reports, so this was my first thought. That is why I installed the samplefinancial and tested the reports which exist there. And they produce the same result. Just for testing I made a very simple report with as little possibility for error as possible showing only one field and one label.
  • This is the php code for my simple test report:

Code: Select all

$str = "CREATE TABLE #dataTable# SELECT NOW() AS d ";
nuRunQuery($str);
I have tried to get the sql statement debugged there also, but it will not bring up the debug window.
John
johnbertell
Posts: 14
Joined: Thu Oct 24, 2013 6:32 am

Re: Report generates empty page

Unread post by johnbertell »

This seem to be the error. I get the same on two of my Linux machines (UBUNTU) but not on the third one.

Code: Select all

Wed Dec 25 13:54:08.310141 2013] [:error] [pid 22959] [client 10.102.164.74:44039] PHP Fatal error:  Cannot redeclare hex2bin() in /var/www/productionnu2/report_object.php on line 240, referer: http://10.64.0.115/productionnu2/form.php?x=1&f=run&r=152b98294d2234&dir=db/tankbulk&fly=&ses=152bac727e0e1f&BF=&newwin=0&historySession=152bac72aacef3&historyIndex=2&historyLocation=QnJvd3NlfHx8UnVuIEFjdGl2aXR5|||aHR0cDovLzEwLjY0LjAuMTE1L3Byb2R1Y3Rpb25udTIvYnJvd3NlLnBocD94PTEmcD0xJmY9cnVuJnM9Jm51b3BlbmVyPTE1MmJhYzcyYWE2NDNjJnByZWZpeD0mZGlyPWRiL3RhbmtidWxrJnNlcz0xNTJiYWM3MjdlMGUxZiZmb3JtX3Nlcz0mbG9va3VwX2NvZGU9Jmhpc3RvcnlTZXNzaW9uPTE1MmJhYzcyYWFjZWYzJmhpc3RvcnlJbmRleD0xJmhpc3RvcnlMb2NhdGlvbj1mSHg4U0U5TlJRPT18fHxhSFIwY0Rvdkx6RXdMalkwTGpBdU1URTFMM0J5YjJSMVkzUnBiMjV1ZFRJdlptOXliUzV3YUhBL2VEMHhKbVk5YVc1a1pYZ21jajB0TVNaa2FYSTlaR0l2ZEdGdWEySjFiR3NtYzJWelBURTFNbUpoWXpjeU4yVXdaVEZtSm5SaFlqMHomdGFiPTA=
John
johnbertell
Posts: 14
Joined: Thu Oct 24, 2013 6:32 am

Re: Report generates empty page

Unread post by johnbertell »

Now got it fixed, here is the solution. Appearently a problem everyone with PHP 5.4 or newer versions will have.
http://forums.nubuilder.cloud/viewtopic.p ... in+#p11827
John
massiws
Posts: 503
Joined: Thu May 24, 2012 2:08 am
Location: Milan, Italy
Contact:

Re: Report generates empty page

Unread post by massiws »

John, sorry for delay: are your reports working fine now?
johnbertell
Posts: 14
Joined: Thu Oct 24, 2013 6:32 am

Re: Report generates empty page

Unread post by johnbertell »

Yes, thank you Max. With this fix they work fine.
John
massiws
Posts: 503
Joined: Thu May 24, 2012 2:08 am
Location: Milan, Italy
Contact:

Re: Report generates empty page

Unread post by massiws »

.
Locked