Question to queries and a Data Set

Hello everybody,

I would like to do many "count"-queries of a field from a database table.
For example:
count products between January and July

Is it necessary for every query to create a new Data Set?

Are there any possibilties to avoid that? Because I would get a plenty of Data Sets, where aren´t be clearly.

Thank You

Best regards
ManInBlack

Find more posts tagged with

Comments

mwilliams

Hi ManInBlack,

What does your data look like in your database? You can do SQL unions to build a single dataSet with different queries. This may work for you.

ManInBlack

Hi,

thanks.

The problem is, that I use a own-programmed ODA-driver to a CORBA-Environment. The Corba-Interface provide only OQL. OQL (Object Querry Language) is a simple kind of SQL. Complex Querries as like as in SQL aren´t available.

A OQL-querry looks like:
"select * from ProductTable"
or with where-clause
"select count * from ProductTable where date < 2009-05-03"

I will create a simple birt-example and will post it here. Afterwards the struktur of the database or the actual situation with the multiple querries are better to understand.

See you later.

ManInBlack

mwilliams

ManInBlack,

Sounds good. Let me know.