Crystal Reports

[msnreddy]

Hi,
I have startdate and enddate fields in database and
using these fields i have to print all weeks between startdate and enddate, and these week values should come on
crystal report Page Header. how can i do this.
can anybody help me please....

Msr

 

[dgillz]

Create a formula field:

{?startdate}&" to "&{?enddate}

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[lbass]

Are you trying to create columns of data by week, i.e., do you want to show each week of n number of weeks going across with corresponding data below each heading? If so, you could try inserting a crosstab with your date field as the column. Then click on the datefield and choose "Group Options" and choose "column will be printed for each week."

If this is the format you want, but the crosstab doesn't have enough flexibility for your needs, you could also create a manual crosstab to get your detail fields by creating formulas like:

if {table.date} in Date(2003, 05, 18) to Date(2003, 05, 24) then {table.amt}

if {table.date} in Date(2003, 05, 25) to Date(2003, 06, 01) then {table.amt}

-LB