see forget about my last posts

I tell u from beginning.

I have one table name as ledger

in that column names are :

id,accnm, grpnm,supergrp,debitamt,creditamt.

now when i save data in ledger it...

I want to filter the data which has same group name.and display them in report in two different columns and their sperate amounts.

which base tables. do mean database tables. but from that how can i get this output. I use parameterized query for that but it wont work properly

Hello,

Sorry because i am forcing u to give reply.

I am sorry but I relay don’t know about sql views. and this work can not be done without view. Please...

as per your advice i have create new table Details are:

table name ledger

Feilds:

id

accnm

grpnm

supgrp

deb

crd

id is unique for each account name.

data in tahe table is :

id ...

can you provide me some links from which i can understand(learn) more about views. because i have to do this task. Its realy important for me.

please give me solution for this problem. How I can solve this.

Ok,

Then what changes I have to perform on table to get this output.

I have make diffrent two views and the combine them in the report.

But the report not showing...

I show you table details:

table name group

feild

grpnm

supergroup

debit

credit

Table data:

grpnm supergroup debit credit

cash Assets 10 ...

Thank you for so fast reply.

actually I don't understand how to post the code . Next time i will take care of it.

I use this queary but the view...