Has anyone found a solution to this ?

Has Microsoft released a patch fix for this ? how do i turn off the navigation for the total only ?

thanks

Steve,

customer table consists off

customername  varchar

customerphoneno  varchar

postcode    varchar

suburb       varchar

The Postcode table is a table which I downloaded from the postoffice which contains all the valid postcodes in australia with postcode,locality in varchar

customer details are...

Thanks for the help guys, I did a performance test and to render my report the query below took 31 secs  - the query below this one using the nested cases...

Thanks a heaps Sergiy

you can try this

right mouse click the pivot table, select pivot table wizard 

once the wizard comes up select the back button , then select get data tab

u can change...