Eclipse Community Forums: BIRT

Home » Archived » BIRT » no results(correct query but no results in the table)

no results [message #720329]

Tue, 30 August 2011 07:39

Eclipse User

hi,

i have a problem and i don't know what to do anymore...

i created a working query, no error or problem message on creating the dataset in eclipse.
the mysql-browser shows for this sql about 1500 rows.

but the table i created with the dataset in my report is always empty.

how can i find out whats going wrong?

Re: no results [message #720375 is a reply to message #720329]

Tue, 30 August 2011 09:18

Eclipse User

Does the data set preview show any rows of data?
Do you get anything in the log file?
Search the .metadata folder of your workspace for *.log.

Jason

On 8/30/2011 7:39 AM, Nadine wrote:
> hi,
>
> i have a problem and i don't know what to do anymore...
>
> i created a working query, no error or problem message on creating the
> dataset in eclipse.
> the mysql-browser shows for this sql about 1500 rows.
>
> but the table i created with the dataset in my report is always empty.
>
> how can i find out whats going wrong?
>
>
>
>
>
>
>

Re: no results [message #721174 is a reply to message #720375]

Thu, 01 September 2011 01:54

Eclipse User

No, data set preview shows 0 rows,
but i use many parameters and some are calculated in "beforeFactory". so the preview often shows empty results...

.log is empty

Re: no results [message #721282 is a reply to message #721174]

Thu, 01 September 2011 06:30

Eclipse User

Is the test connection from Data Source successful?

Re: no results [message #721341 is a reply to message #721282]

Thu, 01 September 2011 10:09

Eclipse User

yes, connection successful.

this morning i opened the rptdesign file with notepad++, changed the sql query, added the parameters with correct numeration and... it works!

i don't unterstand BIRT... Sad

Re: no results [message #721382 is a reply to message #721341]

Thu, 01 September 2011 11:47

Eclipse User

Can you post what you changed it from and to?

Jason

On 9/1/2011 10:09 AM, Nadine wrote:
> yes, connection successful.
>
> this morning i opened the rptdesign file with notepad++, changed the sql
> query, added the parameters with correct numeration and... it works!
>
> i don't unterstand BIRT... :(

Previous Topic:	French Characters in HTML report
Next Topic:	Want to disable some option(like,ppt,word) in Export Report

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Jul 24 23:26:51 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter