BOM First Level report actually multi-level?

[CadUser46]

I'm using the report from "C:\Program Files\Autodesk\Vault Professional 2016\Explorer\Report Templates\BOM - First-Level.rdlc" but it shows rows 1.1,  1.1.1 etc

Am I wrong in thinking it should only show the first level of the BOM?  Right now it seems identical to BOM - Multi-Level so I already compared a copy from another users machine in case I had accidentally overwritten it.

[johannes.bauer]

Hi CadUser,

I can reproduce your view.

I will log a defect for this. 

Still you can edit the reports yourself if needed.

You can find here an information for this.

Thanks

Johannes

[CadUser46]

Hi Johannes

Thanks for agreeing with me. 

Unless you're telling me otherwise I don't believe it's possible to edit the logic of reports as I have asked this question before.  Columns/layout/properties yes, actual logic no.  I have web developer 2008 but see no way to edit the embedded SQL to modify the multi-level into single level.

If you do know of a way to achieve this could you edit it and send me the report, or explain how to do it?

Thanks

Craig

[johannes.bauer]

Hi Craig,

Please select in the BOM View the First Level and re-execute the Report First Level.

Let me know if that helps.

Thanks

[CadUser46]

I had already tried that but did it again to be sure.  No change I'm afraid, it's still multi-level.

[johannes.bauer]

Hi Craig,

Here is a screencast from 2018 version, where this is working correctly.

[CadUser46]

I was using the BOM in the preview window so I copied your steps but still same result.  I'm using 2016 Vault Pro.

[johannes.bauer]

Hi Craig,

thanks for verification.

Any plans to update to 2018? 🙂

[CadUser46]

Not anytime soon.  Can you duplicate the error in 2016?  Is the bug in the report or Vault?

[johannes.bauer]

seems to work as well for me.

[CadUser46]

So how do you propose to move this forward?  Remote desktop?

[johannes.bauer]

I will follow up in a case

[Anonymous · Accepted solution]

Johannes pointed out the obvious.  It's not the logic of the report that make it First or Multi-Level, it's the filter selection in the UI before running the report.  The report names are just misleading 🙂

Posted from my other account.

[jacopo_chiappetti]

you can use the filter selection in the UI, as stated, or you could modify the "first level" report adding, in the "rows visibiliy", the expression : =instr(Fields!Row_Order.Value,".")>0

this hide rows with row order contains a "." so 1.1, 2.3 ... 

or put the same expression in the filter section of the table