VISUAL Did You Know?

If you have any questions about Infor VISUAL, contact us at 800.804.4715. We would be happy to help you!

Do you have VISUAL and want monthly tips and news? Subscribe to the BizTech VISUAL eNewsletter.

Are you looking for an ERP software? Subscribe to our monthly eNewsletter about ERP selection & implementation. Subscribe to the BizTech intERPreter.

Join the VISUAL Manufacturing Group on LinkedIn!

Search This Blog

Friday, November 20, 2009

Remove an extended query

Did you know that you can remove an extended query?

There are many reasons why you might want to remove an extended query. You may have inherited modified QRP reports where something is just not right, you want to diagnose a problem that surfaced, or you might want to enhance an existing report and need to temporarily remove the existing extended query. Whatever the case, there is way to do this.

Standard reports within VISUAL are performed within executables in which inputs to the report are hard coded into the executables. Extended queries allow desired information that isn’t an input to be added to the report as a variable linking data to the report.

To remove the query, you must:
  1. Open the desired QRP using the Gupta Report Builder.
  2. Go to the formulas in the object tree on the left and find the one named SQLQUERY.
  3. Right click on SQLQUERY and select properties.
  4. Make sure the SQLQUERY in the middle widow box and click Select Formula.
  5. Click the delete button then the OK button and confirm that you want to delete the selected formula.
  6. Go to the Input Variables in the object tree on the left.
  7. Right click and delete each input variable.

This edition of VISUAL Did You Know is brought to you by BizTech VISUAL Consultant, Ivan Wilson.

1 comment:

  1. Hey..

    I am working on Gupta Reports on Visual ERP. I am modifying an existing .QRP report using an extended query. Based on Purchase order and Line Id I am fetching Total Order cost from Purchase Lines table.

    When I run the report I am getting an Error:
    "Symbol is Undefined or unable to be referenced from current location: PO_ID"

    Will you be able to help me to resolve this.
    Please let me know.