hi Jack Corbett

I am using datetime datatype for the BILL_DATE in my database

Gururajan.K

Hi Eli

This is the error i am receiving

An error occured during local report processing.

the value provided for the report parameter 'rpToDate' is not valid for its...

Hi Dave

Thanks for your reply, i search that book immediately. and i serch msdn for more advanced topics to learn somthing.

Regards

Gururajan.K

HI,

Thats why i am asking qustion

Thats my qustion any possiblities is there lock the table or not.

It is possible then how?

Guru.K:-P

HI

Just want to know it is possible or not.

guru:-)

HI

Just want to know it is possible or not.

guru:-)

Hi

Thanks For reply. i will See that link

Regards

Guru.K:-)

SELECT MEMBER_CODE,FIRST_NAME,DATE_OF_USING,

OPENING=(SELECT SUM(DR_AMOUNT-CR_AMOUNT) FROM MEMBER_SUMMARY MEM

WHERE MEM.MEMBER_CODE=MEMBER_SUMMARY.MEMBER_CODE

AND MEM.BRN_CODE=MEMBER_SUMMARY.BRN_CODE

AND MEM.COMP_CODE=MEMBER_SUMMARY.COMP_CODE),

SUM(DR_AMOUNT) AS DR_AMOUNT,

SUM(CR_AMOUNT) AS CR_AMOUNT

FROM MEMBER_SUMMARY

WHERE ACTIVE_FLG='A'

AND BRN_CODE='001'

AND COMP_CODE='001'

AND DATE_OF_USING BETWEEN '2008-08-01' AND '2008-10-30'

GROUP BY MEMBER_CODE,FIRST_NAME,DATE_OF_USING

ORDER BY MEMBER_CODE,FIRST_NAME,DATE_OF_USING

CLOSING CALCULATING BY OPENING+(DR-CR)

avoid leftouterjoin, and match the all common columns in where clause

or use innerjoin

guru

I would be able to create a script for it.

guru

LIKE IS USED YOUR QUERY IN RESULT PART

IT IS NOT WORKED

GURURAJAN.K MSc,MBA

SOFTWARE ENGINEER

U R USING SEPERATOR(,) BEFORE KEYWORD FROM THAT IS AN ERROR

xx