Hi,
I developed a new report to maintain sales order invoice details.
I need to show above highlighted numbers as a list inside the highlighted box (above packing/delivery method box).
this field is capture from the inventoryitem table.
When I used the column like above always it return only one data(4012.90.10)
Can you please give a solution to select all data (4012.90.10 and 4011.70.00)
Best answer by Anacarina Calvo
View original
+4
Hi
Based on the image you uploaded, seems like you will need to add a sub report to show both values
I agree and think a sub report would be the best option. Another option could be to add another group. If it works the way I’m thinking, it would loop and through display all of the item’s HS codes.
Hi,
you could create a Report Variable to collect all HS codes and then you could reference the Variable at the group level of the report
I agree and think a sub report would be the best option. Another option could be to add another group. If it works the way I’m thinking, it would loop and through display all of the item’s HS codes.
For a different situation but the same function, how would I concatenate in a Sub-report to list all Lot Serial Numbers from a Shipment line for example. I need the below to pull as a single field from left to right.
I would take a look at
The only other option, would be to create a new SQL view that comma delimits the values into a new column which you can map and pull into the report as a custom field. While I can’t find it, Tim Rodman over at AUG Forums had a write up about it.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
