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...
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
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...
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...
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...
how to modify data?
I have started a project in vb6 and access as the database.
when I go for modifying it displays an error message that the updation will create duplicate index or key. My primary key is branch_code_no, txn_dt and sl_no.
I am using the following code in slno private sub...
error in database dll error no 20534
i am using crystal reports 4.5 when i run the reports through vb 6 i get the error no 20534 - error in database dll i am unable to identify the database dll which is missing / corrupt.
can you help me sir
thanks in advance
error in database dll
i am working with crystal reports 4.5 my database is access when i try to access crystal reports through vb at runtime i get the error "error no 20534 - error in database dll."
i am unable to know the name of the dll file which would have been corrupted. Can...
error 20534 - database dll
dear sir
i am using crystal 4.6 to create reports. WHen I run from vb i get the error message
"error no 20534- error in database dll"
when I click help it goes to crystal
and gives the message
"cannot find help (129)"
due to this my project...
dear sir/madam
i have created various reports in crystal 4.5 version
when i run it in vb6 it gives the error message
error 20534 - error detected in database dll
this error pertains to the database dll which i am unable to find out.
i am using ms access for my database.
thanks in advance
dear sir
I have created 11 to 12 reports in crystal - version 4.5
when i run some in vb6 it gives an error 20534 - error detected in database dll.
this error pertains to some dll file and i am unable to find the particular dll file
i am an access database.
kindly help me
and thanks in advance
I am new to Access. I have a doubt.
Can there be multiusers to the same database?
Can there be multiaccess by multiusers to the same
table?
I intend having the db in a single PC and have network
connection.
Can simultanoues updates be allowed?
thanks in advance
To dgillz
I have to create a report with two columns
one column is for amount for the month
one column is from the date the of computeristiaon
to the end of previous month
both accesses the same table and retrieves
data from the same field i.e. {subscription}
when i tried 31.3.2001 to...
When I open crystal reports design view of certain
.rpt files I GET message
"COULD NOT FETCH COMPONENT"
tHIS does not allow me to view my formulas etc.
what i am able to view
page
title
and then a line at col 15 ro 20.
thanks in advance.
hi,
i am using cr of VB5. i think it is version 4.
is there any free download for 5 or 6.
please also let me know whtat is sub report.
many use current date i think version 4 does not support
current date.
bye
I have to create a report in which one col is to sum
the total from Ist april to previous month (i.e. the month
before the current month)
this is my formula
//Current Year's April to End of Last Month
if month({PPFTXN.VOUCHDT}-1) in [5,7,10,12] then
if {PPFTXN.VOUCHDT} >=...
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.