Might anyone have had previous success with creating a BAQ report using a CTE-based BAQ? General problem I’m having: The CTE BAQ behaves as expected when entering a part number as a BAQ parameter - but - the BAQ report seems to maintain the parameter option value even when running through the vari…

Unsolicited opinion: that seems like the perfect thing for a dashboard… Do you need it on paper? Maybe just tell them it can’t be done on a report? makes your life easier, and then they have up to date information. It doesn’t solve your problem, but that’s what I would do.

@Banderson – I’m definitely leaning towards your suggestion at this point. Nah - we don’t really need this solution to be report based. At my company, the default is to provide reporting, rather than dashboards. However, in this case, since we also have to link the part list back to historical sa…

The way I did my CTE is I always maintained the Top-Level Columns, Showed an Hierarchy for Sorting… Top Level Job Demand Job Number [2019-02-07_1344] This is where I started… First made a SQL Prototype for me this was related to JobProd (Job Demands) https://www.essentialsql.com/recursive-ctes-…

@Banderson / @hkeric.wci : Just reporting back here on my progress so that you know what path I took in this case. Brandon - I went ahead and scrapped the SSRS report idea because the solution seemed to fit more into the realm of a dynamic dashboard. Sometimes, it’s good to get slapped with the “S…

Glad you got it working. I usually find that the dynamic-ness of a dashboard has a lot of value that paper doesn’t (which is one of the reasons I still don’t know hardly anything about SSRS reports :wink:). And looking at what you had as example, that doesn’t look that it would do well on paper at a…

Oh, believe me, it didn’t. I thought I could piece together everything with the sales orders all in one shot - but it just wasn’t working. The dashboard was the right call. Besides, it’s easier for the user to employ the “group by” panel and assess the data in any manner he’d like. Thanks again,…

Sometimes its best to give yourself the Solution when unsure :slight_smile: hehehe. No Worries mate. Note for anyone reading this… In Order to make my Hierarchy Searchable in a Dashboard… I did add a JobNum: textbox via a Customization and when the User fills it out and Text Changes it populates th…

A little late but I just came across this. To do a CTE Recursive query in SSRS, you need to write the query for the dataset in the report as a CTE.

CTE-based BAQ Report

Epicor ERP 10

hkeric.wci (Haso Keric) February 12, 2019, 12:44pm 9

SerialRecursive.baq (9.1 KB)

If anyone wants Recursvie Serial BAQ =) Something I tinkered with - Shows Matched Serial Numbers

CTE BAQ to drill up through PartDtl

Topic		Replies	Views
BAQ Report using CTE BAQ? Epicor ERP 10	2	1633	April 18, 2019
Production Report with Parent-Child Grouping Epicor ERP 10 baq	12	3301	March 12, 2020
Recursive CTE BAQ parameters Epicor ERP 10 baq , cte	21	1622	October 1, 2024
CTE BAQ to drill up through PartDtl Epicor ERP 10 baq	1	967	April 8, 2020
BAQ that shows material part demand Epicor ERP 10 baq , dashboard , part	2	1158	October 17, 2023

CTE-based BAQ Report

Related topics