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

Re: Printing a report!



---mahidhar puvvada <mpuvvada@HOTMAIL.COM> wrote:
>
> 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
>
>



The easiest way i know is to use arrays and then go from there

hope this helps

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

_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com