I have a custom report involving 3 dataitems in 1 dataset, the main dataitem is the "Customer" table and the only filter on the report is "No." as you can see below
report 50105 CustomerHistory
{
Caption = 'Customer Sales History';
UsageCategory = Administration;
ApplicationArea = All;
RDLCLayout = 'CustomerHistoryRpt.rdlc';
WordLayout = 'CustomerHistoryRpt.docx';
dataset
{
dataitem(Customer; Customer)
{
RequestFilterFields = "No.";
column(CustomerNumber; "No.") { }
column(Name; Name) { }
column(Balance; "Balance (LCY)") { }
column(E_Mail; "E-Mail") { }
column(Phone_No_; "Phone No.") { }
}
The report runs fine when I use the URL with report id:
https://businesscentral.dynamics.com/.../?report=50105
but I cannot pass a customer No. in the URL I am always getting "the filter string contains invalid parameters"
I followed the below link for examples:
https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-web-client-urls
I tried the below combinations and none of them works:
https://businesscentral.dynamics.com/.../?report=50105&filter='No.' IS '1452'
https://businesscentral.dynamics.com/.../?report=50105&filter='Customer.No.' IS '1452'
https://businesscentral.dynamics.com/.../?report=50105&filter='CustomerNumber' IS '1452'
https://businesscentral.dynamics.com/.../?report=50105&filter='Customer.CustomerNumber' IS '1452'
https://businesscentral.dynamics.com/.../?report=50105&filter='No.' : '1452'
Thank you
