Get weekdays and weekends in a month

Hi all

Here i am giving the requirement

Page header i have to place months
Jan,Feb .......,Dec

In the details i have to get how many weekdays and weekends in give date range(startdate,enddate) for respective months

if i give startdate 1/1/2005(dd/mm/yyyy) end date 3/1/2005
need to get weekdays -- 1,Weekends --- 2

I am using Crystareports 8.5 and SQL Server as database

Could any one please help me out

ThanksHi all

Here i am giving the requirement

Page header i have to place months
Jan,Feb .......,Dec

In the details i have to get how many weekdays and weekends in give date range(startdate,enddate) for respective months

if i give startdate 1/1/2005(dd/mm/yyyy) end date 3/1/2005
need to get weekdays -- 1,Weekends --- 2

I am using Crystareports 8.5 and SQL Server as database

Could any one please help me out

Thanks

Try putting dates of that month in details section and then use dayofweek crystal function to find whether it is a weekday or weekend in a formula which return 1 then sum them. thats it
i know not the best way.

Get PageNumber in the body

The PageNumber member can be used only in page header and footer. Because Globals can be used only there.
Is there anyway to get page number in the body?

Thank you very much!

No, there is no way to get the page number in the body of the report unless you somehow have your own counter (maybe a group CountRows() and you page break on group).

Get Page Number not in page header and footer.

Hello,
Does anybode know how to determine current page number in report body?
There is Globals.PageNumber variable but it is accessible only in page
header and footer.
Thanks,
Paul.I have many pages report and I want to click on header column in table to
jump to the same page of the report. But for this I have to pass current
page number.
How can I do this?
"Paul Zorin" <Paul.Zorin@.bridge-quest.com> wrote in message
news:#TMkriAuEHA.2804@.TK2MSFTNGP14.phx.gbl...
> Hello,
> Does anybode know how to determine current page number in report body?
> There is Globals.PageNumber variable but it is accessible only in page
> header and footer.
> Thanks,
> Paul.
>