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

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

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

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

    Re: Any body ever answers in this forum??

    Sometimes I reply to questions
  5. 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
  6. 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...
  7. Replies
    2
    Views
    703

    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...
  8. Replies
    2
    Views
    1,386

    Re: Help to design MySQL database structure

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

    Re: Group by question

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

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

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

    by Ned Pepper
    Replies
    1
    Views
    338

    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...
  13. 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...
  14. Replies
    1
    Views
    409

    Re: using if condition in report on parama

    try something like



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

    try placing the following on the first line of your formula



    not onfirstrecord;
  16. 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...
  17. Replies
    2
    Views
    860

    Re: Set Color to header of a Crosstab

    A Cross Tab is fancy grouping so try

    if groupnumber =
  18. Replies
    1
    Views
    1,710

    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+...
  19. 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...
  20. Re: How to Dynamically set sub-report data source from Parent report?

    Don't think you can change the db connection of a sub-report dynamically.
    What you can do is have multiple sub-reports placed in various sections of a main report.
    Then use suppression formula to...
  21. Replies
    1
    Views
    984

    Re: Give SQL Query for this question?

    create table test (
    id int,
    data float)
    insert into test values (1, 27718)
    insert into test values (2, 27741)
    insert into test values (3, 27661)
    insert into test values (4, 27626)
    insert into...
  22. Re: Inconsitent Data for Time Frames

    Can't tell for sure without knowing more about the structure of the report, but it looks like you are possibly getting grouped results -
    your row for Brandon 0 1 11
    is returning 12 12 12 (0 + 1...
  23. Replies
    1
    Views
    1,124

    Re: Connecting Crystal to Excel in infoview?

    Your suspicion that "I am guessing the location of the excel file should be in the repository or
    the ODBC connection should be made in the server. " is correct. When you run the report in...
  24. Replies
    2
    Views
    1,747

    Re: Alignment issue when drawing table

    Might try using a cross tab
    http://flylib.com/books/en/2.825.1.98/1/
    http://www.crystalkeen.com/articles/crystalbasics/CrossTabAnalysis.htm
  25. Replies
    1
    Views
    976

    Re: Problems when suppressing the Header

    You just need to re-organize a bit and put in some formula to control the display

    You'll need three formulas - I like shared variables over global since you may at somepoint need to share values...
Results 1 to 25 of 142
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