please help me in addressing this issues
how to use a cross tabed querry in report writer?
how to generate bom from pcb with quantity of components in each part number?
As far as I recall I could never get the BOM from the PCB in the format required using Report Wtiter, but as this is a utility on the PCB side of things you may get an answer by postigng this on the Expedition Community http://communities.mentor.com/community/pcb/expedition/ask_the_insider?view=discussions
But unless you have particular mechanical cells you require in your BOM the Part Lister in DxDesigner should be able to generate what you require - Tools - Part Lister. There are a couple of configurations delivered with the install which you could modify to suit your requirments.
Retrieving data ...