Search results for query: *

lbass Thank you and it worked bye for now kalps

To rhinok (TechnicalUser) I had used two variables for the following reason: op variable is to total for each state grandop variable is grandtotal for all the states. Even then i used your formulas it worked for each state and not for grand total kindly guide me bye for now Kalps

Dear Sir I have a report to be created with grouping statewise. I get the data grouped statewise.but when I have to total the data for all states i.e. grand totol of the field subscription the running totals formula totals for all the states except for the last one. The formula which I use in...

SMerrill (Programmer dear friend i have not received your reply i am stuck up with the page total can you help me bye and regards

i have a report created in datareport 6.0 of vb 6.0 it runs to six pages. i would like to have a page total for each page i also need another help i am unable to get the date and month of report printed on report header of the report. i do not want to print the current date on the report. i...

page total for data report i want page total in a data report i am using access 97 and visual basic 6. i also request you to suggest way to print out month and year at the top of the report. the month and year cannot be current date thank you in advance

johnwm thank you for your help but it doesnot work you have given the following solution dr1.Section(1).Controls.Item("lblDate").Caption = "Any String You Want" i created a rptlbl as name = lbldate and left the caption col blank is the properties window. after that i...

msg for johnwm thank you for your help 1.i got the current date can you help me out further if i generate the report for december on a future date can i get the date on the report as december instead of the current date. is there any option for the same 2. regarding page total the insert...

i am very sorry this was said to be posted to crystal report formulas by mistake it was sent to this forum sorry once again please ignore this thread

running totals - grand total How to get grand total after creating a running total formula? i have created a running total formula with a field called subscpriton. this field is grouped statewise and gives the data correctly for each state. but i am held up with a small problem i want a grand...

running totals - grand total How to get grand total after creating a running total formula? i have created a running total formula with a field called subscpriton. this field is grouped statewise and gives the data correctly for each state. but i am held up with a small problem i want a grand...

%p will give the page no. i want a total of the data at the end of each page and also month and year at the beginning of the report thank you in advance

page total in data report 1.i would like to have page total in a report of 6 pages i am using vb 6 enterprise edition and data report of vb 6. 2. i would like to have even the month of generation of report printed on top of the report on the first page. for both i use only vb 6 and data...

cumulative total from one date to another I have a field called subscription. I want to total that field from a date say 31.03.2002 till yesterday i.e. 28.12.2002. I am getting this value incluidng today i.e 31.03.2002 till 29.12.2002 I used this formula IF MAXIMUM ({PPFTXN.VOUCHDT}) in...

dear liability is a field in master table which consists figure for various branches like for 109 (branch code) - 99000.99 for 289(branch code) 87666.00 subscription is a field in txn table which consists of figures for various branches for various dates. liek for 109 for 2.4.2002 - 86000 for...

DEAR I TRIED THE RUNNING TOTALS BUT WHAT HAPPENS IS IT ADDS FIGURE EVEN FOR THE DAY. ACTUALLY I WANT THE TOTALLIAB UPTO THE PREVIOUS DATE (IST COL) ONLY HERE IT ADDS EVEN FOR THAT DATE NEXT COL. SUBSCRIPTION TOTAL FOR THE DAY. NEXT COL IS TOTALLIAB+SUBSCRIPTION I HAVE A DATE EVAULATION FORMULA...

cumulative figure for a particular field I am creating a report with a cumulative figure i.e. there is a field called totalliab in the master table. This field has to be totalled with subscription, interest and repayment of txn table(another table) the opening balance should be the...

DEar Sir I have a txn table I have three fields subscription, loanint, penalint As per MSaccess all the above fields are not required. When create a crystal report to verify the fields all these fields show the view in the preview form. But when a selection formula is used for a particular date...

two tables to be used in a single report i have a table called citymaster with citycode and city name as fields i have another called statemaster with statecode and state name as fields i have a transaction file which is including all the transaction like receipts and payments. i want a report...

to dgk even if i alter the other fields (not the primary key) it gives the sameerror kindly help me