help with a crystal problem (1 Viewer)

Mish_h

Registered User.
Local time
Yesterday, 22:31
Joined
Mar 30, 2006
Messages
18
Hi.
I have a report that is grouped by month. (Month_Id)
In every group.month there is a formula which creates a percentage based on some figures in the group.
The report is based on a table that is updated monthly

In the report header i would like to display the latest percentage figure. for the latest month.
i.e. if data is in the db for march then it will display the march %. if not then it will display the february %. etc

I have tried a few and so far have not go anywhere. Can anyone give me any ideas please

thanks
 

kesam

Registered User.
Local time
Today, 05:31
Joined
Aug 19, 2003
Messages
12
This Month

One way to do it would be to make your report a subreport of another which picks up only this months figure and displays it in the header.

You can get this months figure by using the "currentdate" and "month" functions in expression fields.

Probably not the prettiest way to do it but it works and it's quick and easy.

Hope this helps. If not let me know and I'll have a look at doing it another way.
 

Users who are viewing this thread

Top Bottom