Solved

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

  • 12 April 2022
  • 2 replies
  • 183 views
B
Rank
Userlevel 3
Badge +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?

icon

Best answer by Stefan Nyberg 13 April 2022, 08:37

View original

2 replies

S
Rank
Userlevel 2
Badge +4

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

B
Rank
Userlevel 3
Badge +8

Thanks Stefan, I will try this idea.

Reply


Terms & ConditionsCookie settings