Custom Report - Bill of Materials by Room & Location


Author
Message
mmaniaci
m
Junior Member (14 reputation)Junior Member (14 reputation)Junior Member (14 reputation)Junior Member (14 reputation)Junior Member (14 reputation)Junior Member (14 reputation)Junior Member (14 reputation)Junior Member (14 reputation)Junior Member (14 reputation)
Group: Forum Members
Posts: 3, Visits: 29
I'm having an extremely hard time creating a report that will give me a Bill of Materials, including Manufacturer, Model, Description, Qty, along with Room & Location attribute data - i.e. Room 1415 with Location of Rack, Ceiling, Wall, etc. I assumed there was an easy way to do this as this is a very common need, and it's not one of the pre-built reports. From the Products Tool in the dashboard I can sort by attributes at the top and get the filtered list I need but there is no way to export that filtered list like you can with Cables. I've spent some time poking around how reports are built and sunk a decent amount of time into this and I'm just not coming up with what I need. Is there any way to get assistance with this or have a report template built for me that I can import? Am I missing something? Thank you.
Rob Robinson
Rob Robinson
Forum Administrator (386K reputation)
Group: Administrators
Posts: 2.3K, Visits: 8.9K
Hi Michael,

Assuming you are using the Stardraw Design 7.4 Beta then you would use the Report Designer and my recommendation would be to take a template that is close to what you need and tweak that, for example, take Summary Reports | Cost by Room and swap out the Cost field for Location.  This would give you a BoM grouped by Room, with Qty, Manufacturer, Model Number, Description and Location.
If you're struggling to get to grips with the Report Designer, please email us at techsupport@stardraw.com including a mock-up of the report layout you want to achieve, and a .S07 project file against which such a report could be run; we'd be very happy to give some pointers on how to get to where you want to be.
Incidentally, we're hard at work on the next update to the Beta and this will include the ability to export just the fields you have chosen to display in the Products View.


Kind regards,
Rob Robinson
Stardraw.com
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search