How do I modify the report filter such that I can include a user defined field from the Customer Field of the Configuration GUI? I would like to be able to generate reports by filtering on a Numeric Field. Any assistance in this matter would be deeply appreciated.
Make a copy of the file you want to modify. Right click the file and uncheck the Read Only option. Change the name of the file so that it start with 'Custom - "insert name of file here"' (with out quotes). Open the file using Notepad. Copy and paste the column below at the bottom of the file.
********************************* Begin Column FieldName = "Customer.CustomNumber1" DrillDownFieldName = "" DrillDownReportName = "" Title = "!CaptionCustomerCustomNumber1" VBDataType = vbDouble Formula = "" ColHidden = True ColNotDisplayable = False FilterDisabled = False ColWidth = 1080 GroupMethod = groupmethodNone ColFormat = "" ColAlignment = flexAlignLeftCenter End Column
********************************* Save the file. Note: In order for this to work the Customer table has to be apart of the query. Restart Manager, go to Reports then Custom your newly created report should be there now.
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here.
All logos and trade names are the property of their respective owners.