Eclipse Community Forums: BIRT

Home » Archived » BIRT » query

Mon, 30 July 2007 09:44

Eclipse User

Originally posted by: thiagoram.gmail.com

I have a where clause im my query like this:
where
dbo.imoveis.oid_imoveis IN (?)

For the parameter i have a single one like this
Name:idImoveis
dataType:Decimal
Default value: 500001,500002

When i run my query in quantum the result is correct, returning 2 results.
But on the Preview Results in the dataSet, only one result is show. What
can i be doing wrong?

Re: query [message #250412 is a reply to message #250381]

Mon, 30 July 2007 12:23

Eclipse User

Originally posted by: jasonweathersby.alltel.net

Thiago,

The ? can only be one parameter.
To do what you want use property binding or script to modify the query.
Your parameter will need to be defined as a string not a decimal.

Take a look at this example.
http://www.eclipse.org/birt/phoenix/examples/reports/birt2.1 /querymod/index.php

Jason

Thiago wrote:
> I have a where clause im my query like this:
> where
> dbo.imoveis.oid_imoveis IN (?)
>
> For the parameter i have a single one like this
> Name:idImoveis
> dataType:Decimal
> Default value: 500001,500002
>
>
> When i run my query in quantum the result is correct, returning 2
> results. But on the Preview Results in the dataSet, only one result is
> show. What can i be doing wrong?
>

Previous Topic:	Chart+Table from scripted Data Source
Next Topic:	all in one download error

Goto Forum:

-=] Back to Top [=-

Current Time: Wed May 14 20:31:31 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter