Hello!
I have a Crystal Report that allows for this:
A pop up filter that lets users sort by supplier/vendor. Now this isn’t a BAQ, this is based off OpenPO report native to Epicor.
Is there a way to do something similar with SSRS?
Thank you.
You can filter by supplier(s) on the filter tab
2 Likes
Ahh, nothing else then? The CR one offers a drop down, for example.
So if you are wanting to add an additional sort order there are a few steps you need to.
-
Find the method for Erp.Rpt.OpenPOReport.GetSortByList (replace the report name for whatever report you want to add the sort to. I think you will find not all reports have a sort (I might be wrong).
-
Add post processing BPM to inject the new sort value and label.
-
Modify the formula in the RDL to include the new sort value. It may differ from report to report, but for Open PO I saw two grouping formulas.
End result of the report params forms are:
Classic
Kinetic
I hope that helps.
Correct me if I am misunderstanding, but only allows it to sort by supplier. They want to see a drop down and select which supplier, like it can for the CR version. Is this built into CR or a function of Epicor?
