Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tilakrajsingh

    Can any one help me?

    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...
  2. tilakrajsingh

    Kindly Help me to solve this problem

    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...
  3. tilakrajsingh

    I am greatful if any one can Help!!!! me

    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...
  4. tilakrajsingh

    Kindly Help me to solve this problem

    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...
  5. tilakrajsingh

    Can any one help me?

    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...
  6. tilakrajsingh

    SELECT LAST MONTH ONLY

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

    Kindly Help me to solve this problem

    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...
  8. tilakrajsingh

    I am greatful if any one can Help!!!! me

    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...
  9. tilakrajsingh

    Using Microsoft DataGrid Control with VC++

    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...

Part and Inventory Search

Back
Top