cross tab

[charvi]

i am using crystal reports 9 i want a report to know the time spent on each day for a client here i use cross tab report
now if i want to see for a particular month how to query it pls help

[QVeen72]

Hi,

Pass a RecordSelection Formula before Viewing the Report..:

For Feb -2008:

[code=vb]
m_Report.Record SelectionFormul a = "Month ({MyTable.MyDAT E})=2 AND Year ({MyTable.MyDAT E}) =2008"
[/code]


REgards
Veena

[charvi]

Hi,

Pass a RecordSelection Formula before Viewing the Report..:

For Feb -2008:

[code=vb]
m_Report.Record SelectionFormul a = "Month ({MyTable.MyDAT E})=2 AND Year ({MyTable.MyDAT E}) =2008"
[/code]


REgards
Veena

This code works
this code is used for p aparticular month.now if i want between two dates how to code

[QVeen72]

Hi,

Check This ink

Regards
Veena