[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Printing a report!



Hi Guys,

I have a question about printing  data in a report and my data looks as
follows after i perform a "SELECT"

EMPLID      PRJID                           PRD      EARN
----------- ------------------------- --------- --------- ---
85803       2700371                           1       800
85803       2700371                           2       800
85803       2700371                           4       800
85803       2700371                           5       800
85803       2700371                           6       800
85803       2700371                           7       800
85803       2700371                           8       800
85803       2700371                           9       800
85803       2700371                          10       800
85803       2700371                          11       800
85803       2700371                          12    799.88

Now i need to print in the report as follows :

Project id : 2700371
------------------------------------------------------------------
emplid     Prd1       Prd2--------------Prd12    Total
----------------------------------------------------------------
85803      800        800-------------- 799.88   ******.**


I'll be having many employees in a project. Hope this input is fine to
help me.

TIA




______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com