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

Search:

Type: Posts; User: Ned Pepper

Page 1 of 7 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    3
    Views
    739

    Re: Crystal Report Division by zero error

    Hello,
    The values you are seeing are not related to the testing for a null and/or zero divisor. That test simply allows the division to take place. You will need to examine your data, and your...
  2. Replies
    3
    Views
    739

    Re: Crystal Report Division by zero error

    Hello,
    I suggest your testing on the divisors does not cover all possible values. In your first example you test for a null divisor, but not a zero value divisor. In the next 2 examples you test...
  3. Re: Display barcode as image within Crystal Report

    If possible, i suggest you do not store images of barcodes as images take up a lot of space and bandwidth. Instead, use the free Code 3 of 9 barcode font, and simply store the data you wish to...
  4. Re: Need Crystal Reports help - exception reporting

    Depending on the number of records in your table, Crystal may not be the best tool to use for this application. Under normal conditions, Crystal reads records in a continuous block, allowing you to...
  5. Re: New page after subreport finish printing

    It depends on where in your report you have placed the sub-reports. Assuming you placed the sub-reports in the details section, right click on details section in the gray area to the left of the...
  6. Re: Sort Group According to selection of group in crystal reports

    Not sure what your desired output is. The Group Sort Order formula will change the order of the data in the group, it will NOT change which data is selected to be grouped. In general, you need to...
  7. Re: Details Section format, paylip-like report. landscape division

    Try using the Format with Mutlipe Columns option. Access the section expert for the details sections (multiple columns are not available on headers and footers). Once you check the multiple columns...
  8. Replies
    2
    Views
    530

    Re: MySQL beginner's questions

    If you wish to "insert" a value into one field of a row that is already in your table, this would be an UPDATE not an INSERT. INSERT adds an entire new row to a table. I strongly recommend you take...
  9. Re: Help in validating input parameter before query execution.

    In most cases, Crystal must execute a query in order to do anything else, but you do have some control over when the query is executed (see Evaluation Time Functions in the Help). You can try using...
  10. Replies
    2
    Views
    623

    Re: formula error

    Maybe this will point you in the right direction. "if other items ordered by a customer do not have a discount, the "net extended" field is blank". This indicates your issue has to do with NULL...
  11. Replies
    1
    Views
    309

    Re: Value does not exceed

    You are not providing enough information to work with. In general you can create a formula that provides a distinct count using the build in summary function DistinctCount.
  12. Replies
    2
    Views
    417

    Re: TEXTS in Crystal Report Formula

    You have 2 problems with this formula.
    1. Remove all the "AND" from you nested IF statement. Should be if-then-else-if , not if-then-AND-else-if
    2. Your final else returns a number while all the...
  13. Replies
    1
    Views
    518

    Re: whileprinting

    There are a few limits to CR, one is evaluation time. Not trying to overstate the obvious but you can't read a record before you read the record. Sometimes you can use multiple sub-reports, i.e....
  14. Replies
    1
    Views
    665

    Re: Any body ever answers in this forum??

    Sometimes I reply to questions
  15. Re: Report print many pages as the line details

    Check the Section Expert (format section) to see if New Page Before or New Page After is selected in any section of main or sub-report
  16. Re: Group Selection Formula, Filtering Records: Crystal Reports 8.5

    The answer is in the "The Formula Must be Evaluated Later" message. Your group is based on the Currhold.CUSIP field. You cannot use aggregations based on this field to filter the group becuase you...
  17. Replies
    2
    Views
    782

    Re: Creating an initial unbound report

    I have experienced a similar issue, and I just use text files as the data source. You can create a text file (CSV) with column heading fieldA, fieldB, etc, and have data in the columns similiar to...
  18. Replies
    2
    Views
    1,738

    Re: Help to design MySQL database structure

    Dr. Codd would turn over in his grave if you choose #2.
  19. Replies
    1
    Views
    361

    Re: Group by question

    you will need a sub report that accepts as a parameter the ID of the longest call.
  20. Replies
    1
    Views
    463

    Re: Crystal Report problem

    I think the best answer is to insert additional page and report footers sections into your report. You can then have the entire sections suppressed based on your parameter. Keep in mind that the...
  21. Replies
    1
    Views
    755

    Re: Font problem

    You did not mention the version of Crystal Reports you are using.

    This may not be a Crystal Reports issue. In general, The use of fonts is controlled by the printer driver of the printer you...
  22. Thread: Multisource

    by Ned Pepper
    Replies
    1
    Views
    356

    Re: Multisource

    You can use different datasources on your report. For example you can mix data from oracle and sql server on one report. When you do this you have to manage the database linking yourself, since the...
  23. Replies
    1
    Views
    393

    Re: Changing Database

    Without knowing the other application but did you try having the user point their ODBC connection to a different data source location. The catch is the tables and fields in the report must exist and...
  24. Replies
    1
    Views
    438

    Re: using if condition in report on parama

    try something like



    select {?MyParam}
    case "R" : {TABLE.RESIDENTIAL_ADDRESS}
    case "C" : {TABLE.COMPANY_ADDRESS}
  25. Re: Reporting on first row of data on table

    try placing the following on the first line of your formula



    not onfirstrecord;
Results 1 to 25 of 152
Page 1 of 7 1 2 3 4


Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a Codeguru.com survey!


HTML5 Development Center