Hi, I have a report with a MultiValue string parameter called paramCont hooked up to a dataset which uses the following sql;
SELECT DISTINCT contract, contract + ' | ' + grnCode + ' | ' + dest AS contractDispName FROM vwRpts_OutloadingTickets
ORDER BY contract
The DisplayMember is set to 'contractDispName' and the ValueMember is set to 'contract'
For the majority of cases it works and the report renders ok, however if there are any trailing spaces in the DisplayMember then the report does not render and the red exclamation 'invalid param' displays.
It does not act like this within the designer/preview only when the report is built into the class library and rendered through a browser.
An easy fix to place an RTRIM() in the dataset but think this is a bug an caught me out completely.
SELECT DISTINCT contract, contract + ' | ' + grnCode + ' | ' + dest AS contractDispName FROM vwRpts_OutloadingTickets
ORDER BY contract
The DisplayMember is set to 'contractDispName' and the ValueMember is set to 'contract'
For the majority of cases it works and the report renders ok, however if there are any trailing spaces in the DisplayMember then the report does not render and the red exclamation 'invalid param' displays.
It does not act like this within the designer/preview only when the report is built into the class library and rendered through a browser.
An easy fix to place an RTRIM() in the dataset but think this is a bug an caught me out completely.