Skip to main content

I have few crystal reports that uses REP views and I have two sites in my IFS (site 10 and site 20)

These reports print fine in site 10

But it prints a blank report when the same is printed for site 20

e.g. Printing an PO which was done in site 10 works fine. Printing another PO which was done under site 20 prints blank

I can access the REP view data directly from PL/SQL

I can also get the preview of the report in crystal report

It is just in IFS it does not print with data for site 20

 

P.S. I’m logged in as ifsadmin 

Hi Rajesh, one possible reason for such issues can be that the Crystal client that is fetching data in the background is fetching information from a completely different database than the IFS client from where the report was retrieved. Double-check the crystal config xml and check to which DB it connects.

 

/Roel


Hi Reol,

Thanks for your reply.

In the end like always the solution was simple.

I had to grant access to Site 20 for the IFSPRINT user account

Once that was done, everything seems to print fine.


Reply