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.02 seconds.

  1. Replies
    1
    Views
    374

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

    Re: Any body ever answers in this forum??

    Sometimes I reply to questions
  3. 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
  4. 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...
  5. Replies
    2
    Views
    675

    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...
  6. Replies
    2
    Views
    1,167

    Re: Help to design MySQL database structure

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

    Re: Group by question

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

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

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

    by Ned Pepper
    Replies
    1
    Views
    332

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

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

    Re: using if condition in report on parama

    try something like



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

    try placing the following on the first line of your formula



    not onfirstrecord;
  14. 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...
  15. Replies
    2
    Views
    840

    Re: Set Color to header of a Crosstab

    A Cross Tab is fancy grouping so try

    if groupnumber =
  16. Replies
    1
    Views
    1,622

    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+...
  17. 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...
  18. 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...
  19. Replies
    1
    Views
    970

    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...
  20. 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...
  21. Replies
    1
    Views
    1,093

    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...
  22. Replies
    2
    Views
    1,668

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

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

    Re: How to format with this conditions?

    Make a formula that sums the other formulas
    @SUMSUM is
    formula = {@formula1} + {@formula2} + {@formula3} + {@formula4} + {@formula5}


    then format section color formula is

    select case...
  25. Replies
    1
    Views
    737

    Re: Record selection issue

    the record selection formula is a boolean formula and must return true or false. When true, records are selected to the report, when false, records are filtered out(skipped). Without knowing your...
Results 1 to 25 of 140
Page 1 of 6 1 2 3 4


Azure Activities Information Page

Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center