creation of reports
Posted: Wed Apr 08, 2009 2:38 am
Hi
We have got some requirements to create reports.
We have to compare a file and a table and based on the conditions , we have to give the count.
For example
Col A in file matches Col A in table and Col B in file matches Col B in table--count of this
Col C in file matches Col C in table and Col D in file matches Col D in table--count of this
After getting these outputs, they have to be input in an excel file where the prestored macros/functions are available to calculate the other values.
so, if we input these values in Col A in excel, then other columns will be calculated automatically.
Since the server is in unix, we cannot input this to excel. But is there a way to do that?
We have got some requirements to create reports.
We have to compare a file and a table and based on the conditions , we have to give the count.
For example
Col A in file matches Col A in table and Col B in file matches Col B in table--count of this
Col C in file matches Col C in table and Col D in file matches Col D in table--count of this
After getting these outputs, they have to be input in an excel file where the prestored macros/functions are available to calculate the other values.
so, if we input these values in Col A in excel, then other columns will be calculated automatically.
Since the server is in unix, we cannot input this to excel. But is there a way to do that?