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

Search:

Type: Posts; User: JaganEllis

Page 1 of 13 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    7
    Views
    700

    Re: Conditionally inserting lead zeros

    right(replicatestring("0", 10) & totext({table.field}, 0, ""), 10)
  2. Replies
    3
    Views
    3,195

    Re: Crystal installed Nessecerry

    Look at the help on the DateDiff function, specifically the last example.
  3. Replies
    2
    Views
    1,517

    Re: Distinct Sum!

    If you're not expecting the duplicates then maybe your linking is wrong.
    You could also try ticking the Select Distinct Records option in the database menu.
  4. Replies
    2
    Views
    594

    Re: Crystal Reports 10 Selection Record

    Maybe the OR should be an AND
  5. Replies
    5
    Views
    3,390

    Re: Parameter to Hide/show Details?

    Create a boolean parameter, e.g. called Show.
    In the section expert for the detail section, enter a condition in the Suppress formula (click the 'x-2' button alongside the Suppress option). Enter a...
  6. Thread: Pls Help...

    by JaganEllis
    Replies
    2
    Views
    461

    Re: Pls Help...

    Or just choose the group's options (group expert, highlight the shipdate group, press the Options button) and change the 'This section will be printed:' to 'for each month'
  7. Replies
    1
    Views
    750

    Re: Find "Next" date

    Group by event. Record selection by date > currentdate.

    Option 1)
    Sort by date ascending. Print in the group header.

    Option 2)
    Use the group selection formula to get the minimum date per...
  8. Re: Running Total calculations not what expected

    Have you used the parameters in the record selection formula? e.g.
    {table.date} in (?BeginDate) to (?EndDate)
  9. Replies
    5
    Views
    818

    Re: First of next month

    Look in the help at DateSerial.
    DateSerial(Year(d), Month(d) + 1, 1)
  10. Replies
    1
    Views
    614

    Re: Specific time frame

    Look at the help on DateAdd and DateSerial.
  11. Replies
    2
    Views
    620

    Re: Total partial of page

    How are you getting the 'partial total'?
    Are you using a formula, e.g. in the details, to increment the partial total, and another to display the partial total in the page footer? If so, create...
  12. Replies
    3
    Views
    680

    Re: Page Numbers

    Use the 'Reset Page Number After' box in the section expert, e.g. in the client group footer.
  13. Replies
    3
    Views
    834

    Re: Word count in a field

    It looks like Crystal Fire and I have understood your question differently.
    Do you have a field which contains the string "(jan,mar,jan,feb,aug,sep,jan)" and you want to know how many times Jan...
  14. Replies
    6
    Views
    1,013

    Re: Selecting the last record

    When you wrote "I do use groups already" I kind of assumed that you were grouping on the ClientID as that is what we were discussing...
    What groups do you have? You can add groups without affecting...
  15. Replies
    6
    Views
    1,013

    Re: Selecting the last record

    Use this in the details formula then
    if {table.tran_id} = maximum({table.tran_id}, {table.client_id}) then
    ...
    else
    ...
  16. Replies
    1
    Views
    725

    Re: Subreport not showing all data

    What section is the subreport in? How did you do the linking?
  17. Replies
    6
    Views
    1,013

    Re: Selecting the last record

    Or use the group expert. Group by client, group selection formula is then
    {table.tran_id} = maximum({table.tran_id}, {table.client_id})
  18. Replies
    1
    Views
    747

    Re: Summing Running Totals?

    You may just need WhilePrintingRecords in the formula.
  19. Replies
    2
    Views
    698

    Re: Crystal XI Parameter problem

    I guess you should check the type, options etc. of the parameter as I do this in CR XI without problems.
  20. Replies
    3
    Views
    834

    Re: Word count in a field

    You could use Split to get each element into an array and then loop through them.
  21. Re: blocking items dependent on words within a field

    I think you'll need wildcard characters too for Like, i.e.
    "*cement*" etc.

    or look at the InStr() function
  22. Replies
    7
    Views
    1,878

    Re: Recursive Calling Subreports

    Have you looked in the help at Hierarchical reports?
  23. Replies
    2
    Views
    802

    Re: How to multiply records in CR

    What's the maximum quantity?
    If you can create a table in the database then create one with one numeric column and 'n' rows where each row has a quantity number in it. e.g.
    create table...
  24. Replies
    3
    Views
    990

    Re: subreport in crystal report 10

    I'm guessing the obvious question is why do you need so many? 90 subreports per detail record - that's a lot of processing! Wht are you doing?!
  25. Replies
    1
    Views
    656

    Re: Summing Groups

    See the help on the Sum() function. Put something like the following into the group header formula to set the category column:
    local numbervar po_total := Sum({table.invoice_amount},...
Results 1 to 25 of 324
Page 1 of 13 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