write query on backend in Crystal Report 9 1

[lana123]

Hi,people.
I create the report and I need for it 6 tables and 5 views.
After I select the database objects from datasource I have to join the tables and views.I'm doing this in Links of DatabaseExpert.
But I would like to write my query programmaticly.
How can I do it and what I have to use?
Thanks in advance.
Lana

 

[synapsevampire]

What does write query programatically mean to you?

You can select Add Command at your datasource and paste in/write a Query, or you can create another View or SP on the database side that will do the joining and then just use that.

-k

 

[lana123]

Hi and thank you for the answer.
I think I need Add Command(because I need only to write query based on the views and tables which I already have)
but I cannot find this Add Command.
Would you like, please,to specify for me?

Lana

 

[synapsevampire]

WHen you select a SQL data connection type, the first choice is Add Command.

-k

 

[lana123]

Thank you!