CabMaster RDL Reporting Getting Started Guide

CabMaster RDL Reporting Getting Started Guide

Please note that editing and designing your own report is not part of support, if you would like a customized report then that can be arranged for if you contact your local Sales Representative.

Getting Started

Microsoft Report Builder.exe build 15.0.1473.0

CabMaster with an application version greater than v11.0.0.136

Microsoft Access

Microsoft Access SQL

Microsoft Report Builder / RDL / RDLC Reporting

Generating the report MDB (Microsoft Access Database)

1. Open CabMaster.
2. Place cabinets that are representative of the cabinets to be reported on.
3. Download the  Sample Report ( Sample Report ).
4. Place the sample report in the CabMaster Report directory.
5. Run the Sample Report (File -> Report -> Report).
6. Open the Report Directory.
7. Open the TempReportData Directory.
8. CabMaster will have created a TempReportData.mdb containing all of the reporting information.

Connecting a new report to the MDB

1. Open Microsoft Report Builder
2. Select New Report

3. Select Blank Report

4. Right click on data sources and select “Add Data Source…”






5. Select “Use a connection embedded in report”



6. Select OLEDB in the Connection Type dropdown



7. When writing and testing a report in Report Builder enter the following connection string (replacing <YOURPATH> with the path to the TempReportDataMDB)
      
      Provider=Microsoft.Jet.OLEDB.4.0;Data
      Source=<YOURPATH>\CabExportData.mdb;User Id=admin;Password=;

8. When releasing the report for use replace the connection string with:
      
       Provider=Microsoft.Jet.OLEDB.4.0;Data
       Source=.\TempReportData\CabExportData.mdb;User Id=admin;Password=;


9. Press the Test Connection button.

10. If the connection string’s path is correct you will see the following popup.



Setting up a DataSet

1. Right click the DataSets tab and select “Add DataSet…”

2.  Give it a name e.g.CabMasterData


3.  Select “Use a data set embedded in my report”



4.  Select your Data Source from the list

5.  Enter your SQL query in the text box and press refresh fields
Sample query:
            SELECT Item.id, Item.label, Component.Comment, Component.displayname,
            Component.dimname1, Component.dim1, Component.dim2, Component.dim3 FROM
            Component INNER JOIN Item ON Component.id = Item.id

6.  The corresponding fields will be generated in the Dataset and can be used to populate the report.

Getting a Property’s name (the CabMaster ‘Answer’)

1. Find the input box on the CabMaster page you want to use

2.  Hold the mouse over the text box

3. The Name of the Property (Answer) will appear ( in this example JobState )

Using a Property in a Report

1. Right click on the Parameters Tab and select “Add Parameter…”

2.  Enter the Property Name in the Name field:

3.  Enter the Property Name in the Prompt field:

4.  Select Allow Blank

5.  Go to Default Values

6. Select Specific Values

7.  Click Add

8.  Enter the Default value

Using CabMaster Images in a report

1. Report add a parameter called AMSImages to the report



2. Set the parameter to Allow Blanks and Nulls



3. Set the parameter's visibility to Internal


4. Add a specific Default Value for the image you require (in this example Ortho=600 specifies ortho images at 600x600 px)



5. Add a Second Parameter called  ReportPath

6. Set the parameter to Allow Blanks and Nulls

7. Set the parameter's visibility to Internal

8. Add an Image to the report.  Refer to images using the following:

             ="file:"&Parameters!ReportPath.Value&"\TempReportData\ OrthoImages\"&cstr(CabinetID)&". png"

Replace CabinetID with the field that corresponds to the cabinet's id .
See Image types for more information.

In the following references replace CabinetID with your DataSet field for the cabinet's id.

Sample:


How to reference:
             ="file:"&Parameters!ReportPath.Value&"\TempReportData\PlanImages\"&cstr(CabinetID)&".png"

AMSImage value:
             Plan=600

Elevation

Sample:



How to reference:
             ="file:"&Parameters!ReportPath.Value&"\TempReportData\ElevationImages\"&cstr(CabinetID)&".png"

AMSImage value:
             Elevation=600

Side

Sample:



How to reference:
             ="file:"&Parameters!ReportPath.Value&"\TempReportData\SideImages\"&cstr(CabinetID)&".png"

AMSImage value:
             Side=600

Ortho

Sample:


How to reference:
            
="file:"&Parameters!ReportPath.Value&"\TempReportData\OrthoImages\"&cstr(CabinetID)&".png"

 AMSImage value:
            
Ortho=600

WireFrame

Sample:


How to reference:
             ="file:"&Parameters!ReportPath.Value&"\TempReportData\WireFrameImages\"&cstr(CabinetID)&".png"

AMSImage value:
             Wireframe=600

Hidden

Sample:



How to reference:
             ="file:"&Parameters!ReportPath.Value&"\TempReportData\HiddenImages\"&cstr(CabinetID)&".png"

AMSImage value:
             Hidden=600

Solid

Sample:


How to reference:
             ="file:"&Parameters!ReportPath.Value&"\TempReportData\SolidImages\"&cstr(CabinetID)&".png"

AMSImage value:
             Solid=600

Textured

Sample:


How to reference:
             ="file:"&Parameters!ReportPath.Value&"\TempReportData\TexturedImages\"&cstr(CabinetID)&".png"

AMSImage value:
             T exture=600

Machining

Sample:


How to reference:
             ="file:"&Parameters!ReportPath.Value&"\TempReportData\MachiningImages\"&cstr(IDFULL)&".png"

Replace IDFull with your DataSet field for the Component.IdFull

AMSImage value:
             Machining=600

ReportPath

Returns the path to the report directory. Used for placing images in reports.



AMSFilter

Optionally restricts/extends the data sent to the MDB. By default, CabMaster looks at the SQL statement in the report and generates all tables/fields that are referenced in the SQL. But you may want to provide additional tables/fields in the MDB data, particularly during report development so you can select from more fields.
NOTE: AMSFilters includes wildcards (e.g *.*).
Sample:


AMSImages

Tells CabMaster what images and what resolution to output them as.

For available options see Image Types.

Sample:


Glossary & Notes

            Where the data is sourced from.

            A collection of fields the report will use for data. Defined by a SQL Query.

Allow access to CabMaster drawing properties and configure the report engine for specific tasks.

Reporting information should come from tables and CabMaster Drawing properties.

CabMaster will only export the information requested by the report unless otherwise specified with the AMSFilter parameter.

Make sure fields are correct before editing a report, as they will not update automatically if they change whilst designing the report.
TIP: Click the attachment to download this HowTo to your desktop as a .pdf