In Windchill 12.1, is it possible to export WhereUsed Report only to a level expanded in the table?

[Srivalli]

There is a part being used in multiple sub-assemblies. The table was showing around 150 parts when expanded to a certain level (3). When we try to export the report, it says an error that rowLimit property is set to 20000. Is it possible to export only those 150 parts to CSV or XLS.

Export of all rows is working for XML, but it's not the desired format. Can someone help?

[TDT]

Hi @Srivalli,

Are you using any custom report?

[Srivalli]

@TDT  we are using the OOTB option 'Export'.

[HelesicPetr]

Hi @Srivalli 

Try a xlsx format. 

PetrH 

[Srivalli]

Hi Petr,

It's the same error with this format too.

[HelesicPetr]

Hi @Srivalli 

I would try to increase the limit

https://www.ptc.com/en/support/article/CS350579

PetrH

[TDT]

Hi @Srivalli,

Do you want to have only single level report?

[Srivalli]

@TDT 3 levels

[HelesicPetr · Accepted solution]

Hi @Srivalli 

Answer to your original question>

Unfortunately it is not possible to do so in the Where used table OOTB.

If you always want to report the 3 levels, you can create own Report template where you build 3 level structure to report only that 3 levels where the parts are used.

here is an example with a one level. You can add more levels to the report

CS210416 - How to create a Where Used report for WTParts in Query Builder

PetrH.