Skip to Content
Former Member
Oct 13, 2016 at 04:48 PM

show group where no detail data where group is a formula


I have been asked to write a report showing totals for items sold by month for variable date ranges. The details has part number, invoice date, quantity, and unit price. To create grouping, I have created a formula field that extracts month from date and another to extract year from date . Then I use both formula fields as the grouping fields; group 1 as @year, group 2 as @month. I have been asked to show all months even if there were no sales within a certain month of the date range. Is there a way to do this in crystal?