Adding the Product Description Prompt Data for Reporting

Adding the Product Description Prompt Data for Reporting

As a result of the report structure and report specification requirements, sometimes it is not possible to accurately reference the prompt "ProductDescription" in a report. An example of this would be when trying to group on that prompt value. Another example would be when the report databand structure does not support a relationship between two dataset tables - such as OptimizationResults or PlacedSheets (part or material based) and Prompts (product-based). 

The procedure in the attached video allows you to define the ProductDescription prompt value as a ProductComments1 field, and thus accurately exposes it to reports with complex data requirements.

The video assumes that you do not have ProductComments1 already in use for some other purpose. If it is in use, you may have to reconfigure the existing comments to be located elsewhere.

Lastly, the video demonstrates the procedure with a single product. If you need to modify your entire library and are proficient using the Library Designer, we recommend that you first back up a copy of your library and proceed to make the modifications contained in this video using the Library Designer.



    • Related Articles

    • Understanding the Product List Interface

      Product List The Product List is a module that allows users to make modifications to their products without working directly in the drawing. The following article, detailing the different aspects of the Product List, applies to build 20.1.0826.641 ...
    • Adding a Data Source to a Data Band in Report Designer

      The articles in this section of the Knowledge Base involve working with Lists for display in your reports. To learn more about Lists and how to access the Report Designer, see Creating Lists in Report Designer. This article provides an overview of ...
    • Issue: Report Unexpectedly Missing Data

      Some Users tell us that infrequently a report may be displayed that is missing data when previewed. There are various possible reasons for this issue, but one cause may be a defective report dataset definition. This article explains a pre-test to ...
    • Issue: Part Labels Display Incorrect Barcode Data when Processing to Multiple Machines in 15.6

      As of build 15.6.221, you now may use the simplified procedure found in the Microvellum Help Center article Processing Station Associates for Reports (Overview)  to resolve this issue in addition to the procedure found in this article.  Issue : Part ...
    • Using Data Fields in Expressions

      Expressions can contain values from data sources. A string representation of the field is used to reference that field from the data source. The proper syntax for the reference is the name of the data source and the field name with a full-stop ...
    • Recent Articles

    • Toolbox Release Notes | Build 25.1.0213.641

      The following release notes apply to Toolbox build 25.1.0213.641. Stay Down Nesting Additions 3 new settings have been added to Stay Down Nesting, to resolve specific issues with routes and connectors that have been reported: Fig. 1: New options in ...
    • Toolbox Release Notes: Year of 2024

      This document will catalog all releases for Microvellum Toolbox software builds that were released in the year 2024. This encompasses builds 24.1.0104.641 to 24.1.1206.641. Toolbox Release Notes | Build 24.1.1206.641 The following release notes apply ...
    • Toolbox Release Notes | Build 25.1.0129.641

      The following release notes apply to Toolbox build 25.1.0129.641. SMA Fixes A wide variety of issues with the Solid Model Analyzer have been resolved. Multiple modifications to existing interfaces or settings have been made to improve precision and ...
    • Microvellum Foundation Library Release Notes | Build 25.0124

      The following release notes apply to Microvellum Foundation Library build 25.0124. Additions Added Century Components Waste Bins, Vanity Organizers, and Base Cabinet Organizers. 11”, 14”, 17” Signature Series Bottom Mount 34qt & 50qt. 4”, 5”, 6”, 9”, ...
    • SQL Server Backups

      This article will list out the various types of backups you can create for databases hosted on an SQL Server, explore methods for creating backups manually and automatically, as well as list software/services that may assist you with backing up your ...