I have a report that has a ship date parameter. This parameter allows the user to enter a ship date range. I want my report to also include all orders that were due within that date range even if they didn't ship. I tried using the due date as the parameter but then it won't list the orders that shipped even though they were not due. I wanted to add a second parameter one for ship date and one for due date but I dont want the user to have to enter the same date range twice. It seems so easy yet I am drawing a blank.
customer - delivery due date - ship date - ship qty
abc co - 5/21/13 -5/21/13 - 1
I have a parameter in the report that uses the ship date field to enter a date range, it works fine except now my boss wants me to list customers with delivery due dates that are within the date range entered even if they did not ship, so the report would look like this:
customer - delivery due date - ship date - ship qty
I tried using the formula you listed but it didn't work. My report will only list shipped date for the date range entered. I know this is because my parameter uses the ship_date. is there a way to set up a parameter for the due date and tell it to use the date range entered for the ship date? I don't a user of my report to have to enter a start and end date for both ship and due date.
Joined: 25 Aug 2011
Online Status: Offline
Posts: 17
Posted: 21 May 2013 at 7:15am
Hi,
Try below one:
If (isnull(table.shipdate) or table.shipdate ="") then
table.deliveryduedate >= {?start} and
table.deliveryduedate <= {?end}
else
table.shipdate >= {?start} and
table.shipdate <= {?end}
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
