Two Connection.

[#1]

Dear QV experts,

I have two database connection. One with Orcale and another one with Sql Server. when i wants to show data in one table box that time multiple rows comes..How can i solve this problem...Please help me.. For your better understanding i have attached my file...

Regards,

Masba

[Anonymous]

Your table should be link with all the tables which you are using in table box.

[#3]

Hi masba khandaker,

There is no relation between two data sources tables. make a filed common between two sources then try it out.

[Anonymous]

rename your CT.BRAND as Brand_Id .. It will work

[tyagishaila]

Instead of Table Box use Straight Table and

in expression use sum(Depot_Pre_Sales_Qty).

Try it,

[padmanabhan_ram]

Hi Masba,

I guess the fields in the table object in the UI are from more than one table which should be fields from Oracle table and fields from SQL table. If so please find out a primary key between those tables and link the tables using the primary key and the duplicate rows will be resolved.

Thanks,

Padmanabhan

[rajeshvaswani77]

Masba,

You have synthetic key in the data mode. Concatenate fields Brand_ID, Category_Id, Category_name, Brand_name and create one Link field to link the tables. The rows repeat because the quantity is different. You can always aggregate and have a sum of quantity.

regards,

Rajesh Vaswani

[Anonymous]

Hi

Use a primary linkage and avoid synthetic keys which will help you..

Thanks,

Vignesh

[#9]

Dear Rajesh,

Thanks for your reply.. can you edit my file it will be so much helpful for me as a new learner.

Masba

[alkesh_sharma]

I tried but couldn't identify a primary key in your database.

Identify a primary key. and link the tables using the primary key.

Also the Brand_ID and Brand Code contain the same values, Rename Brand Code  as Brand ID and link that table as well.