Knowledgebase
[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 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:  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.

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).