Home > Forum Home > Excel Invoice Template > Can't get it to give me the report I want Share

Can't get it to give me the report I want

Excel Help for Can't Get It To Give Me The Report I Want in Excel Invoice Template


Forum TopicPost Reply Login

Can't Get It To Give Me The Report I Want

Rate this:
(3/5 from 1 vote)
Angry I want to buy this, but they I realized that the Reports and ExportReports functions don't print out all the data. You allow use to enter "attributes". I am doing shirt orders so I added color and size. I like this feature. But when I go to run the report, it doesn't tell me what the attrubutes are for the order.

How do I get it to print out a report that shows the shirt, size and color ordered and a final report of all the orders sorted the same way?
 Amy
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most recent | Chronological | Highest Rated
Oops
Rate this:
(3.7/5 from 3 votes)
The current reporting functionality does not allow to report by product attribute.  This information is saved under 'Discounts' column in the 'Orders' tab after the '|' character, attributes offsets are separated by the '#' symbol as attribute title offset then ':' and value offset.

Therefore, to analyze this data, you will need to use the 'Text to columns' function in Excel and match the offsets to the attribute values in order to create a custom report by attribute. 

Having this as pert of the reporting functionality will require development which we will consider for a future version release.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Can't get it to give me the report I want in the