Skip to main content

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.

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.

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. 

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


Terms & ConditionsCookie settings