Recent content by tilakrajsingh

Can any one help me??? please???

Here is my SP :- ********* create procedure StockVouchers as SELECT akki.GRNHead.GRN_ID as VoucherId, akki.Document.Doc_Type as DocType, akki.GRNHead.GRN_Type as VoucherType, akki.GRNHead.GRN_Unit as VoucherUnit, akki.GRNHead.GRN_VNCD as VoucherVNCD, akki.GRNHead.GRN_Date as VoucherDate...

Here is my SP :- ********* create procedure StockVouchers as SELECT akki.GRNHead.GRN_ID as VoucherId, akki.Document.Doc_Type as DocType, akki.GRNHead.GRN_Type as VoucherType, akki.GRNHead.GRN_Unit as VoucherUnit, akki.GRNHead.GRN_VNCD as VoucherVNCD, akki.GRNHead.GRN_Date as VoucherDate...

Here is my SP :- ********* create procedure StockVouchers as SELECT akki.GRNHead.GRN_ID as VoucherId, akki.Document.Doc_Type as DocType, akki.GRNHead.GRN_Type as VoucherType, akki.GRNHead.GRN_Unit as VoucherUnit, akki.GRNHead.GRN_VNCD as VoucherVNCD, akki.GRNHead.GRN_Date as VoucherDate...

Hi IdoMillet Thanks for your valued reply which i was expecting. Let me explore my query: 1. Our financial year starts from 01-Apr-03 to 31-mar-03. 2. The product table having a field as OpeningQty which contains the closing balance of that item as on 31-mar-03. 3. I want to print a stock...

i am using crystal report 8.5 to create a stock statement having stored procedure as data source. my store procedure brings all data e.g. Opening balance on year starting (e.g. 01-Apr-03) , all receipts (e.g. till date 31-Oct-03)), all issues (e.g. till date 31-oct-03). i want to print a stock...

You can use following statement in record selector :- DatePart("m", (dateadd ("m", -1, currentdate))) ************** or {datasource.lnkmon} = datepart("m", (dateadd("m"-1 ,currentdate)))

Hi I am creating a stock statement for a particular period using SQL 2000 store procedure with Crystal report. I am having tables : Product -> with field1: pr_item field2 :pr_opening (stock as on year starting...

Hi I am creating a stock statement for a particular period using SQL 2000 store procedure with Crystal report. I have : Table : Product -> with field: pr_item pr_opening (stock as on year starting...

In continuation to steve's solution : I have no idea about VC++ but the same works with VB6 When you press the right mouse button on DataGrid, it popup a menu where you will find insert option which will enable you to insert the new cols into datagrid (If not found, please search insert...