Is there a way to add table or BAQ to a BAQ Report

[hkeric.wci (Haso Keric)]

@ERPSysAdmin

I was just wondering, how can we access the Report Criteria Prompts in the SSRS report? It doesn’t look like they come through naturally when the report Datasets are created…

If you use the Create SSRS Report from Actions in Report Style it should use the Template File which comes with code that lets you grab the Criteria. It looks like this:

BAQRpt & QuickSearch Pass Silent Parameters to BAQ

Aha!! Found it in the Global Code, ok that makes it much easier than adding the XML Values to SELECT [image]

=Code.GetCriteriaPromptValue(First(Fields!UserCriteria.Value, "RptParameter"),"SYEAR")

RDD BAQ PARAMETER - Parse XML code

Thanks, I never realized that code was available. Now I am able to pull my report options out of the user criteria by name. Much Appreciated!!! =Code.GetCriteriaPromptValue(First(Fields!UserCriteria.Value, "RptParameter"),"SYEAR")