Sorted it out! I applied this directly to the Quantity data source, instead of adding to the databand filter :) {IIF((Table1.InvHistoryTypesInvHistoryType == "Return"), (Table1.InventoryHistoryQuantityChange * (-1)), (Table1.InventoryHistoryQuantityChange * (+1)))} Thank you though for you...

Hello, Please send us your report with test data which reproduces the issue for analysis. Thank you. Hi Aleksey, thanks as usual for the response! Attached is a version of the report that is receiving the casting error. The image below is almost what I need. https://ibb.co/jqH5ka But what I need to...

Hello, I am trying to find each line item of type "Return", and multiply the quantity by -1 if true, by +1 if false. I am using the following expression in my databand filter: IIF((Table1.InvHistoryTypesInvHistoryType == "Return"), ((Decimal)Table1.InventoryHistoryQuantityChange ...

Hello, Please check the modified report in the attachment. Thank you. Hi Aleksey, Thanks again for your help! That was almost perfect, but I did need to make 2 changes. I changed the first operator to >= instead of just greater than. I also noticed that in the report you sent, it was excluding any ...

Hello. There should be a C# expression. It should be like next: Table1.InventoryHistoryQuantityChange > DateSerial(Today.Year, Today.Month, 1).AddMonths(-1) && Table1.InventoryHistoryQuantityChange < DateSerial(Today.Year, Today.Month, 1).AddDays(-1) Thank you. Hi HighAley, Thanks again for...

Hello. There should be a C# expression. It should be like next: Table1.InventoryHistoryQuantityChange > DateSerial(Today.Year, Today.Month, 1).AddMonths(-1) && Table1.InventoryHistoryQuantityChange < DateSerial(Today.Year, Today.Month, 1).AddDays(-1) Thank you. Hi HighAley, Thanks again for...

Hello, David. Please, try to change the Field Is to Expression in the Filter and write your own expression for the filtering. Thank you. Thanks for the reply. So I have removed the above variables and in the databand filter, I am filtering between: DateSerial(Today.Year, Today.Month, 1).AddMonths(-...

Hello, Please send us a simple report with test data which reproduces the issue for analysis. Thank you. I don't necessarily have to use the method seen in that report. If there is a better way of filtering to only show records from the previous month then I am definitely open to that. Thanks again...

Aleksey wrote:Hello,

Please send us a simple report with test data which reproduces the issue for analysis.

Thank you.

Thanks for your time, find the attached report.

David

Hello, I am having trouble figuring out how to filter my reports to only show the previous month. For instance, today is February 22nd. If I run my report it should only show records from Jan 1 - Jan 31. If I run the same report on March 22nd, it should only show Feb 1 - Feb 28, etc. I know in the d...