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

Search: Search took 0.01 seconds.

  1. 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...
  2. 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...
  3. 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...
  4. Replies
    2
    Views
    388

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

    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...
  7. Replies
    1
    Views
    212

    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.
  8. Replies
    2
    Views
    320

    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...
  9. Replies
    1
    Views
    448

    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....
  10. Replies
    1
    Views
    416

    Re: Any body ever answers in this forum??

    Sometimes I reply to questions
  11. 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
  12. 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...
  13. Replies
    2
    Views
    719

    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...
  14. Replies
    2
    Views
    1,450

    Re: Help to design MySQL database structure

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

    Re: Group by question

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

    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...
  17. Replies
    1
    Views
    693

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

    by Ned Pepper
    Replies
    1
    Views
    342

    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...
  19. Replies
    1
    Views
    382

    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...
  20. Replies
    1
    Views
    414

    Re: using if condition in report on parama

    try something like



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

    try placing the following on the first line of your formula



    not onfirstrecord;
  22. 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}
    AND...
  23. Replies
    2
    Views
    867

    Re: Set Color to header of a Crosstab

    A Cross Tab is fancy grouping so try

    if groupnumber =
  24. Replies
    1
    Views
    1,786

    Alter Database Takes a Long Time

    Database is Oracle 10g, about 11TB.
    Searched google and oracle docs but don't see any info on execution time.
    Issued alter database statement to add supplemental logging. Statement ran for 20+...
  25. Re: Can I retieve shared variable data from a sub report?

    I think the key is in placement of the subreport and the formulas.
    Subreports and shared variables are evaluated only WhilePrintingRecords. To get data back from a subreport you have to place the...
Results 1 to 25 of 148
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.


Featured


HTML5 Development Center