mohinder singh
Programmer
HI
I WANT TO STORE EACH PAGE NO. IN MY ACCOUNTING LEDGER REPORT FOR INDEX PAGE
I WANT TO STORE EACH PAGE NO. IN MY ACCOUNTING LEDGER REPORT FOR INDEX PAGE
Last edited:
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Please don't SHOUT in this forum.HI
I WANT TO STORE EACH PAGE NO. IN MY ACCOUNTING LEDGER REPORT
HOW?
HOW TO STORE PAGE NO. WHILE RUNNING REPORT?
function LedgerPageUpdate
select myLedger
set order to LedgerKey
seek (myTempCursor.LedgerKey)
replace myLedger.ReportPage with _pageno
select myTempCursor
return(.t.)
THANKSDo you mean that for each item on the ledger report you want to write back the page number it appears on into the original data?
if so, you are looking to run something like this for each detail in the report - in the run on entry property on the detail band
Code:function LedgerPageUpdate select myLedger set order to LedgerKey seek (myTempCursor.LedgerKey) replace myLedger.ReportPage with _pageno select myTempCursor return(.t.)
RESPECTED SIR,THANKS
I WILL TRY THIS CODE
Again, please don't SHOUT!!! Using UPPER case only is considered SHOUTING!!!RESPECTED SIR,
YOUR CODE NOT WORK
PLEASE TELL ME HOW TO STORE (WANT TO REPLACE IN OTHER DATABASE) LEDGER REPORT'S PAGE NO. (FOR CREATING INDEX PAGE)
WHICH COMMAND/FUNCTION I GIVE IN LEDGER.FRX
THANX IN ADVANCE
what is your problem??Again, please don't SHOUT!!! Using UPPER case only is considered SHOUTING!!!
thanks again sir, i will try thisI can't be more specific with the code, without knowing your data structure etc.
But you trigger the function on entry to each detail line
View attachment 1863
I assume you are not familiar with writing in forums.what is your problem??
are you angry with your family?
cool down man
My ears hurts when people shout...thanks again sir, i will try this
thanks
Well said. I will add one warning.In short: Any field of a report can not only be set to just a table field, but as the Field Properties windows General tab displays: "Expression". That's any expression returning what you want to print. What else the expression does, like updating a table or even changing the background colour of the screen or plaing a song, is up to you, you have all the freedom of doing what you want there, as long as you eventually return what get's printed. You don't even need to print anything, as the expression could return an empty string. So report fields are a door to anything you want to do at all, there's no need for anything fancy like the "Run expression on entry" of a report band.