Hi Expert,
I have an SSRS using FetchXML. Im having an issue getting the "All" company in my parameter.
In my parameter I have a value of ABC and DCE and ALL. I can get the ABC and DCE except for ALL(company) since I don't have a code or guid set on the value since we have a lot of records for company and can get increase.
How can I get all the value in the company table?
This is my XML filtering the company parameter.
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false" >
<entity name="new_companyenrollment" >
<attribute name="new_companyenrollmentid" />
<attribute name="new_company" />
<attribute name="new_staffname" />
<attribute name="new_customername" />
<filter type="and" >
<condition attribute="new_company" operator="eq" value="@param_company" />
</filter>
</entity>
</fetch>
Thank you!