Reports from Database

[narendra1302]

Dear All,

I am having database of Complaints. It's capturing Date, Region, Site, Type of the Product, etc.

However we want to get the report whenever run the query.
1. Date / Period / Monthwise - number of calls
2. Regionwise / Sitewise / Productwise - number of calls

The first two rows are constant & contains headers of the database. I have tried with Pivot table, But now it is showing some error while performing the required task - Because there are some blank cells in 1st & 2nd row & somewhere it is merged cells. That is why I am not able to use Pivot ther.

Thanks

Narendra

 

[narendra1302]

Hi - Is there any reply ?

 

[Andrew Poulsom]

You need to unmerge the cells (and remove the blanks)

 

[JackDanIce]

n/a

 

[narendra1302]

Dear Andrew,

Thanks for showing intrest.

However it is fixed & link is there itself - I can't change the header is already fixed. Is there any way to do with some VBA code to fetch the data ?

Thanks
Narendra

 

[Andrew Poulsom]

Sorry, I don't understand why you can't remove the merged cells. They are seldom necessary. Generally speaking VBA can only do wht you can do manually.

 

[narendra1302]

Dear Andrew,

Ok - I will try to do it.

Then how to get the required report - By Pivot table ?

Thanks
Narendra