How to Build Assembly report via QODBC

Problem Description:

How can I Build Assembly report via QODBC

Solution:

If you want to replicate the Build Assembly report via QODBC, I kingly suggest you to pull CustomSummary records using QODBC, below are the example:

sp_report CustomSummary show Amount_Title, Text, Label, Amount parameters DateMacro = 'ThisMonthToDate', SummarizeRowsBy = 'ItemDetail', SummarizeColumnsBy = 'TotalOnly', Calendar = 'FiscalYear', ReturnRows = 'ActiveOnly', ReturnColumns = 'ActiveOnly', TxnFilterTypes = 'BuildAssembly', ReportDetailLevelFilter = 'SummaryOnly'

Note:  QODBC Support Wizard is used to test QODBC SQL queries only and is not a development tool.

If you want to use another filter type, you can try the below command to view all available parameters and values in CustomSummary:

Sp_parameters CustomSummary

If you want to add any field to your query, please add the field name behind the keyword “show”.

For example, if you want to add a field “Text” into your query, you can try to build query like:

sp_report CustomSummary show Text parameters DateMacro = 'ThisMonthToDate', SummarizeRowsBy = 'ItemDetail', SummarizeColumnsBy = 'TotalOnly', Calendar = 'FiscalYear', ReturnRows = 'ActiveOnly', ReturnColumns = 'ActiveOnly', TxnFilterTypes = 'BuildAssembly', ReportDetailLevelFilter = 'SummaryOnly'

The query will return information in the “Text” field of report CustomSummary.

You can run the below query in QODBC Test Tool to view all available fields in CustomSummary:

Sp_reportcolumns CustomSummary

The command above will return a list of all fields in report CustomSummary.

Please choose the fields you need to add to the query.

Please click here for more details about sp_reports.