Search Results - VBForums

Search:

Type: Posts; User: jggtz

Page 1 of 13 1 2 3 4

Search: Search took 0.05 seconds.

  1. Replies
    11
    Views
    4,333

    Re: Export Crystal Report to PDF Programatically

    I remember I had the same problems several years ago (almost 12) and the solution I posted was the easiest and fastest
    If your code is organized in procedures, you need to change only a few lines...
  2. Replies
    11
    Views
    4,333

    Re: Export Crystal Report to PDF Programatically

    Ok

    Your project is using Crystal Reports version 8.5 or lower and using the OCX control

    In order to solve your problem to automatically export to pdf, you should upgrade to Crystal Reports...
  3. Replies
    11
    Views
    4,333

    Re: Export Crystal Report to PDF Programatically

    Ok
    That's the code where you select the report
    Now post the code that's in the "insreports" procedure
  4. Replies
    5
    Views
    251

    Re: Removing unwanted characters from a string

    You could use the REPLACE function



    Dim MyStr As String
    Dim MyNewStr As String

    MyStr = "abcd?fghijkl?nopqr?tuvwxy?"
    MyNewStr = Replace(MyStr, "?", "")
  5. Replies
    6
    Views
    335

    Re: What does ListView really do?

    ...and more features...
    -4 types of view
    -CheckBoxes
    -FullRowSelect
    -GridLines
    -HotTracking
    -HoverSelection
    -and more
    Just see the ListView's Properties Page
  6. Replies
    5
    Views
    365

    Re: Email attachments from form field with VB

    Here's a working piece of code that send mail with attachments using Outlook


    Dim oApp As Outlook.Application
    Dim oEmail As Outlook.MailItem

    Dim MMail As...
  7. Re: Crystal Reports Viewer Studio 2010 settings

    IMHO, Yours is better until now
  8. Re: Crystal Reports Viewer Studio 2010 settings

    That's why is important to say versions


    To Turn off:
    CrystalReportViewer.ToolPanelView = ToolPanelViewType.None

    To Turn on:
    CrystalReportViewer.ToolPanelView = ToolPanelViewType.GroupTree
  9. Re: Crystal Reports Viewer Studio 2010 settings

    CRV1.DisplayGroupTree = False
  10. Replies
    2
    Views
    517

    Re: Crystal Report issue

    Check if the path of your data and/or development is not in a windows protected path
  11. Replies
    2
    Views
    416

    Re: Undisplaying Minimum Date

    Subreport

    You could find the minimun date in main report (in this main report suppress printing)
    Link that value to a subreport using recordselectionformula

    You could do it reverse mode
    Find...
  12. Replies
    7
    Views
    623

    Re: Crystal Reports and Exporting to Excel

    It could be anything about office/excel libraries
    But IMHO those are bugs resolved in newer version of Crystal Reports
  13. Re: Reportviewer Adding up a column of values generated when report runs

    You could add a formula field in your report and do the calculations there
  14. Re: VB - Change color of font in ListView Row when highlighted

    I do it next way to change forecolor of listview cells


    'Declare
    Dim LI As MSComctlLib.ListItem
    Dim LIS As MSComctlLib.ListSubItem

    'Add to ListView1 -1 row -2 columns -forecolor blue
    ...
  15. Replies
    8
    Views
    832

    Re: Crystal Report Datasource

    Did you try post #6?
    Because my english level is not as good as I want, I can't explain exactly what Windows 7 & 8 do about certain paths and keep old versions of files generating this kind of...
  16. Replies
    8
    Views
    832

    Re: Crystal Report Datasource

    I would run the tests in a folder created by me... for example: C:\MyFolder
    In this folder store the rpt files and call them from there
    It sounds that you are using some kind of protected folder
  17. Replies
    8
    Views
    832

    Re: Crystal Report Datasource

    Probably you are using a font that is not supported by pdf and that's the reason that it change to a supported one
  18. Replies
    8
    Views
    832

    Re: Crystal Report Datasource

    Are you calling the reports from an application?
    Because we can change the datasource using code
    If this is your case then say language & version used and also Crystal Reports version
    With this...
  19. Re: How i load picture from path in Crystal reports ?

    Study the attached VB6 project
    it shows one way to solve your problem
    (the rpt uses the Extreme.mdb file, probably you need to change to other if you don't have it)
  20. Replies
    8
    Views
    326

    Re: Urgent Help (easy but i am a newbie)

    The OP clearly posted

    Believe it or not, but in many places around the world they are still teaching VB6 and DAO in XP boxes
  21. Re: Run-Time Error '3021' No Current Record Found

    When using DAO .RecordCount will give you the result only after a .MoveLast method
  22. Replies
    8
    Views
    326

    Re: Urgent Help (easy but i am a newbie)

    You should investigate about:
    -How to Declare Numeric variables in VB6
    -How to accept data from the user in VB6
    -How to use arrays in VB6
    -How to calculate percentages and averages in VB6

    Then...
  23. Re: Run-Time Error '3021' No Current Record Found

    It looks like you are using DAO
    Then:
    1 Reference the DAO library
    2 Change the lines where you declare and where you open Recordset



    Option Explicit

    Public Sub modDeterminePrice()
  24. Re: Connecting VB6 with external Crystal report and database with password

    Well
    CR10 is better than CR8.5
    In design time is almost the same thing
    In CR10 You can open rpt files designed by CR8.5 and save them in version 10 or in version 8.5
    (...but once in version 10...
  25. Re: Connecting VB6 with external Crystal report and database with password

    Sorry pal, Crystal Reports 8.5 does not has the "ConnectionProperty" property that I used for provide the password to mdb at running time
    Try to get Crystal Reports Version 9 or 10 or 11
    Those are...
  26. Re: Connecting VB6 with external Crystal report and database with password

    Please, say the Crystal Reports' version
  27. Replies
    4
    Views
    353

    Re: OPOS Clearoutput problem

    The next is the code I use without problems


    'Print Ticket
    OPOSPrinter1.Open "TRSTA1U"
    OPOSPrinter1.CharacterSet = PtrCsAscii
    OPOSPrinter1.ClaimDevice 0
    ...
  28. Replies
    1
    Views
    479

    Re: Insert images in crystal reports 7

    The easiest way is to save those images in a db table and then retrieve them
  29. Re: problem in installing crystal report for visual studio 2008

    You downloaded the Service Pack, it means that it's expecting that you already had installed the CR2008
  30. Re: Put the subtotal at the end of records and not at the footer of last page

    Then place your total in the Report Footer section instead of Page Footer section
  31. Replies
    5
    Views
    507

    Re: Access Database Corruptions

    http://www.blueclaw-db.com/table_corrupted/repair_corrupted_database.htm
  32. Re: Crystal Report loading error Logon Failed.

    I mean pass the connection information to Crystal Reports to laod the rpt
  33. Re: Crystal Report loading error Logon Failed.

    You need to provide the connection information in the code using the ConnectionInfo property
  34. Re: Need your help calling a web service for school payments

    I use SOAP Toolkit 3.0 in all my projects that consume web-services

    Still available here ---> http://www.microsoft.com/en-us/download/details.aspx?id=10747

    Developing in XP, the projects work...
  35. Re: MSXML2.DOMDocument indent xml with spaces instead of tabs

    Then post the code where you are indenting the nodes
  36. Replies
    3
    Views
    10,341

    Re: Load Report Failed - Crystal Reports

    Maybe parts of the next code & comments could help...
    VB.NET and CRYSTAL REPORTS
    HOW TO CALL A RPT WITH SUBREPORTS AND PARAMETERS
    -------------------------------------------------
    The following...
  37. Re: Database: Multiple Copy of Records and Paste to Another Database

    And what about a small conversion procedure?
    Open both mdb
    Read the old mdb
    Make the data conversion (change/add data)
    Write to new mdb
  38. Thread: Receipt

    by jggtz
    Replies
    3
    Views
    886

    Re: Receipt

    Some printers only accept their own api
    Others accept any reporting tool (Data Report, Crystal Reports, etc.)

    So, the best way is to select a brand that is compatible with your Windows version...
  39. Replies
    13
    Views
    1,166

    Re: Access password - VB6

    You should convert to a newer version first
    Create a new mdb file (version 2003 for example)
    Open it and import your tables from the older one
    Now you can set a password using Access
  40. Replies
    8
    Views
    403

    Re: where clause error

    The closing "

    Set rs = CN.Execute("SELECT * from Expenses WHERE ExpRemarks ='ABC'")
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width