Solved

Reports are blank

  • 15 December 2021
  • 2 replies
  • 227 views
G
Rank
Userlevel 4
Badge +9

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 

icon

Best answer by geminirajesh 17 December 2021, 07:21

View original

2 replies

ROVECH
Rank
Userlevel 3
Badge +6

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

G
Rank
Userlevel 4
Badge +9

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


Terms & ConditionsCookie settings