I am using CRv8 from a SQL Database
I have a cross-tab report parameter set up to specify a date range on calls in the database. This picks out all calls opened within the period specified and summarises the status by group. This works perfectly. However, what I really want to do is also count the number of calls which were closed within this period, which were opened previously.
I have tried adding a line to the Edit Selection formula (Record) reading {HDWCALL.HDWCLSDAT} in {@DateRange} but I get an error as CR says it's expecting a value instead of a fieldname. When the cross-tab generates the report it seems to create a line in the same syntax {HDWCALL.CALLDAT} in {@DateRange}
Does anyone have any ideas or should I try a completely different approach?
I have a cross-tab report parameter set up to specify a date range on calls in the database. This picks out all calls opened within the period specified and summarises the status by group. This works perfectly. However, what I really want to do is also count the number of calls which were closed within this period, which were opened previously.
I have tried adding a line to the Edit Selection formula (Record) reading {HDWCALL.HDWCLSDAT} in {@DateRange} but I get an error as CR says it's expecting a value instead of a fieldname. When the cross-tab generates the report it seems to create a line in the same syntax {HDWCALL.CALLDAT} in {@DateRange}
Does anyone have any ideas or should I try a completely different approach?