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


Type: Posts; User: Ned Pepper

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. Replies

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

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

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

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

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

    Re: Any body ever answers in this forum??

    Sometimes I reply to questions
  13. 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
  14. 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...
  15. Replies

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

    Re: Help to design MySQL database structure

    Dr. Codd would turn over in his grave if you choose #2.
  17. Replies

    Re: Group by question

    you will need a sub report that accepts as a parameter the ID of the longest call.
  18. Replies

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

    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...
  20. Thread: Multisource

    by Ned Pepper

    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...
  21. Replies

    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...
  22. Replies

    Re: using if condition in report on parama

    try something like

    select {?MyParam}
  23. Re: Reporting on first row of data on table

    try placing the following on the first line of your formula

    not onfirstrecord;
  24. Re: How to take 3 parameters at the same time.

    I may be over simple but you need to create 2 date parameters, and just like you did with customer id you add to your criteria

    {tblInvoice.invCustId} = {?CustomerId}
  25. Replies

    Re: Set Color to header of a Crosstab

    A Cross Tab is fancy grouping so try

    if groupnumber =
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4

Windows Mobile Development Center

Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


HTML5 Development Center