Dragging & Dropping DataSource Columns in Template Report not fetching correct results
Posted: Sat Mar 30, 2024 12:51 pm
Hi All,
We are using Template Reports and when we drag and drop columns from the DataSource -> LineItem - >Records -> [ColumnName], the Expression it is making is Records.[ColumnName] thus it is not fetching any results.
If we manually edit the expression to LineItems.Records.[ColumnName] then it is fetching the correct value. So can you please let us know how to automatically include LineItem. when we are dragging and dropping columns from the DataSource.
Basically we would like this expression to be generated when we are dragging and dropping {NameOfDataSource.NameOfTable.NameOfField}
Please see the attached video.
We are using Template Reports and when we drag and drop columns from the DataSource -> LineItem - >Records -> [ColumnName], the Expression it is making is Records.[ColumnName] thus it is not fetching any results.
If we manually edit the expression to LineItems.Records.[ColumnName] then it is fetching the correct value. So can you please let us know how to automatically include LineItem. when we are dragging and dropping columns from the DataSource.
Basically we would like this expression to be generated when we are dragging and dropping {NameOfDataSource.NameOfTable.NameOfField}
Please see the attached video.