Search Results - VBForums

Search:

Type: Posts; User: jggtz

Page 1 of 13 1 2 3 4

Search: Search took 0.05 seconds.

  1. Re: Need some tips for sorting rows in 2D array based on specified column.

    You could use a tricky way
    Load the data in a hidden ListView an use its sorted property
    Then iterate thru its rows to get the sorted data
  2. Replies
    1
    Views
    673

    Re: Crystal Report 8 Error

    Did You create the DSN in Win7 machine ?
    Did the Win7 machine has access to the data?
  3. Replies
    11
    Views
    5,179

    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...
  4. Replies
    11
    Views
    5,179

    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...
  5. Replies
    11
    Views
    5,179

    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
  6. Replies
    5
    Views
    423

    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, "?", "")
  7. Replies
    6
    Views
    492

    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
  8. Replies
    5
    Views
    515

    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...
  9. Re: Crystal Reports Viewer Studio 2010 settings

    IMHO, Yours is better until now
  10. 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
  11. Re: Crystal Reports Viewer Studio 2010 settings

    CRV1.DisplayGroupTree = False
  12. Replies
    2
    Views
    791

    Re: Crystal Report issue

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

    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...
  14. Replies
    7
    Views
    908

    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
  15. 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
  16. 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
    ...
  17. Replies
    8
    Views
    1,022

    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...
  18. Replies
    8
    Views
    1,022

    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
  19. Replies
    8
    Views
    1,022

    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
  20. Replies
    8
    Views
    1,022

    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...
  21. 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)
  22. Replies
    8
    Views
    385

    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
  23. Re: Run-Time Error '3021' No Current Record Found

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

    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...
  25. 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()
  26. 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...
  27. 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...
  28. Re: Connecting VB6 with external Crystal report and database with password

    Please, say the Crystal Reports' version
  29. Replies
    4
    Views
    594

    Re: OPOS Clearoutput problem

    The next is the code I use without problems


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

    Re: Insert images in crystal reports 7

    The easiest way is to save those images in a db table and then retrieve them
  31. 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
  32. 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
  33. Replies
    5
    Views
    586

    Re: Access Database Corruptions

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

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

    You need to provide the connection information in the code using the ConnectionInfo property
  36. 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...
  37. Re: MSXML2.DOMDocument indent xml with spaces instead of tabs

    Then post the code where you are indenting the nodes
  38. Replies
    3
    Views
    15,220

    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...
  39. 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
  40. Thread: Receipt

    by jggtz
    Replies
    3
    Views
    1,105

    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...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.