Symbol for comment in statement in Foxpro

Comment in foxpro is * or Note if user don't want to interpret the statement than either this two symbol is used.

यदि हमें अपने फॉक्सप्रो प्रोग्राम मे कोई कमेंट देना हो तो उसके लिये * या Note लिखते है जैसे 

*Write a program for Leap Year

Note Write a Program for Leap Year 

इस तरह से लाइन इन्टरप्रेट नहीं करता है। .. और प्रोग्राम में कोई एरर नहीं दिखाता है  

Create a report file in Foxpro

 

fjiksZV

MsVk dks fyLV dekaM dh enn ls fLdzu ij iznf’kZr fd;k tk ldrk gSA fyLV ds }kjk vkmViqV dk izLrqrhdj.k gksrk gS ij u rks blesa dgha ;g fy[kk x;k gS fd vkmViqV fdl dke ds fy;s gS u gh blesa fofHkUu vkafdd izfdz;k;sa djus dh lqfo/kk miyC/k gSA ;fn QkbZy dks fdlh dze esa O;ofLFkr :Ik ls fizaV djkuk pkgrs gSa rks ;g Hkh blesa laHko ugha gSA bl vlqfo/kk ls cpus ds fy, rFkk vkmViqV dks vf/kd iBuh; rFkk vkd”kZd cukus ds fy, QkDlizks esa ,d vR;ar izHkko’kkyh fjiksZV izLrqrhdj.k lqfo/kk iznku dh xbZ gS ftlds tfj;s MsVk QkbZy dks ,d lqfo/kk iznku ds lkFk ,d fu/kkZfjr QkesZV ds :Ik esa izLrqr fd;k tk ldrk gSA bl QkesZV esa tgka MsVk QkbZy dk vf/kd iBuh; :Ik esa izLrqr fd;k tkrk gS ogka vf/kdkf/kd lwpukvksa dk ,d lkFk izLrqr fd;k tk ldrk gSA

fjiksZV dh fuEufyf[kr fo’ks”krk,a %&

1 fdlh fu/kkZfjr ‘kh”kZd dks fjiksVZ ds izR;sd ist ij fizaV fd;k tk ldrk gSA

2 fQYM ;k fjdkMZ dks vko’;drkuqlkj eupkgs dze esa O;ofLFkr fd;k tk ldrk gSA

3 QhYM ds lkFk&lkFk mi;ksxh VsDLV dks Hkh fy[kk tk ldrk gSA

4 QhYM dh pkSMkbZ dks fjiksZV ds nkSjku gh de ;k T;knk izLrqr fd;k tk ldrk gSA

5 izR;sd ist ij ‘kh”kZd ds lkFk&lkFk QqVj Hkh fizaV fd;k tk ldrk gSA

6 i`”B ds vkdkj] ekftZu dks fu;af=r fd;k tk ldrk gSA

7 fjiksZV ds fofHkUu Hkkxksa dks vyx&vyx LVkbZy esa tSls& Bold, Italic, Bold Italic rFkk Underline izdkj ls fizaV fd;k tk ldrk gSA

8 fjiksZV ds fdlh Hkh Hkkx dks ckDl ds vanj gh izLrqr fd;k tk ldrk gS] tSls& tksM] ?kVkuk] vkSlr vkfn dh x.kuk dh tk ldrh gSA

9 vkafdd MkVk ds vk/kkj ij dbZ vad xf.krh; izfdz;k,a dh tk ldrh gSaA MkVk dh fofHkUu xzqi esa  oxhZd`r dj fizaV fd;k tk ldrk gS rFkk fofHkUu xzqi ds Hkkxksa dks vyx&vyx tksMk tk ldrk gSA fjiksZV izLrqrhdj.k ds fy;s ,d ls vf/kd MkVk QkbZy dk iz;ksx fd;k tk ldrk gSA Creat Report dekaM }kjk cuk;k tkrk gSA ftldk ,DlVsa’ku - .FRX gksrk gSA

10 fjiksZV iwjs MkVk QkbZy ds lkFk iz;ksx djus ds LFkku ij dqN p;fur fjdkMZ dk Hkh iz;ksx djus ds fy;s Hkh fu;af=r fd;k tk ldrk gSA

ge ,d MsVkcsl cukrs gSA

Create Sales

mlesa

cust_name       C      20

quantity           N      3

pro_name        C      20

price                N       6

total                 N      9

ysaxsA tSls dh mij MsVkcsl cuk gSA bls ctrl+w ls lso dj ysA vc blesa fjdkMZ tksM ns flQZ total esa dksbZ ,aVjh u djsaA

vc dekaM foaMks ij fy[ks

Replace all total with price*quantity <enter>

Index on pro_name tag p <enter>

Create report sales <enter>

,d fLdzu vk;sxk ftlesa rhu cSaM feysxk page header, detail, page footer. blesa nks cSaM vkSj tksMsaxs

Report menu esa data grouping esa fDyd djsaxsA

QkDlizks ds vkmViqV vf/kd iBuh; rFkk vkd”kZd cukus ds fy;s QkDlizks esa vR;ar izHkko’kkyh fjiksZV  izLrqrhdj.k lqfo/kk iznku dh xbZ gS ftlds tfj;s MsVk QkbZy dks ,d fu/kkZfjr izk:Ik ds  :i esa izLrqr fd;k tk ldrk gSA bl izk:Ik esa tgka MsVk QkbZy dks vf/kd iBuh; :Ik esa izLrqr fd;k tkrk gSA ogha vf/kdkf/kd lwpukvksa dks izLrqr fd;k tk ldrk gSA fjiksZV fuekZ.k djus ds fy;s dekaM foMksa ij fuEu nhft,&

Use Sales

Syntax:-Create Report file name <press enter>

Ex:-       Create Report Product <press enter>

Report dks Screen ij ns[kus ds fy;s fuEu Command dk iz;ksx fd;k tkrk gSA

Syntax:- Report Form File name <press enter>

Ex:-         Report Form Product <press enter>

               Modi Report Product <press enter>

Report Screen rhu Hkkxksa esa ckaVk tk ldrk gS%&

Page Header

Detail

Page Footer

Page header- bl Hkkx dk iz;ksx Report ‘kh”kZd fy[kus ds fy;s fd;k tkrk gS] ;g ‘kh”kZd Report ds izR;sd Page ij Print gksrk gSA

Detail- bldk iz;ksx Report ds okLrfod fgLls rS;kj djus ds fy;s fd;k tkrk gSA Report ds fy, vko’;d lHkh Field ;k muds vk/kkj ij x.kuk,a blh fgLls esa fu/kkZfjr dh tkrh gSA

Page footer- izR;sd Page ds var esa Footer iznf’kZr djuss ds fy, bldk iz;ksx fd;k tkrk gSA Report dk Preview fn[kkus ds fy;s File Menu ds Preview Option dk iz;ksx fd;k tkrk gSA Report dks Run djkus ds fy;s Report Form File Name Command dk iz;ksx fd;k tkrk gSA

Report esa Page Header, Page Footer, Detail ds vykok nks vkSj Band dks Mkyk tk ldrk gSA

Title Band-  bl Band esa fy[kh x;h Text Report ds igys Page ij Print gksrk gSA

Summary Band-  bl Band esa Mkyk x;k VsdLV vk[kfj fjdkMZ ds rqjar ckn fizaV gksrk gSA

Step:- Report Menu- Title/Summary Band.

DATA GROUPING

     tc [kqyh gqbZ MsVkcsl QkbZy ds fjdkMZ dks xqzi esa ckaVuk gks rks Data Grouping djus dh vko’;drk gksrh gS] Data Grouping djus ds fy, ml fQYM dk baMsDlhx djuk vko’;d gksrk gSA ftUkls xzqihax cukuk pkgrs gSaA tc xzqihax djrs gSa rks Report Designer Window esa nks vkSj Band fn[kkbZ nsrs gSa ;s gS%& 1] Group Header 2] Group Footer. Group dh Heading dks nsus ds fy, Group Header dk iz;ksx djrs gSa rFkk Group ds Footer esa tc Group ls lacaf/kr x.kuk,a dh tkrh gS Data Grouping ds fuEu Step gS%&

Report- Data Grouping- ml QhYM dk uke nhft, ftldk xzi cukuk pkgrs gSaA

In Dell Laptop user ask for how to use function keys.

 In Dell Laptop user ask for how to use function keys.

There is a Fn key next to ctrl key . So press Fn Key with function key .... like we want to use Function key F1 then press Fn+F1 

Voucher Color in Tally

The back color of Payment voucher in Tally is Light Pink .

The back color of Receipt voucher in Tally is Light Violet.

The back color of Contra voucher in Tally is White.

The back color of Sales voucher in Tally is Light Violet.

The back color of Purchase voucher in Tally is Light Pink.

The back color of Journal voucher in Tally is Pink.