I have designed a report that allows me to get the detailed transaction per account or for all accounts in one row of an excel spreadsheet, i.e. account number, account description, Fiscal year, Period, doc date, source, source type, posting sequence, batch entry, description, reference and posted amount, which makes it very easy to use in a spreadsheet, see below
However, I can't work out how to get the option to define a range of periods. You can do this when you use the standard Crystel Report, see below.
Whereas on my report, I can only choose one period, see below.
Can anyone tell me what I need to do to get a range of periods?
Thanking you very much in advance for any assistance you can offer.