Hi all,
I have excel files to be used in my report. The information of each product is stored in each excel file.
like:
Product info in one file, the inventory info second file, sale info third file etc...
I need to see the information of each product from each file in row manner not in columns like crystal does
sample:
Name: Item1
Description: xxx
price: $000
sale prices: $00
stock qty: 00
total sale: $0000
---
Name: Item2
Description: xxx
price: $000
sale prices: $00
stock qty: 00
total sale: $0000
I need the report more like row based instead of coulmns/spreadsheet way
Can anyone tell me how would I achieve this?
Thanks for any suggestions,
-V
I have excel files to be used in my report. The information of each product is stored in each excel file.
like:
Product info in one file, the inventory info second file, sale info third file etc...
I need to see the information of each product from each file in row manner not in columns like crystal does
sample:
Name: Item1
Description: xxx
price: $000
sale prices: $00
stock qty: 00
total sale: $0000
---
Name: Item2
Description: xxx
price: $000
sale prices: $00
stock qty: 00
total sale: $0000
I need the report more like row based instead of coulmns/spreadsheet way
Can anyone tell me how would I achieve this?
Thanks for any suggestions,
-V