Skip to main content
Question

Report Creation

  • July 30, 2026
  • 2 replies
  • 55 views

Forum|alt.badge.img+4

Hi All,

Being new IFS9 user (not Cloud) ,How to learn Query or Report Creation? is there any Docs or guideline how to create Report with Zero Knowledge of SQL ?

My Report requirement 

  • Find out Waiting time between two operations on Shop order which has status “ Started”.
  • Actual Production time  “ reported” for Shop orders against the Routing hours.
  • Part which has Routing with “X “ Work centre .. 

Thanks in Advance.

2 replies

VivekBhandiwad
Hero (Partner)
Forum|alt.badge.img+8

Dear ​@IFSFAN  ( V P )

I suggest starting with “F1”  the online help section . Go to Technical help documentation and navigate to “IFS Administration and Configuration Guide” .

Within this navigate to “Reporting” and then “Adhoc reporting”. See screenshots below.

For Query Builder , you need to understand reporting basics ( what are keys, joins, why they are needed etc) , but once you start with some basic queries, for ex: the first one in your list, is all about one view “Shop Order Operations”  go try it out. You need more concepts to be understood as you increase your requirement

Better Bet , in this world of AI:  Invest in refining your prompts to Chatgpt/Copilot or Claude - your preferred AI LLM models .  Will be more helpful, in learning as well as getting the results you need. 

 

Regards

Vivek


Forum|alt.badge.img+4
  • Author
  • Do Gooder (Customer)
  • August 5, 2026

Thank you ​@VivekBhandiwad  I will try to learn...Thank you again,