i'm using jasper studio V6.6.0 and i need to attach very simple query statment like "date" to my report
i following the wizard to create Query by right click in jasper report server then choose query and fill the query name '''date' then choosing my data source and finally write my sql statment like
DATE_FORMAT(CURRENT_TIMESTAMP, '%h:%i:%s %p');
i can't attach this query to my report !
how i can do this ? can any one help me !
There's no query in Data Adapter. What you need to do is create a data adapter to your database. The create a report and specify to use that data adapter.
If you already have a report, click on "DataSet and Query editor dialog" icon. It is the second from the left icon located at the top right side of the report panel. In this dialog, enter your sql statement.