Is It Possible To Create A Variable Column Report > Reporting Support Forum On-Line Help > Stonefield Query: A User-Friendly Reporting Solution

Forums

Subject: Is It Possible To Create A Variable Column Report

You are not authorized to post a reply.

Author

Messages

jhibbs
Posts:22

02/27/2008 7:46 PM	Alert
I have a customer that would like a sales report formatted as follows. Product Lines as the columns and sales territories as the rows. The tricky part is they want to group the Product Lines by Manufacture and provide a column with the Manufacture totals per sales territory. I have provided a simple example below. What I can't figure out how to match the current BASIC report that provides this information. This report can list approximately five Product Lines per page. If there are six a second page is used and for the sixth and totals column. Then the report continues the process for the next manufacture. Any suggestions would be greatly appreciated. I'm really stuck here. Product_Line_1 Product_Line_2 Product_Line_3 Product_Line_4 Product_Total Territory1 Territory2 Territory3 Territory4 Territory5 Thanks In Advance Jeff

Chris Wolf
Posts:237

02/29/2008 8:47 AM	Alert
Hello Jeff, You may be able to get a report similar to this if you put the Manufacturer and Product Line fields in the rows (the rows will break down by Manufacturer then Product Line) then put the Territory in the column and the sales amount in the Data section.

- Chris Wolf Stonefield Software Inc.

You are not authorized to post a reply.

Forums > Stonefield Query SDK > General Support > Is It Possible To Create A Variable Column Report