Specification Limits in table in graph report

V8i help suggests using the Symbol Design Gradaton Spec application to put the gradation spec values in table format on the graph reports, however it does not indicate how you pull this informaiton! Can anyone explain how to utilize this function?

I have pasted what appears in gINT help below:

To show gradation specification envelopes on graphs, Fixed Curves on Graphs can be used. However, if you want to also show the specification limits in a table on the graph report would require redundant entry of the specification in another format (library table or hardcoded values in the graph). A better alternative, with or without the tabular representation, is the use of the Symbol Design Gradation Spec application. There you can define as many specifications as needed.

 

Many thanks,

Judy Smith

  • The Gradation Spec tab is often out of view to the right end of the second row of tabs under the SYMBOL DESIGN application tab. This capability first became available in gINT v8i, and requires gINT Professional or gINT Professional Plus.

    The New tool in the SYMBOL DESIGN Gradation Spec application opens a dialog that allows you to define a new gradation specification, associating Presentation Properties like Fill Symbol, Line weight and color, and Data Markers to a particular gradation by name, The name is assigned in the General tab of this dialog.

    Graph_GradSpec_Name is a new System Data Item (available from the right side of the Data Tool) that returns the name of the gradation specification used on a graph report.

    GradSpecDesc, GradSpecNumRecs, GradSpecByRecord, GradSpecBySize, and GradSpecPointOutsideSpec are System Functions that return information about a particular gradation specification. These data and functions can be used to build specification envelopes from the existing data, eliminating the need for redundant data in a project to specify such envelopes..



  • To expand on Pat's post:

    Once you have defined a Gradation Spec in Symbol Design, you will see a screen with four columns:

    • Size (mm) (required)
    • Minimum % (required)
    • Maximum % (required)
    • Name (optional)

    This screen allows you to define the Gradation Spec. using the sieve sizes and ranges of your choice.

    The Presentation Properties tab allows you to define the line type, line color, line thickness, fill type symbol (optional), etc.

    To plot a gradation specification on a graph, in the Graph Report properties dialog, on the Data Representation tab, you would use the Gradation Specification Expression property. Usually you would specify a field where the specification is stored in your project. For example, in the gINT standard lab tables, you could add a field, such as Specification, in the SIEVE table. The Gradation Specification Expression property would then contain <<SIEVE.Specification>>. In other words, you don't specifically call the Gradation Spec in the Gradation Specification Expression property on the Graph report, you reference a field in your database that calls the Gradation Spec. And, you would make the database field with the specification a lookup to the "Graphic!gradspec" lookup so that you can easily select from all of the Gradation Specs that you have defined in your library. Also, remember to mark the Must use Lookup property to ensure that you only pick from that list.

    The above will put the specification on the graph. If you would like to document the specification on the graph you would use the Functions that Pat mentioned.

    Take a look at the General Purpose Graph report GRF A GNNL02 available for download from the Bentley web site. It illustrates calling different Gradation Spec via a field in the Sieve table (Lab Testing Group) and printing data about the Gradation Specs in a table below the graph.

    As the Help topic mentions, you can show gradation spec envelopes with Fixed Curves on Graphs which may be all that you need. So, you could just define a series of Fixed Curves. But, if you also want to show the gradation specification limits and print the limits in a table, the Gradation Spec is the way to go. You still need to define what gradation spec envelopes you use, but once they have been defined you will be able to use them on all your projects.

    If your library contains any of the "standard lab testing" reports available from Bentley, you probably already have a number of Fixed Curves defined in the Symbol Design application. But, as Pat indicated, the Gradation Spec application is a recent capability and I don't think any of the "standard lab testing" libraries have been updated to include any Gradation Specs. So, to see some example Gradation Specs, download the GRF A GNNL02 Zip file I mentioned above.