By using this website, you agree to our Terms of Use (click here)
I'm looking at the INKitRegister and InComponentTran tables. I need a report that outputs all the components on a single row. I know that a simple join will include them all in a group. So I'm making 5 joins (we never have more than 5 components). I had thought to use the line numbers, but they're jacked. Most components go 3,5,7. But I have some starting at 7 and for some really strange reason, I even have line numbers that are evens: 6 and 14.
How in the world do I get a single row output for each kit assembly listing every component in the kit?
Example Output:
Assembly 1, component 1, component 2, component 3
I haven't noticed that funny line numbering on Kits before, but I have noticed it in other areas so I'm not totally surprised that Kits do it too.
Since the line number isn't predictable (even more unpredictable if you end up deleting a line), I can't think of a way to do a join.
There is a feature called "Tabular" in Report Designer that would allow you to specify that rows print as columns. Take a look at Lesson 6: Creating Tabular Reports in the S130 Reporting course.
You could also use the Pivot Tables (SM208010) screen to define a Pivot Table that would show the components as columns.
Thanks @timrodman I am currently using a tabular version my vars made that I've tweaked and it's close to what I want, but it's still outputting rows of kit components, although each column IS a unique kit. My guess is that I may have a grouping issue somewhere. Thanks for the link, I've not had formal documentation on this.
Online Members
