Ssrs

Epicor ERP 10
1

In my report I built, i have everything grouped in rows by Vendor. However, I have been asked to make it an either or with Part Number. And the selection will be on the menu that pops up during test. Is that even possible?

2

I’m not sure I follow what you are asking, can you expand a bit?

3

They want to use this screen to select how the data is sorted in the report. But they want the heading to say the Vendor ID if the Vendor id is selected in the fields int he picture or the part number, if selected.

po issues

1 Like
4

@josecgomez and they want the Vendor ID or part number to be in the report as the group by. Hope that makes better sense.

1 Like
5

This can be done using the BAQReportParameter.SortBy field. Define a group in the SSRS report based on the value chosen.
image

2 Likes
6

You can also do it in SSRS if that’s what you’re asking about, like this:

image
image.png769Ă—207 4.55 KB

Create a Parameter for the Group By Options,

image
image.png904Ă—524 34.8 KB

Add code to the Select statement of the report query, to calculate the correct group by field.

	CASE @GroupBy WHEN 'Customer' THEN c.Name
		WHEN 'Quote' THEN CAST(qh.QuoteNum AS NVARCHAR)
		WHEN 'Part' THEN qd.PartNum
		WHEN 'Product Group' THEN qd.ProdCode
		END as Groupby

Change the Group Properties to group by the new field.

image
image.png1471Ă—1024 80.3 KB

1 Like
7

@nhutchins what do you mean by the Select Statement of the Report Query? Is that in the BAQ before the SSRS? Or is that the DataSet Properties–>Query?

8

Sorry, my example was for a straight SSRS report, not a BAQ report. Basically, you are creating a calculated field to group by on. I would think you might be able to do the same thing by creating a Calculated field in the BAQ.

9

All good,I figured it out! Thanks!