Finishing a quarterly report

rbuser

HI;

I am not sure if this is the right area to post this message. I am using
ReportBuilder Enterprise Edition ver 6.02 with Delphi 4.0 with update pack 3
and Ib Objects ver 3.6Dj.

I am trying to figure out how to finish a quarterly report. I can retrieve
all the required data using quarter start and end dates as input parameters
to retrieve data from a single table. I cannot see any way to group data on
a week ending date for summary purposes. How do I calculate the week ending
dates within the reports and display the dates in the group header.

I cannot believe that this style of report would not be common for any
organization that does any type of production. If anyone can give me some
ideas of how to do this it would greatly appreciated.

Thank in Advance,
David C. Husarik

digitalmetaphors

You can try to create a calculated field on the dataset, to extract the week
from the date. Then you could order by week and date. This all depends on
if IBO 3.6Dj supports a Week method, I looked in their online help, but
couldn't find anything. You'll have to check the IBO documentation to see
what is available. If a you can extract the week and create a calc field to
group on the week, then you can create a lookup query to get the Max() date
for each week.


Cheers,

Jim Bennett
Digital Metaphors