Hi frds plz help me for this report posted at :-

http://www.andreavb.com/forum/viewtopic_8137.html

Hi
What were the results of your investigation? (as per the help you already received?)


____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)

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...


____________________________
:
ReportinExcel.zip 8 KB (: 6)