Skip to main content
Solved

Login Information requested when trying to run a Quick Report

  • January 14, 2020
  • 4 replies
  • 776 views
R
Superhero (Partner)
Forum|alt.badge.img+18

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.

Best answer by CallumW

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 

     

View original
Banu Liyanapathirana
Binura Dodangoda
Himasha Abeywickrama
5 people like this
  • Banu Liyanapathirana
    Banu Liyanapathirana
  • Binura Dodangoda
    Binura Dodangoda
  • Himasha Abeywickrama
    Himasha Abeywickrama
  • R
    RutJWhalen
  • C
    CedDinesY
Did this topic help you find an answer to your question?

4 replies

Banu Liyanapathirana
Hero (Employee)
Forum|alt.badge.img+13

@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

 

 

1 Attachments
--Banu Liyanapathirana--
Himasha Abeywickrama
1 person likes this
  • Himasha Abeywickrama
    Himasha Abeywickrama
CallumW
Superhero (Partner)
Forum|alt.badge.img+15
  • CallumW
  • Superhero (Partner)
  • 128 replies
  • Answer
  • January 14, 2020

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 

     

Callum Wells - https://uk.linkedin.com/in/callum-wells
Yasas Kasthuriarachchi
NickPorter
C
3 people like this
  • Yasas Kasthuriarachchi
    Yasas Kasthuriarachchi
  • NickPorter
    NickPorter
  • C
    CedDinesY
NickPorter
Superhero (Customer)
Forum|alt.badge.img+18
  • NickPorter
  • Superhero (Customer)
  • 328 replies
  • January 14, 2020

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

Yasas Kasthuriarachchi
R
2 people like this
  • Yasas Kasthuriarachchi
    Yasas Kasthuriarachchi
  • R
    RutJWhalen
R
Superhero (Partner)
Forum|alt.badge.img+18
  • RutJWhalen
  • Author
  • Superhero (Partner)
  • 364 replies
  • January 14, 2020

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

Yasas Kasthuriarachchi
1 person likes this
  • Yasas Kasthuriarachchi
    Yasas Kasthuriarachchi

Reply


Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings