If you did have an answer you might consider creating a parameter or parameters to use for record selection. These can be passed to record selection process
Doing this will allow you to pass the value for 'Honda' or some other manufacturer name to the record selection formula. Your report will then only contain the information for that specific make of engine.
You did not say which version of CR you are using. How to do this is generally well described in the help file for CR. I have been working with what are called dynamic cascading parameters or DCP's recently. In that case I found Brian's new most recent book very helpful. If you dont own a copy a my consider buying one.
Hope this will get you pointed in the right direction.
Regards,
John W.