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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.