Skip to main content
Solved

Do data of report from IFS business reporter tool is stored in database?

  • April 12, 2022
  • 2 replies
  • 229 views

Forum|alt.badge.img+8

Do data of report from IFS Business Reporter tool is stored in database the same way as report from IFS Report Designer tool(in %_REP table)?

I need to create XML for tax purpose in correct form. Data for XML are coming from report(IFS Business Reporter) and I find solution to do this by use function “Get XML Data” from Report Archive:

Then using IFS connect I can import generated XML to IFS and transformed it to the correct form of XML. 

But maybe there is more simple way to do that?

Best answer by Stefan Nyberg

Hi!

I know that when the BR report logic is converted into SQL statements and executed on the server side, the resultset in stored in an xml -format on the server side. The xml -data is then transferred to the BR client to be rendered in MS Excel.

 

But I have never heard of getting hold of and/or using that xml -file for other purposes...

 

When using BRES you can from the BRES administration window export the DSRD to a file, that includes the data for the report. But I don’t know if you can use that file/data in some way?

 

Regards,

                   Stefan

2 replies

Forum|alt.badge.img+4
  • Do Gooder (Employee)
  • 24 replies
  • Answer
  • April 13, 2022

Hi!

I know that when the BR report logic is converted into SQL statements and executed on the server side, the resultset in stored in an xml -format on the server side. The xml -data is then transferred to the BR client to be rendered in MS Excel.

 

But I have never heard of getting hold of and/or using that xml -file for other purposes...

 

When using BRES you can from the BRES administration window export the DSRD to a file, that includes the data for the report. But I don’t know if you can use that file/data in some way?

 

Regards,

                   Stefan


Forum|alt.badge.img+8
  • Author
  • Sidekick (Employee)
  • 62 replies
  • April 13, 2022

Thanks Stefan, I will try this idea.