Report by Settlement Period

[allyne]

Hi Everyone,

I have a report that prints out each month. within the report title I need to be able to have the Settlement Period date within the report title for example:

Incollect Minutes for Settlement Period 12-16-00 To 1-15-01

and then when I run the report for the next month I need it to say :Incollect Minutes for Settlement Period 1-16-01 To 2-15-01.

Is there any way to do this without using parameters?

Thanks
Cathy

 

[dcm]

Cathy: Try the following:

@Start of period
PrintDate

@End of Period
Printdate+30

Select Transdate in {@Start of Period} to {@End of Period}

Display result in heading through use of text object with embedded formula fields i.e. @Start of Period and @End of Period

If you're running your report in arrears then set @End to Printdate and @Start to Printdate-30

HTH David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner

 

[allyne]

Thanks so much for all your help. I'll give it a try.

Allyne