yes that is correct DB2 has lot of limitations and i don't know how can i achieve this ,

i m copying what i tried,i tried to load this into...

sorry for not providing this earlier

create table "xx"."table"(

"type_code" varchar(2) NOT NULL,

"PROCESS_TS" TIMESTAMP NOT NULL ,

"AMT" DECIMAL(11,2) NOT NULL ,

"MAX_ENTERED_AMT" DECIMAL(11,2) NULL,

"MAX_ENTERED_TS" TIMESTAMP NULL )

...

Thank You, will try to see if i can do anything similar in DB2

please find the inserts

INSERT INTO "RAGHA"."INS1_ADD_PROCESS" (

...

Thanks for the response, database here is DB2, so tables were also created in DB2 which is little different from SQL.

CREATE TABLE "AAA"."ADD_PROCESS" (

...

Data type is varchar(10)

Hi

Thanks for reply.I will try to research...plz let me know if you know anything more about it.

Thanks

Ragha

Thanks for the responce...sorry if i didnt explain my question properly

Hi

Thanks for responce.I need my data like this,and i m using template

when i select multiple program name from drop down,then my data should look like this in report

group by program...

Hey

Got it guys.thank you somuch for your help.

Thanks

Hi

Yes, in my template the first row is header where i am getting the column names and down that detailed row

that is nothing but tables details group.so,when i try to...

Hi

thanks for your help.with list i m getting all the letter on the single page

Daniel Bowlin

I can able to do with your suggestion.

One concern is that

Now I can see...

Hey

Thank you somuch its working but.I want this first letter should be displayed in my report for all

I need something like this

X

Member Name ...

Thanks

it worked.

but y it didnt work without []?

Thanks