Hello,
I am trying to customize "Sales by Item Summary Report" so that the report has a item description column. Our item numbering is not descriptive so the report is useless for us without description.
When I create the report the Description field stays blank when I run the report and does not show anything.
This is how I created the report.
I went to create new report, selected Sales>SalesByItemSummary>
I left all the column selections just as they were selected by default and left Filters on next page default as well.
On "Additional Tables and Layout Type" screen I clicked on Add Table button and selected "Item" table.
When I click OK it takes me to screen to create "Link Expression"
Here is what I have selected as an entries
Parent > name of the report (I left what was in there by default)
Link Type > one to one (i tried other options as well)
Table > Item
One to One option > First match (tried others as well)
Link Expression on the left I selected "Text" and on the right I selected "Description"
Got error that Link Expression is to long and to change it to:
Link Expression on the left "left(Text,240)" and on the Link Expression on the right "left(Description,240)"
I select use "Report Genie" and click ok
On the next field when it asked me to select fields I selected from the Salesbyitemsummary table needed field label, qty, amount, and text.
Save the report.
I assume that the "text" field should show Item Description since it was linked to that field in Item table but the when I run report the column is blank.
I tried to also select Description from Item table in the last step but it also stays empty when I run the report.
Can anyone tell me what am I doing wrong?
Thank You,
Henryk
I am trying to customize "Sales by Item Summary Report" so that the report has a item description column. Our item numbering is not descriptive so the report is useless for us without description.
When I create the report the Description field stays blank when I run the report and does not show anything.
This is how I created the report.
I went to create new report, selected Sales>SalesByItemSummary>
I left all the column selections just as they were selected by default and left Filters on next page default as well.
On "Additional Tables and Layout Type" screen I clicked on Add Table button and selected "Item" table.
When I click OK it takes me to screen to create "Link Expression"
Here is what I have selected as an entries
Parent > name of the report (I left what was in there by default)
Link Type > one to one (i tried other options as well)
Table > Item
One to One option > First match (tried others as well)
Link Expression on the left I selected "Text" and on the right I selected "Description"
Got error that Link Expression is to long and to change it to:
Link Expression on the left "left(Text,240)" and on the Link Expression on the right "left(Description,240)"
I select use "Report Genie" and click ok
On the next field when it asked me to select fields I selected from the Salesbyitemsummary table needed field label, qty, amount, and text.
Save the report.
I assume that the "text" field should show Item Description since it was linked to that field in Item table but the when I run report the column is blank.
I tried to also select Description from Item table in the last step but it also stays empty when I run the report.
Can anyone tell me what am I doing wrong?
Thank You,
Henryk
Comment