nuBuilder Forum

Hi,

RIght now, I have an INDEX tab titled 'Reports' that has a button that takes you to the Run Activity form, as in samplenufinancial. However, I would like to instead populate this tab with buttons linking directly to the forms used to generate reports.

I created the button and in the 'Form To Launch via Browse' field, I set the report form.

However, when I click on button, I get the blue screen with the following SQL error:
zzsys_variable_id is listed as the primary key in the report form.

Any idea how I can get this form to display?

Thanks,
Cassidy

Cassidy,
have you seen this post?

Another way could be something like this:

• create a HTML object on your form:
  htmlObject.png
• in HTML tab insert something like this:

  Code: Select all

  <div>
    <button type="button" onclick="printIt('report_code')">Print Report</button>
  </div>

Hope this helps,
Max

Hi Max,

Thank you for your reply.

The problem is that the report needs input; it's not just ready to print. I want to create a button that takes the user to the form, where they can then enter the relevant parameters needed to make the report, and click 'Print to Screen' or any of the other print options to get the report.

Any ideas on how to do that?

Thanks again,
Cassidy

Cassedy,
from any Edit Form, you can run a report using Extra Action Button or a Button Object you created on the form.
The report is run using printIt(pCode) or pdfIt(pCode) Javascript functions (pCode is your report code).

You can use hash variables in the php code you write, to help build the temptable (#dataTable#): you don't need to pass them through anything.
For example, if you need two parameters in your report, you have to set two object on the form to get user input (ie: text_object_1 and text_object_2). In the report code you get the values with: Max

Thanks Max, I'll do that.

Max is a legend.