Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2015
    Location
    Canada
    Posts
    2

    Unanswered: Crystal Reports 2008 combining Command and db together

    Hi,

    I'm new at Crystal Reports and I need to make a report where I need to combine Command and direct db together.
    Can you please tell me how can I do that in SQL query? With INNER JOIN or?
    How can I integrate mCallEnd and mOpInterval in the SQL query in Command so I can have all fields and formulas from all 3 tables in Command?

    Thank you in advanceClick image for larger version. 

Name:	problem11.JPG 
Views:	2 
Size:	23.9 KB 
ID:	16070

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Joining is correct. Whether that's an INNER or OUTER join depends on your requirements.

    If you post the query text for your command along with how the mCallEnd and mOpInterval relate, we can help you write the necessary query.
    George
    Home | Blog

  3. #3
    Join Date
    Jan 2015
    Location
    Canada
    Posts
    2
    Quote Originally Posted by gvee View Post
    Joining is correct. Whether that's an INNER or OUTER join depends on your requirements.

    If you post the query text for your command along with how the mCallEnd and mOpInterval relate, we can help you write the necessary query.

    The query for Command is really long and complicated and it's used in another report. I'm trying to use this Command with another table called mCallEnd because I need couple of fields from mCallEnd table to make my report.

    I attached the picture of report that I need to make along with my Command query and links between Command and mCallEnd.
    The first 3 columns I need to pull out from mCallEnd table, and Total Billable Minutes is made in Command query.

    Thanks!
    Attached Thumbnails Attached Thumbnails report1.jpg   links.JPG  
    Attached Files Attached Files

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Just a thought - what's wrong with just using Crystal to do the joins for you?
    What's your reasoning behind making it in to a single command?
    George
    Home | Blog

  5. #5
    Join Date
    Jun 2016
    Posts
    6
    Can anyone help to filter crystal report by daterange
    Im using SDATE field in database using sql command to access the database.
    I want to add 2 datetimepicker for the date from and date to.


    can anyone help me?
    Thanks alot

    PS: SDATE is datetime datatype

Posting Permissions

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