Unanswered: Crystal Reports 2008 combining Command and db together
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?
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.