Report creator, how do I summarize the lengths of bended pipe?

[Anonymous]

Report creator counts any curved pipe as one bend and not as x meters of pipe. 

I have underground HDPE piping that curves along it's path and I need help summarizing the lengths (not the amounts) of bends. 

[DACOMA3]

Make sure your settings in the Project Setup are set to "Treat Bends as Pipe"

[Anonymous]

Thank you for your reply. 

I already have it set to treat bends as pipe. The funny thing is on the isometric it works as expected. The pipe lengths are summarized, only report creator treats them as pieces. 

[Anonymous]

Nobody knows how to summarize bended pipes in report creator?

I have been searching everywhere and have come up empty.

Please help.

bump?

[jabowabo · Accepted solution]

You can create a custom field with an expression in report creator to get the bend cut length. Implementation and exact expression text depends on your report setup but basically you need to check if the item is a bend and if so, report property [Pipe_CutLength]. If not, report a different property. This field should be bound to a 'Group, Sum' cell.

Example:

Iif([Engineering Items_ShortDescription]=='PIPE BEND',
		[Pipe_CutLength],
		<your else here>
)

Here's another example of an expression that does not address bends but might be helpful to understand how to use the code:

Iif(IsNullOrEmpty([BoltSet_NumberInSet]) 
	And IsNullOrEmpty([Pipe_Length]),
		1,
		Iif(IsNullOrEmpty([BoltSet_NumberInSet]),
			Round([Pipe_Length]/12, 2),
			[BoltSet_NumberInSet])
)

This one checks if the item is a bolt set or pipe by seeing if certain properties return null. If they are null, it returns 1. If they are not null, it returns the desired property value.

[Anonymous]

Thank you for replying. Yes I started looking into setting up some kind of filter to get the result I need.

I wish Autodesk would spend some time writing a more user friendly (and less time consuming) approach to plant 3D. 

[Mauricio_DM]

@jabowabo I'm actually getting 1 in the piping bends, and your code didn't worked for me =(

[jabowabo]

---

@Mauricio_DM wrote:

@jabowabo I'm actually getting 1 in the piping bends, and your code didn't worked for me =(

---

Did you assign the correct field to the data binding? Do you have the Summary set as shown above? What exact expression are you using? Difficult to help if you don't provide details. As stated above, you may need to modify the expression based on your setup.

[Mauricio_DM]

Hi @jabowabo ,

Many thanks for for response.

These are my settings:

I using your expression for "Quantity", but I'm still geting the null value "1".  

Iif(IsNullOrEmpty([Pipe_CutLength]),Iif(IsNullOrEmpty([PipeBend_CutLength]),1,Round([PipeBend_CutLength])), Round([Pipe_CutLength]))

I would appreciate any ideas on how to do the expression.

Cheers,

[jabowabo]

What do you get if you bind the column directly to [PipeBend_CutLength]?

[Mauricio_DM]

thanks @jabowabo  

I don'w have that property available

PipeBend_CutLength

[jabowabo]

That's why it returns null. 

[Mauricio_DM]

How can I add that property?. Or do I have to create it?

[jabowabo]

The only way you can report bend lengths is by following the instruction in post #2 of this thread.

[iain.stewartCDU9L]

I added pipe bend group in queries and the summing of cut length works.