Joins in Crystal Reports
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4

Thread: Joins in Crystal Reports

  1. #1
    Join Date
    Apr 2007
    Posts
    2

    Joins in Crystal Reports

    Hi,
    I'm newbie in Crystal report. I've a query which i'm unable to implement in CR. Eventhough the query looks simple because of the join condition I'm struggling . Pls help me to implement the join condition. I run the query in DB2

    select sum(bank_ledger_bal_amt),calendar_date
    from table_a a
    inner join table_date b
    on a.bank_acct_eff_dt <= b.calendar_date
    and a.bank_acct_disc_dt > b.calendar_date
    where month_id = 'feb'
    group by b.calendar_date
    order by b.calendar_date
    ;

    Thanks,
    Jash

  2. #2
    Join Date
    Sep 2005
    Location
    Colorado, USA
    Posts
    86

    Re: Joins in Crystal Reports

    Use the add command of Crystal and paste in your SQL query in there.
    GJ

  3. #3
    Join Date
    Apr 2007
    Posts
    2

    Unhappy Re: Joins in Crystal Reports

    Sorry I didnt get what do you mean

  4. #4
    Join Date
    Sep 2005
    Location
    Colorado, USA
    Posts
    86

    Re: Joins in Crystal Reports

    In the Database Expert there is an option to select "Add Command" there you can type out your sql. Crystal will let you know if there is an error in your SQL.
    GJ

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center