Hi,

Is there any method where we can convert existing BaaN report in PIVOT table format of Excel. Or is there any method using that we can capture value of report variable field.

Regards,

ajay

Hi ,

We have developed a tool whereby u can do this. Currently we are building some enhancements into this. Once it's ready , u can have a demo download of the tool.

Redirect your report output to Text File. Read the data of the text file into an Excel spreadsheet. On the new worksheet create a pivot table of your choice.

This would be faster if it is one time requiremnt.

If it is a regular feature you need you can create a device Excel to convert the report to Excel and use your Data to create a Pivot Table.

Third option : I am not sure of SQL 7 but with SQL 2K we can use Service Analysis and create a cube and use the cube to create a pivot table.

I hope this helps you.

Hi,

There are several ways for capture the value of field of the report. You can capture the same by generate the report directly to excel or generate the same in ascif format and then open it in excel through tab delimination.

Viplov