Skip to main content

I have set up a Quick Report to run a Crystal Report and this works fine except that I am being prompted for Login Information each time it is run.

 

e.g. if the Crystal Report is accessing the CUSTOMER_ORDER_TAB I receive the following:

 

Login Information for CUSTOMER_ORDER_TAB is requested prompting me to enter:

Login:

Password:

DB Instance: 

Schema Owner:

 

Can anyone please advise what I am missing.

@johnw66,

What ifs version are you using?

Have you added \ or \\ to the end of alias for IFS Applications data sources when designing the quick report?

 

Please refer the document attached

 

 

Few things....

  1. Use the CUSTOMER_ORDER view in IFSAPP → Views instead of accessing the table directly
  2.  Add in the CR_WEB_INIT (IFSAPP → Qualifiers → CRYSTAL_WEB_UTIL_API)
  3. Rename your tables appending either \ or _A 
  4.  Change the linking 
  5. Add the OBJVERSION to the Report Header and suppress 

     

2 things:

  1. You need to add CR_WEB_INIT to your report layout (as mentioned by @CallumW)
  1. Ensure that the System Parameter named “Specify if web database access security check is required” is set to “NO”.  This should be the default value but double check it

Nick

Thank you very much to everyone for your assistance.

@Banu Liyanapathirana We are using IFS Applications 10.

@CallumW@NickPorter Thank you very much for your advise.  By adding the suffix _A the problem has been resolved.

Also the system parameter named “Specify if web database access security check is required” is set to “No”.

Your help has been much appreciated.

John

Reply


Terms & ConditionsCookie settings