Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » no results(correct query but no results in the table)
no results [message #720329] Tue, 30 August 2011 11:39 Go to next message
Nadine  is currently offline Nadine
Messages: 3
Registered: August 2011
Junior Member
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 13:18 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 05:54 Go to previous messageGo to next message
Nadine  is currently offline Nadine
Messages: 3
Registered: August 2011
Junior Member
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 10:30 Go to previous messageGo to next message
Spatial_Man  is currently offline Spatial_Man
Messages: 4
Registered: September 2011
Junior Member
Is the test connection from Data Source successful?
Re: no results [message #721341 is a reply to message #721282] Thu, 01 September 2011 14:09 Go to previous messageGo to next message
Nadine  is currently offline Nadine
Messages: 3
Registered: August 2011
Junior Member
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 15:47 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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:
  


Current Time: Sat Sep 20 08:17:46 GMT 2014

Powered by FUDForum. Page generated in 0.02104 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software