[QODBC-Desktop] How to Build Assembly report via QODBC
Posted by Rajendra Dewani (QODBC Support) on 14 April 2014 03:27 PM
|
|
How to Build Assembly report via QODBCProblem 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: VB DEMO is to be used for testing of QODBC SQL queries only and is not a development tool.
If you want to use another filter type, you can try 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 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 “Text” field of report CustomSummary. You can run below query in VB Demo 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. | |
|