BAQReportParameter not binding to field

Kinetic ERP
, , ,
1

Version 2021.2.20, or 11.1.200

I have a BAQ Report that I’m trying to apply a parameter…

image
image1337×572 54 KB

… but it doesn’t seem to be passing along the value to the database table as I expected it to.

image
image1244×184 11.2 KB

To be fair, I’m using a BAQ Combo box to show security groups, and I was hoping it would just concatenate them in a csv string. Regardless, I only selected one value to test and it still didn’t bind to Character01.

Am I wrong in thinking that the parameters passed from the report form / customization it should show up in this database table? And yes, I’m using the correct table guid value.

Any ideas what I’m doing wrong?

1 Like
2

I can’t explain why it’s not working as is… try binding to callContextBpmData table instead. That will pass to the BAQ report. I feel like the Character01 field in the ReportParam table is used for filtering. I seem to remember it holds a long XML blob that is generated when you use filters on your BAQ report. I could be remembering wrong… but I would either try Character05 or a callContextBpmData field.

2 Likes
3

I second what Dan has suggested.

Bind to a callContext column and add the relationship in your RDL file as well.

There is several guides on here. A really good one from @ckrusen.

1 Like
4

ok thanks, I’ll give it a go and let yuh know

1 Like
5

The more I think about it, the more I think it’s just a weird deal with Character01. I’d try other Character fields in the ReportParam before I’d try the callContextBpmData column.

6

Apparently its not generating a CallContextBpmData_tableguid table at all.
There is a “CallContextData” field on the BAQReportParameter_tableguid table, but its still missing the Character01 field, which is what I bound it to.

image
image1267×574 49.8 KB

<ContextDataSet xmlns="http://www.epicor.com/Ice/300/Bpm/Context">
  <BpmData>
    <Password />
    <ButtonValue>0</ButtonValue>
    <Character01 />
    <Character02 />
    <Character03 />
    <Character04 />
    <Character05 />
    <Character06 />
    <Character07 />
    <Character08 />
    <Character09 />
    <Character10 />
    <Character11 />
    <Character12 />
    <Character13 />
    <Character14 />
    <Character15 />
    <Character16 />
    <Character17 />
    <Character18 />
    <Character19 />
    <Character20 />
    <Number01>0</Number01>
    <Number02>0</Number02>
    <Number03>0</Number03>
    <Number04>0</Number04>
    <Number05>0</Number05>
    <Number06>0</Number06>
    <Number07>0</Number07>
    <Number08>0</Number08>
    <Number09>0</Number09>
    <Number10>0</Number10>
    <Number11>0</Number11>
    <Number12>0</Number12>
    <Number13>0</Number13>
    <Number14>0</Number14>
    <Number15>0</Number15>
    <Number16>0</Number16>
    <Number17>0</Number17>
    <Number18>0</Number18>
    <Number19>0</Number19>
    <Number20>0</Number20>
    <Checkbox01>false</Checkbox01>
    <Checkbox02>false</Checkbox02>
    <Checkbox03>false</Checkbox03>
    <Checkbox04>false</Checkbox04>
    <Checkbox05>false</Checkbox05>
    <Checkbox06>false</Checkbox06>
    <Checkbox07>false</Checkbox07>
    <Checkbox08>false</Checkbox08>
    <Checkbox09>false</Checkbox09>
    <Checkbox10>false</Checkbox10>
    <ShortChar01 />
    <ShortChar02 />
    <ShortChar03 />
    <ShortChar04 />
    <ShortChar05 />
    <ShortChar06 />
    <ShortChar07 />
    <ShortChar08 />
    <ShortChar09 />
    <ShortChar10 />
    <SysRowID>894353ed-12b7-4617-9b09-987edf30e5c5</SysRowID>
    <RowMod />
  </BpmData>
  <Client>
    <ClientType />
    <ProcessId />
    <AssemblyName />
    <CustomizationId />
    <CurrentUserId>JPoston</CurrentUserId>
    <CurrentCompany>TEI</CurrentCompany>
    <CurrentPlant>MfgSys</CurrentPlant>
    <CGCCode />
    <SysRowID>a1641da3-be43-4ca7-969e-96c154b6870d</SysRowID>
    <RowMod />
  </Client>
</ContextDataSet>
7

So… I changed the form control from a BAQ combo box to a normal textbox, and it bound to Character01 properly. But I need it to work with a combo box somehow. I’ll keep messing with it, but would love any tips if you can think of any.

1 Like
8

Does it have to be a BAQ Combo? It appears that Security Groups can be accessed using an EpiCombo where you use the built in business object search and then you can filter there on the EpiCombo as well if you need to. It’s an idea.