Question

Excel Report Output

  • 25 January 2023
  • 4 replies
  • 210 views
G
Rank
Userlevel 1
Badge +6
  • GT69
  • Do Gooder (Customer)
  • 13 replies

Hey peoples, I want to be able run reports via order report functionality and have the output in excel format rather than PDF. Is there anyway of doing this without having to use an excel plug in. We are using IFS Aurena

I have tried changing the default layout type to excel reports in the report definition screen in EE but that didn’t work

Cheers

GT

4 replies

N
Rank
Userlevel 7
Badge +13

Hi @GT69 ,

 

Hope detail available in below community post will help you

How to create an excel output from Order report | IFS Community

 

BR/Narmada

G
Rank
Userlevel 1
Badge +6

Thanks @Narmada I was looking for a way to do it without requiring a plug in

 

N
Rank
Userlevel 7
Badge +13

Thanks @Narmada I was looking for a way to do it without requiring a plug in

 

Hi, 

I’m sorry. I didn’t notice that concern and proposing below workaround if it is fit with you.

Get the report ID and create a quick report or use PLSQL to get the results in excel form. Refer below steps.

  1. Execute the report in normal way and get the ‘Result Key’ from ‘Report Archive’ window.
  2. Get the result through PLSQL, refer below sample select statement.                                          select * from SUP_OPEN_ITEM_REP, where result_key = '6666'

You may create quick report using the select statement and publish it for users.

 

Hope this will help you. Sorry for the inconvenience caused with previous reply.

 

BR/Narmada

G
Rank
Userlevel 1
Badge +6

Thanks @Narmada I will give your suggestions a go!

Reply


Terms & ConditionsCookie settings