CRXI
I need to remove parameters {?Year},{?Month} from the report and use lastfullmonth function to run and distribute report in InfoView.
I have the following selection formula in one of subreports which displays data for selected month plus the previous month (2 month range):
{INCIDENT.INC_RESOLVE_ACT} in {@Last Period Start Date} to Date ({?Year},{?Month},{@Last Day})
{@Last Period Start Date} is a first day of the month that previous to the selected month
{@Last Day} is the last day of the selected month
I tried to change it:
{INCIDENT.INC_RESOLVE_ACT} in {@Last Period Start Date} to maximum(lastfullmonth)
but I do not know how to catch the first day of the month that previous to lastfullmonth.
Please give me idea how to accomplish this? Thank you!
I need to remove parameters {?Year},{?Month} from the report and use lastfullmonth function to run and distribute report in InfoView.
I have the following selection formula in one of subreports which displays data for selected month plus the previous month (2 month range):
{INCIDENT.INC_RESOLVE_ACT} in {@Last Period Start Date} to Date ({?Year},{?Month},{@Last Day})
{@Last Period Start Date} is a first day of the month that previous to the selected month
{@Last Day} is the last day of the selected month
I tried to change it:
{INCIDENT.INC_RESOLVE_ACT} in {@Last Period Start Date} to maximum(lastfullmonth)
but I do not know how to catch the first day of the month that previous to lastfullmonth.
Please give me idea how to accomplish this? Thank you!