Crystal Reports 2008 combining Command and db together

[Marina385]

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 advance

 

[kray4660]

It appears that you have a command and two tables. You would need to open the database expert and establish the joins necessary. But joining a command and other tables can affect performance. It is better to either go with all tables or (preferred) a command or stored procedure (best performance) for the data source.

 

[Marina385]

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!

 

[Marina385]

and here is command query.

 

[PeterDimitrov]

Try to add the tables to the command instead of adding them to the report.

http://www.R-Tag.com

Viewer and Scheduler for Crystal reports, SSRS and Dynamic Dashboards.