Skip to main content
Solved

Crystal Quick Reports in IFS Cloud- Report Blank

  • December 2, 2024
  • 3 replies
  • 125 views

Forum|alt.badge.img+5

I had a quick question. If you create an IAL in Cloud and put a where clause into the quick report for the Crystal Report, does it cause the report to blank out? 

 

I made a Crystal Report in Cloud using an IAL and got it to display the data without the Where Clause (I don’t suspect it’s permissions at this point because it worked WITHOUT a where clause) but once I put in a where clause it would return no data. I made a SQL version of the report as well and it does return data with the where clause in place. I just want to get a better understanding why this is happening and how I can get around this. The report works in Crystal just fine but once I put into our TEST Environment, the report comes up completely blank.

 

Thank you.

Best answer by jayoneil98

We were able to resolve this. It turns out I forgot to link the CR_WEB_INIT to the IAL rather than linking the IAL to the CR_WEB_INIT. Once we did that, we got it working.  😊

View original
Did this topic help you find an answer to your question?

3 replies

ashen_malaka_ranasinghe
Hero (Employee)
Forum|alt.badge.img+11

Hi ​@jayoneil98,

What is the view that you are using? Is it ending with the _REP? Otherwise, it is required to grant access for the used view.


Forum|alt.badge.img+5
  • Author
  • Sidekick (Customer)
  • 11 replies
  • December 3, 2024

Hello ​@ashen_malaka_ranasinghe 

 

I was using an IAL for this report. It doesn’t use any REP views, it uses the DELIVERY_NOTE_LINE, CUSTOMER_ADDRESS and SALES_PART views. What is strange is that it works without a WHERE Clause, but once I tried to filter out the service lines, it would disappear in the TEST environment. IFSSYS, IFSPRINT, IFSAPP have access to the view. 


Forum|alt.badge.img+5
  • Author
  • Sidekick (Customer)
  • 11 replies
  • Answer
  • December 3, 2024

We were able to resolve this. It turns out I forgot to link the CR_WEB_INIT to the IAL rather than linking the IAL to the CR_WEB_INIT. Once we did that, we got it working.  😊


Reply


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