There were many threads on the board, where Hitesh was actively dealing with solutions for multi-company SQLs or data access.

How to display data from two companies in a single session? (http://www.baanboard.com/baanboard/showthread.php?t=12792&highlight=company)

Display session based on 2 tables (http://www.baanboard.com/baanboard/showthread.php?t=15349&highlight=company)

data from 2 companies (http://www.baanboard.com/baanboard/showthread.php?t=12747&highlight=company)

Here is the update from the latest porting set (7.6a01) of Gemini/SSA-LN
DevMahler: # 24382 (BDUX16748): NQP: Multi-company support
Date: Thu, 13 Jan 2005 16:49:32 +0100 (CET)
Created on: DevMahler
Type: enhancement

Problem Description (Customer terms) The BaanSQL language does not offer an
'easy' way to execute a query over multiple companies. For example, the
following is not possible:

select *
from <table>
where _compnr in ( 100, 200 )

For the Cognos integration it is required to support simple multi-company
constructions, as defined in the Solution text below.

Test Procedure
See /vobs/tt/lib/sql/Test/tests/multi_company.

Note that these queries should be tested in the 'ANSI prepare mode'. Using bsql
this can be done with the option "-p16". It is not possible to test this
functionality from the bshell.

Affected Executables
bshell
bsql
bdb-library
jbdb

Hi all,

I´m facing the same problem with multicompany reports in Cognos. Could you post the reference to the solution. Any help will be appreciated.

Thanks in advance

regards

Carsten