How to Build an Assembly Report via QODBC

Problem Description:

How can I build an Assembly report via QODBC

Solution:

If you want to replicate the Build Assembly report via QODBC, I suggest pulling CustomSummary records using QODBC. Below is an 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 only to test QODBC SQL queries and is not a development tool.

If you want to use another filter type, you can try the following 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 a 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 the report CustomSummary.

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

Sp_reportcolumns CustomSummary

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

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

Please click here for more details about sp_reports.