topic Re: BOM First Level report actually multi-level? in Vault Forum

BOM First Level report actually multi-level?

CadUser46 — Mon, 03 Jul 2017 08:50:30 GMT

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.

Re: BOM First Level report actually multi-level?

johannes.bauer — Tue, 04 Jul 2017 11:45:08 GMT

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

Re: BOM First Level report actually multi-level?

CadUser46 — Tue, 04 Jul 2017 13:17:23 GMT

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

Re: BOM First Level report actually multi-level?

johannes.bauer — Wed, 05 Jul 2017 06:38:06 GMT

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

Re: BOM First Level report actually multi-level?

CadUser46 — Wed, 05 Jul 2017 09:39:03 GMT

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

Re: BOM First Level report actually multi-level?

johannes.bauer — Wed, 05 Jul 2017 09:47:59 GMT

Hi Craig,

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

Re: BOM First Level report actually multi-level?

CadUser46 — Wed, 05 Jul 2017 11:58:41 GMT

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

Re: BOM First Level report actually multi-level?

johannes.bauer — Wed, 05 Jul 2017 11:59:49 GMT

Hi Craig,

thanks for verification.

Any plans to update to 2018? 🙂

Re: BOM First Level report actually multi-level?

CadUser46 — Wed, 05 Jul 2017 12:03:59 GMT

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

Re: BOM First Level report actually multi-level?

johannes.bauer — Wed, 05 Jul 2017 13:05:33 GMT

seems to work as well for me.

Re: BOM First Level report actually multi-level?

CadUser46 — Wed, 05 Jul 2017 13:45:48 GMT

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

Re: BOM First Level report actually multi-level?

johannes.bauer — Wed, 05 Jul 2017 13:53:41 GMT

I will follow up in a case

Re: BOM First Level report actually multi-level?

Anonymous — Thu, 06 Jul 2017 14:18:13 GMT

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.

Re: BOM First Level report actually multi-level?

jacopo_chiappetti — Thu, 08 Jul 2021 09:54:44 GMT

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