nuBuilder Forum

I have created my first report without creating a criteria form. So, it does not show up on the list of reports to run. After reading some forum entries I think I can make a button to launch the form, but the form needs more work.

Q 1) How do I edit the form or even delete it and create a new one that is editable?

Q 2) Once I create and specify a criteria form will I be able to edit the report? Of course, I can't do this until I get the answer to Q 1.
A 2) NO! I have created and set the criteria form in the zzzsys_report record. Now the report appears in the Run Report list. It still does not show on the Reports list. So, I still don't know how to edit it. Additionally I not sure removing the zzzsys_report entry actually deletes the report. I think zzzsys_report only holds the header record for reports. So, I have a Q 3).

Q 3) After deleting the zzzsys_report record for a report aren't there still report detail records to get rid of? How do I do that?

Also, when you go to run a report and then decide against it, there is no home button. I guess you have to close the window and start nuBuilder again. This doesn't seem right.

Thanks in advance for any help.

WR,

Does the report in question appear in the list for 'Add Reports'?

Steven

No. That list is empty. It's the list that comes up when I click on Reports. It has no entries even though I now have 2 reports that show up when I click on Run Report. I can run the reports. I know they are in there somewhere.

I'm assuming my report should show up on the the list I get when I click on Reports; and that when I click on my report it will let me work on the report with the builder again; but there's nothing there to click on.

Thanks for asking about the problem.

What's next?

Bill

I went to the video tutorials and located what I needed to do. I needed to provide a PHP routine. With the PHP code name entered in the Report Edit Form, the report now shows up on the list. I don't have any toruble with doing this, but allowing the SQL statement to be entered on the Add Report Edit Form implies that having separately saved PHP code is not necessary; and there is no warning to tell you it's needed.

So, this is now a bug report instead of a plea for help.

Hope this helps improve the product.

Thanks you.

Bill Bailey

Bill,

I don't know what you are talking about. You dont need the PHP if you have the SQL.

eg.
Steven

Steven,
Refering to above post by you, I tried creating a blank form (form with no objects) and assigned it to Report but then hit the error when I Run Report.
53f7a39150d01f8 is the record id from zzzsys_report.

My observation was that the form needs a minimum of ONE object (can be anything).

jkdev,

What Object are you using, it looks like nuBuilder can't find what the Table or Primary Key name is.

Steven