Help with Report Creator

[wayne.oglesby]

I have just started working with Report Creator  in Plant 2019 and have not figured out how to set it up.  I have read several different posts and still don't grasp how to set up what I am trying to do.  I just need a simple bill of materials listing the total quantities of my different fitting and total length of pipe all separated by size.  When I ran my query, it appears to have around 9000 pages of components.  I am using the ASME BPE class for my plant and will have Tri-Clamp and butt weld connections on the different components.  If anyone could point me in the right direction, it would be greatly appreciated.

[Tomislav.Golubovic]

In the Report Creator first dialog box, select "3D Parts" as the Configuration you want, and then click "Edit"

In that second window, make sure the output type is One report / project. It sounds like you have it set to One report / object.

[wayne.oglesby]

Tomislav,

  Thanks for the reply, but I checked and it is set to one report for project.  My problem is it is not summing up the individual parts.  It is creating a separate line for each item.

[Tomislav.Golubovic]

And you didn't change the report in any way?

[wayne.oglesby]

The only thing I changed was to add elbow, tee side outlet, reducer and pipe to the class name in the query.  For a filter I put ='ASME BPE' .   When I tested the query result, it worked.   I haven't changed anything in the actual report layout as I was attempting this for the first time and wasn't sure about that.  I'm very much a rookie on this part.

[jabowabo]

Make sure your sort fields are correct in layout editor - you should generally only have sort fields for your report columns (except Quantity). You shouldn't have any sorts for part-unique fields like PnPID, ItemCode, etc.

They shouldn't look like mine but you can find them here:

[wayne.oglesby]

It's better following your instructions, I am at least getting it sorted the way I want it, but it still isn't summing all of the parts on one sheet. attached is what I'm getting. I know I'm just missing a step, but I don't have a clue what it is.

[jabowabo]

You've got your items under a 'Detail' band rather than a 'GroupHeader' band. I think you at least need to change this.

[wayne.oglesby]

Jason,

  I just put everything in group 1 and had the same result when I went to print preview.  I'm at a loss as to what I am doing wrong.  I am missing some format that needs to be included.  It is not listing pipe lengths for the pipe, just listing the individual pipe diameters.  I just can't figure out how to get this to sum up the parts and the total length of the different pipe sizes.  I appreciate all of your help.

[Anonymous]

I worked a lot with the report designer tutorial and some tutorials from PDO-Team. This helped me a lot to understand how the reportCreator is working.

https://knowledge.autodesk.com/support/autocad-pid/learn-explore/caas/sfdcarticles/sfdcarticles/Auto...

http://www.pdoteam.com/?s=report

Hope this helps you too.

greetings Patrick

[wayne.oglesby]

Thank you Patrick, I was not able to find this guide before.  I will read through this and see if I can get this report to work.

[jabowabo · Accepted solution]

Also check these settings:

[wayne.oglesby]

Thank you very much Jason