Eclipse Community Forums: BIRT

Help

Home

Home » Archived » BIRT » Preview problem

Show: Today's Messages :: Show Polls :: Message Navigator

Preview problem [message #261576]

Fri, 16 November 2007 18:30

Hans

Messages: 2662
Registered: July 2009

Senior Member

Hi people,

I don't know what happened but now when I create a data set and press
the Preview Results button, nothing appears, only the field names, but no
data is present. Even if I use a basic query like select * from
schema.table.

Greetings,
Hans

Report message to a moderator

Re: Preview problem [message #261579 is a reply to message #261576]

Fri, 16 November 2007 18:52

Hans

Messages: 2662
Registered: July 2009

Senior Member

I found the problem..

The query..

SELECT
dlr.field1,
dlr.field2
FROM
table1 dlr,
table2 l
WHERE
dlr.id = l.id

The problem: the "dlr" alias. I don't know it, but this alias "dlr" is a
reserved word or something similar in Birt.

Report message to a moderator

Previous Topic:	Birt 2.1.1 to Birt 2.2.1 report migration problem
Next Topic:	Total.countDistinct function syntax with grouping

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 13:24:00 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter