I am trying to filter a BAQ Report by Part and Part Revision, similar to the Methods Master Report. If I filter by PartMtl_Part (the parent part) I get all revisions. If I filter by PartRev_RevisionNum, I get all parent parts for that revision number. What I want is the same filter as the latter (select a part and revision), and then have those get passed through to the SSRS report.
Thoughts?
I have limited experience messing with BAQ report but I have plenty of experience on BAQ’s - Since this report is driven by a BAQ cant you add the parameters as needed on the BAQ and get the expected results?
Copied and pasted from elsewhere:
Question - “I have created a BAQ report, using the BAQ Report Designer. I have then added options to filter the results returned. For example, I have a report which displays all of the sale orders which have been made, I want to filter the result returned by Order Number. I have added an option criteria to the BAQ Report Designer, to display this option. The option shows, but when I click preview to view the report, the report has not been filtered by the Order number. Am I missing another required step to make this work?”
Answer -when you create your BAQ for the report put in a parameter (actions > define parameter //you can use adrop down box from an existing baq such as zES_PurchaseOrder and use the PONum)
Then on your table in Phrase build screen add a criteria specifying the new parameter.
When the BAQ and or Report runs it will ask you to choose the PO Num - thus acting like your request for a filter.
I don’t have any issue getting the report to filter based on the “Options”, so I can have a textbox for part number and textbox for part revision that determine what results the report returns. What I am looking at is found under the “Filter” tab of the BAQ Report Designer, and you can see if for yourself in the Methods Master Report. A part revision can be selected from a list, and that part and revision are used to filter the report. The problem is when I do this in my report, only the revision is filtered, not the part as well.
Doing it with the Option fields works, it just requires the user to know the part number and revision exactly. The Filter method would save a step and be easier.