I am creating my first report and am having problems getting any output. I started by clicking on Setup Add Activities Add Record All tab.
I entered a code of ‘PEOPLERPT’, description of ‘People List’, Group was blank, Type was ‘Report’ and Selection Criteria Form was set to ‘Blank’.
I then clicked on the ‘Report’ tab and entered the following PHP Code
Code: Select all
$sql = "CREATE TABLE #dataTable# SELECT * from people" ;
nuRunQuery($sql);
I went back to the Setup Tab and clicked on the ‘Run Activity’ button. I clicked on ‘PEOPLERPT’ in the browse form. When I clicked on the ‘Print to Screen’ button, I got a message that said,
. I assume this is because I had set ‘Selection Criteria form’ to ‘Blank’.‘Name’ cannot be left blank
How do I get around this problem? The video tutorial said to use ‘blank’ or a form where fields in a report were turned on. I saw one reference in the forum with this error. The suggestion was to change the value of a field in a system table to ‘0’ based on a primary key value but it was not clear which row needed the value changed.
What do you suggest?
John