Author Topic: Reports: Calculated Totals  (Read 4227 times)

0 Members and 1 Guest are viewing this topic.

Offline cadkevTopic starter

  • Active Member
  • **
  • Posts: 2
  • Country: us
  • Gender: Male
Reports: Calculated Totals
« on: Dec 13, 2010, 16:10:16 PM »
Is there any way to only show the calculated total of the Centerline Length on the report without all the seperate data showing up as well? Trying to make a short and simple report to order straight round duct.

Offline Jeremy@apollo

  • Senior Member
  • ****
  • Posts: 270
  • Country: ca
  • Gender: Male
Re: Reports: Calculated Totals
« Reply #1 on: Dec 13, 2010, 16:32:02 PM »
The items in the right hand column of your report builder will be included in your report. If you want to remove info from your report, select the item and use the left arrow button at the bottom of the page. You might want to create a new report first and name it something different in case you want the original later.
Autocad Mech 2010
CADduct  2.38.218

Offline tnbndr

  • Premier Member
  • *****
  • Posts: 3117
  • Country: us
  • Gender: Male
    • J.F. Ahern
Re: Reports: Calculated Totals
« Reply #2 on: Dec 13, 2010, 16:42:29 PM »
For the items that you do not want to show up, set the column width to zero.
For the Addreport builder, there is a check box for output, uncheck and the data won't show.
Fabrication 2013
AutoCad 2013x64(Plain Jane)
HP Elite Book 8740W, Processor i7 - 2.4GHz, 8 GB RAM
WIN 7(Enterprise) 64 Bit, NVIDIA Quadro FX2800M Video

Offline jmerch

  • Premier Member
  • *****
  • Posts: 2297
  • Country: us
  • Gender: Male
Re: Reports: Calculated Totals
« Reply #3 on: Dec 13, 2010, 16:43:01 PM »
Or, if you need certain fields on the right side, leave them and on the Column tab on the right, change the Width to 0%.  This will not display data for that item then.

But what I think you're asking is to only show the total.  I believe the only way to do that is check "Summarize Totals for Collected Tables" on the same tab.  I can't remember if you can have everything set to 0% Width and have this work out the way you want.  You can play around with it and see what you need.
Intel i7-6700K @ 4 GHz - 32GB RAM - NVidia Quadro M5000 - W10x64 - MEP & FABRICATION 2014/2017 - NAVIS 2017 - REVIT 2017.1

Offline cadkevTopic starter

  • Active Member
  • **
  • Posts: 2
  • Country: us
  • Gender: Male
Re: Reports: Calculated Totals
« Reply #4 on: Dec 13, 2010, 20:56:46 PM »
I was able to get the total amount of round duct used by reducing the number of fields used in my report. I started with (Item Quanity, Item Centerline Length, Item Centerline Length) and replaced them with (Item Qty/Length).
After fiddling with some of the settings I was able to get just one row with the total lengths for each diameter used.
Thanks for your help!

Offline dexyweescot

  • Senior Member
  • ****
  • Posts: 328
  • Country: gb
  • Gender: Male
Re: Reports: Calculated Totals
« Reply #5 on: Sep 08, 2020, 12:11:50 PM »
Bumping this to find out which setting was used for total only?

Offline imtwd

  • Full Member
  • ***
  • Posts: 65
  • Country: us
  • Gender: Male
Re: Reports: Calculated Totals
« Reply #6 on: Oct 22, 2020, 19:05:31 PM »
i am working on Trapezes right now and it is not working for me, i am in 2018. I am getting both rods totaled for one support,  and the others are even longer.  i am looking for solutions to.

Offline Jwisniowski

  • Full Member
  • ***
  • Posts: 163
  • Country: us
  • Gender: Male
Re: Reports: Calculated Totals
« Reply #7 on: Apr 02, 2021, 18:18:07 PM »
For calculating Linear Totals I used the "Item Centerline Lenght"

Contents: Qty = per item Qty
Column: check Calculate Total & Summarize Totals for Collected Tables
Order: Normal