Is there a way to increase the Report Query width to +164 (more than 164)?

When I try to create a new report that is more than 164 characters in report width; it does not allow me to create the report.

Any suggested solutions?

Hi Dwaine,

The number of characters in the Sales Analysis online inquiry is the maximum it is, to fit within the structure. This maximum cannot be exceeded.

You can reduce the number of characters used for a field, so that you can fit more columns. For example, you may not need 15 characters to view quantity or amount information. Edit the column width to a smaller number and this may allow you to get under the 164 maximum.

Also, there may be some information that is replicated and not required, such as a customer number in the detail drill-down if the Name is already there. Check if there are any columns that could be removed from either the summary or detail views.

How are you thinking of "Printing" this report?

If you are trying to export some SalesAnalysis information to Excel, then you could select the fields you want and Filter the records before sending them to Excel using the ExcelDirect button. (A new feature in SalesAnalaysis V9.0A.)

Perhaps with a clearer idea of what you are trying to accomplish we might offer more guidance.