crystalreporting
Instructor
Anyone have a SQL stored procedure or view to 'flatten' a BOM?
Peter Shirley
Peter Shirley
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Flattening a BOM
- Thread starter crystalreporting
- Start date
- Status
Do you mean to make it single level? Interesting concept but no.
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown
- Thread starter
- #3
crystalreporting
Instructor
Don - yep that's exactly what I mean. Developing reports on the BMPRDSTR has always been tough, and Crystal's bulit 'hierarchical' reporting function helps a little, but not enough. I'm thinking a stored procedure to flatten the BOM would make reporting a snap for resellers and customers alike.
Peter Shirley
Peter Shirley
Peter
I posted a function that would accept a parent item and return all the components for all levels of the bill. Changing this function to a stored proc would be a minor change. I don't know crystal well enough to say what would and would not work for you.
here is the thread.
Please post the changes that you make. I would like to know what is required for crystal.
Hope this helps.
Tom
I posted a function that would accept a parent item and return all the components for all levels of the bill. Changing this function to a stored proc would be a minor change. I don't know crystal well enough to say what would and would not work for you.
here is the thread.
Please post the changes that you make. I would like to know what is required for crystal.
Hope this helps.
Tom
Peter,
Check out my website and the Macola tools section. I have a utility called Bom Builder which you could use to do this, although I am not sure how much work it would be.
At any rate check this out and let me know your thoughts.
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown
Check out my website and the Macola tools section. I have a utility called Bom Builder which you could use to do this, although I am not sure how much work it would be.
At any rate check this out and let me know your thoughts.
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown
- Status