I have a report with a subreport. The subreport receives 3 parameters via the subreport links (firma, mandant, material_key).

Within the subreport, these parameters are mapped to their respective database fields (menu: Report/Selection Formulas/Record):

{cs_kategorie.firma}={?Pm-cs_kategorie.firma} and
{cs_kategorie.mandant}={?Pm-cs_kategorie.mandant} and
{bs_mat_texte.material_key}={?Pm-bs_mat_texte.material_key}

So far, so good.

Under Database/Show SQL-Query there are 3 additional statements in the where-clause:

SELECT bs_mat_texte.material_key, bs_mat_texte.text, cs_kategorie.mandant, cs_kategorie.firma     FROM   bs_mat_texte bs_mat_texte INNER JOIN csgwin-pap.dbo.cs_kategorie cs_kategorie ON    bs_mat_texte.typ=cs_kategorie.xkey     
WHERE  cs_kategorie.firma='605' AND cs_kategorie.mandant='001' AND bs_mat_texte.material_key=90152 AND     
bs_mat_texte.typ = 'BEM' AND 
cs_kategorie.sprache = '000' AND 
cs_kategorie.kategorie_nr = 5073

These last 3 lines have to be defined somewhere. The values are static.

But I can’t figure out, where these are set.

Any advice welcome 😉

I’m using CR Version 14.0.4.738 RTM

Thank you

I looked into the formulas and the database expert and any place and formular but found nothing. I used the search in CR without any results.