chintu4uin Level: Graduate
 Registered: 04-02-2008 Posts: 10
|
Re: Help for this Report...
Hi stickleprojects, I have successfully genrate the Excel File as I required by using a Macro..Now my problem is I hav to insert Subtotals as my key filed changes my key fields are
STATE NAME || DIVISION NAME || REGION NAME || TERRITORY NAME
Now I hav attach 2 excel file, 1st File is what I m generating using VB6.0.After generating how to insert Su-Total at levels I hav shown in 2nd File int tht I have mark record with yellow and orange which tells tht 2 row of yellow is a one record only, but in tht 1st row is QTY fields and 2nd Row is AMT fields of 1 record and I want the su-total of only AMT fields.
Now in this I hav done Sub-Total at TERRITORY NAME LEVEL as my TERRITORY NAME changes I put sub-total, similary when REGION NAME,DIVISION NAME,STATE NAME changes I want there resp. total.
I know the way through VB but which is last option as it is Time consuming to hav 4 loop for REGION NAME,DIVISION NAME,STATE NAME as and when they change to insert subtotal but its time consuming so is there any alternative to do so.
So is it possible...
____________________________ Attached:
ReportinExcel.zip 8 KB (Downloads: 0)
|