Pipe being excluded from Bill of Materials Report

[_Jeff_Roy_]

Hi, I've got a pipe model that is exporting everything fine except for pipe from two specs. All of the fittings, connectors, etc. associated with those specs appear on the report, only the pipe is excluded. I've verified that the pipe is "live" (hasn't lost its metadata, new connections work, can route new pipe of what's already in there, etc.). Any insight as to how I can get this pipe to come in on reports would be greatly appreciated!

[Michiel.Valcke]

is there any filter set in your report query like status, or other that might keep those pipes from being included?

Are they fixed length pipes? (those for example are not included in the out-of-the-box 3D parts report)

[_Jeff_Roy_]

@Michiel.Valcke Thank you for the reply. To answer your questions:

1. The pipe in question is set to Fixed Length = True.

2. The 'Used Fixed Length' filter is empty in my query settings. 

Based on this info, are you able to recommend any fix to have this piping show up in my reports?

[Michiel.Valcke]

The most logical thing still seems something's off with your query, but if there are no filters. I would have to think one of the following, each seeming very unlikely.
- maybe your pipes do not belong to the 'Pipe' class 😕 

- there is a filter or script in your report layout filtering out the fixed length pipes 😕 

As you can tell these are not very promising. 

Alternatively you can try the following:

If you try to create another run with fixed length pipes from another spec, do they come into your report? 

Remove the pipe from your query and then add it again.

You're welcome to share your report configuration here, but I can't promise I'll have the time this week to see if I can replicate or not replicate the behaviour with it. 

[jabowabo]

Check any filters here as well:

[_Jeff_Roy_]

@jabowabo Thanks for the reply. I've now tried the following:

- Removed the drawing / model from the project

- Run PnPLocalDataCachePurger.exe

- Audited the project

- Copied the model back in

- Run a purge

- Verified all pipe is populated as 'False' in the use fixed length attribute (was previously set to 'True' but I did a manual override on this directly in the drawing)

- Verified all pipe is recognized as 'Pipe' in the Class attribute

- Verified these pipes show up in Data Manager

Report still excludes these lines. I went into our report layout as you suggested and there do not appear to be any filters set at all. 

[Michiel.Valcke]

Are the pipes included if you run an out of the box report? (minus the filter)

[jabowabo]

A copy of your .rcf file and a sample model will likely be necessary for further troubleshooting.

[_Jeff_Roy_]

I've attached a copy of the .rcf file and the model containing the pipe being excluded from the report. Specifically, the lines belonging to the RLG1 and RLG1-V specs are being excluded. Other components, fittings, etc. from these specs look be included, it seems like only the pipe is being left out.

I had to zip the .rcf file so it would let me attach it. 

Thanks very much for the ongoing help!

[jabowabo]

As a rule of thumb, you should be adding a sort field for every column you do not want calculated:

Edit: Note that the original report included all pipe, it just aggregated them all into one unsorted row item.

[_Jeff_Roy_]

Looks like you got that pipe to come through. Can I trouble you to explain what you changed and where to get it included in the report?

[jabowabo]

---

@_Jeff_Roy_ wrote:

Looks like you got that pipe to come through. Can I trouble you to explain what you changed and where to get it included in the report?

---

Just add sort fields as pictured above.