Search Results - CodeGuru Forums
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com

Search:

Type: Posts; User: jggtz

Page 1 of 44 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    1
    Views
    401

    Re: Division by Zero error

    If Sum ({@Invoice},{aps_group.code})) <> 0 Then
    (Sum ({@Payments},{aps_group.code})/Sum ({@Invoice},{aps_group.code}))*100
    Else
    0
  2. Replies
    8
    Views
    9,171

    Re: Database Login Crystal Reports

    If you study the code, it's exactly the same (coded in different way) but yours is 4 years later
  3. Replies
    15
    Views
    1,349

    Re: Error in Count of records

    Add the next red code to yours
    and remove blue code


    If rsemployee.RecordCount > 0 = True Then
    txtstat.Text = rsemployee.Fields!sta -------------------------> here Error
    ...
  4. Re: Need help converting a string field to date in crystal report

    You could use a formula field and write code that:
    0 Declare variables
    1 Extract the month day & year part of the string, using the MID function
    2 Convert to numeric value each one using the...
  5. Re: In Crystal Reports, can you create a formula field dynamically

    Do you want to insert a new formula field in an existing rpt from an application that you are developing?

    AFAIK, We only can modify an existing formula field at running time from an application
    ...
  6. Thread: Barcode Printing

    by jggtz
    Replies
    1
    Views
    304

    Re: Barcode Printing

    You could use a formula field, as:


    WhilePrintingRecords;
    If {tablex.QtyField} = 4 Then
    {tablex.CodeNumber} + Chr(10) +
    {tablex.CodeNumber} + Chr(10) +
    {tablex.CodeNumber} +...
  7. Replies
    4
    Views
    505

    Re: Help with code compile error message.

    What?

    Single means Single Precision and has decimals

    The problem here is that @AndrewDz is declaring Dale and Theo but he is using Dale1 and Theo1 in the MsgBox
  8. Re: Suppressing a text field based on date range

    However the answer is: if {data field} <= #7/1/11# then True
  9. Replies
    1
    Views
    318

    Re: Novice Crystal User and dates

    Calculating the number of calendar days between two dates is fairly simple. However, if you need to calculate the number of work days, it gets a bit more difficult. Not only do you have to account...
  10. Re: please help with selection criteria Crystal 8.5

    If the list is large then you could create a new table with all the desired records and define the fields as a key (person, seq & code).
    Then add that table to your report and link your data table...
  11. Re: Visual Basic - Calculations across multiple forms

    It would be better to move the thread to vb.net
  12. Replies
    4
    Views
    664

    Re: how to break repeating random

    Use the RANDOMIZE function just before the RND line
    See some examples here ---> http://www.developerfusion.com/code/259/generating-random-numbers/
  13. Re: Error Message: A Loop was evaluated more than the maximum....

    Search for Option Loop statement
    The default are 100,000 iterations

    Also, check your loop logic
  14. Replies
    9
    Views
    1,563

    Re: Crystal Report XI R2 Problem

    I don't see how you are passing the selected recordset to the report... post the code...
  15. Re: Print two labels the same on a four across sheet. Crystal Reports XI ver.11.0.0.1

    Sorry, I was asumming that you were using a programming language
  16. Re: Print two labels the same on a four across sheet. Crystal Reports XI ver.11.0.0.1

    One way could be to use a temporal table and resolve the problem using code
    Then just use Crystal to print the results
  17. Replies
    8
    Views
    2,340

    Re: Please Help Vb6 program dealing with Time

    Also, a more important thing...
    DO NOT use ADO Data Control
  18. Replies
    8
    Views
    2,340

    Re: Please Help Vb6 program dealing with Time

    Try moving the
    Adodc3.Recordset.Update
    just before
    Adodc3.Recordset.MoveNext

    The Update will be in a record by record basis
  19. Replies
    8
    Views
    2,340

    Re: Please Help Vb6 program dealing with Time

    Study ADO and SQL
    You need to learn about how to open and close recordsets,
    how to read, modify and delete records, etc.
    But if you post the code where you have problems then somebody else could...
  20. Re: Crystal Reports Inconsistencies in Selection Expert

    Could you let the selection expert aside?
    ...and just copy or redo the selection formula manually
  21. Re: Packaging and deploying a vb 6.0 application liked to database

    1 Change the ConnectionString property of the ADO DataControl in form load event giving the new db location

    Or

    2 Install your app and db in the same folder that in your development pc...
  22. Replies
    3
    Views
    1,624

    Re: Report selection formula

    OK
    Now is time to mark the thread as Resolved and rate the post (litlle star at the left of the post)
  23. Replies
    3
    Views
    945

    Re: help me with this simple VB code

    Post the code where you have problems
  24. Re: Packaging and deploying a vb 6.0 application liked to database

    When using PDW you can add all the external files your project need but you need to do it manually
    But problably your problem is inside your app, that it is looking for the database in another path...
  25. Replies
    3
    Views
    1,624

    Re: Report selection formula

    Use square brackets instead to enclose data and apostrophe to enclose the formula, as in


    crDoc.RecordSelectionFormula="{tblEmployees.EmployeeID} IN [14,11,8,2,5,13,10112,10127,10129,11685]"
Results 1 to 25 of 1083
Page 1 of 44 1 2 3 4


Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center