Skip to main content
Question

IFS Crystal Reports

  • June 22, 2026
  • 4 replies
  • 57 views
A
Do Gooder (Customer)
Forum|alt.badge.img

Hi,

I'm currently recreating the Transport Task report in IFS Cloud and have a requirement to include the address details from the Location page. This is needed to distinguish transport tasks delivered directly to a customer from those delivered to an internal inventory location.

I started with the TRANSPORT_TASK_REP view and joined TRANSPORT_TASK_LINE_EXTENDED to retrieve the ORDER_REF.

However, when I attempt to join JT_TASK_LIGHT_UIV using TASK_SEQ and ORDER_REF, I receive a "Data types are not compatible" error. One is a varchar and the other numeric. This appears to be the only possible link between these views that I can identify.

My intention is to use JT_TASK_LIGHT_UIV to then join LOCATION_PARTY_ADDRESS_PUB (via CONTRACT_ID to LOCATION_ID) and retrieve the address details.

Is there another way to obtain the address information, or is this approach not supported?

Thank you.

 

4 replies

S
Hero (Employee)
Forum|alt.badge.img+11
  • SamiL
  • Hero (Employee)
  • June 22, 2026

While I have no experience with the (in some versions deprecated) Crystal Reports - a word of warning.

The JT_TASK tables tend to be rather hot, so joining anything into them may be detrimental to the system performance.

It would be better to offload reporting into another container by using our datapump in
https://docs.ifs.com/techdocs/25r2/050_reporting/010_analytics/010_analysis_models/010_am_pbi/
or the traditional SQL-based Tabular Models in
https://docs.ifs.com/techdocs/25r2/050_reporting/010_analytics/010_analysis_models/000_am_tabular/ .

If you do use reporting directly to the active database (which is a bad idea), try to avoid joins and especially full outer joins. Test and optimise your queries for minimum resource usage.
The UIV views are created, as the name says, for UI.
They may not be the best candidate for reporting. There are many opinions on views/tables, but if tables are accessible (as they are in the datapump Parquet framework) that could be the fastest option for reporting.

    A
    Do Gooder (Customer)
    Forum|alt.badge.img
    • ashleigh.russ
    • Author
    • Do Gooder (Customer)
    • June 23, 2026

    Unfortunately this is a operational document that will be printed, required every time we carry out a ‘Transport Task’. Therefore offloading the data is not liable in this case.

    Thank you for your response though!

     

     

    adrianm
    Do Gooder (Partner)
    Forum|alt.badge.img+4
    • adrianm
    • Do Gooder (Partner)
    • June 25, 2026

    Hi ​@ashleigh.russ 

    If you need to match the data types, have you tried adding a custom field to the JtTask entity to convert the TASK_SEQ column value to a VARCHAR2 type to match the ORDER_REF column type? You can then use JT_TASK_LIGHT_UIV_CFV and the new column instead and the join should work. 

    Attribute Name
    Expression

     

     

     

    Michael Kaiser
    Sidekick (Customer)
    Forum|alt.badge.img+9
    • Michael Kaiser
    • Sidekick (Customer)
    • June 25, 2026

    Hi, 
    I totally agree with Samil, 
    but if you need the report on a regular base (many times a day not once a day) 
    try the following. 
    TASK_SEQ: in JTLU a number field
    ORDER_REF: Do you mean ORDER_NO?
    My MetaDataAnalyzer just found the following in the JT_TASK_LIGHT_UIV:
     

    Just TO_CHAR(TASK_SEQ) as TASK_SEQ
     


    I use the way from MS SQL Server (with a installed Linked Server) to show the priciple.
    If you need more help with View or table structures just let me know.
    HTH
    Michael

    High transparency and better decision quality with IFS-based controlling (reports/BI).
    Terms & ConditionsAccessibility statement