Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: kalpsv
  • Content: Threads
  • Order by date
  1. kalpsv

    Dear Sir I have a report to be cre

    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...
  2. kalpsv

    page total for data report i w

    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
  3. kalpsv

    running totals - grand total How t

    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...
  4. kalpsv

    running totals - grand total How t

    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...
  5. kalpsv

    page total in data report 1.

    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...
  6. kalpsv

    cumulative total from one date to a

    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...
  7. kalpsv

    cumulative figure for a particular

    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...
  8. kalpsv

    DEar Sir I have a txn table I hav

    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...
  9. kalpsv

    two tables to be used in a single r

    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...
  10. kalpsv

    how to modify data? I have

    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...
  11. kalpsv

    error in database dll error no 2053

    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
  12. kalpsv

    error in database dll i am wor

    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...
  13. kalpsv

    error 20534 - database dll dear

    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...
  14. kalpsv

    dear sir/madam i have created vari

    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
  15. kalpsv

    dear sir I have created 11 to 12 r

    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
  16. kalpsv

    I am new to Access. I have a doubt.

    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
  17. kalpsv

    To dgillz I have to create a rep

    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...
  18. kalpsv

    fetch component

    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.
  19. kalpsv

    subreport

    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
  20. kalpsv

    data for previous months

    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} >=...

Part and Inventory Search

Back
Top