viewireport

DB - postgres SELECT tt.created_date FROM test_table tt WHERE DATE(uc.created_stamp) = DATE($P{ic_date}) Here, ic_date is a parameter created using ireport. parameter (ic_date) class is java.util.Date If default value expression is required, enter like this, new SimpleDateFormat("yyyy-MM-dd").parse("2008-01-01") Hope this will help many since it took some time for me to figure out the same.

This is about using hyperlink with mdx query in jasperserver-ce-3.7.0 cube summary ============ cube name: cube user click dimension 1: event level: name dimension 2: eventid level: id measure: click total Schema ====== <Schema name="New Schema1"> <Cube name="cube user click" cache="true" enabled="true"> <Table name="user_click" schema="public" alias="user_click"> </Table> <Dimension type="StandardDimension" foreignKey="event_id" name="event"> <Hierarchy hasAll="true" primaryKey="event_id"> <Table name="event" schema="public" alias="event"> </Table> <Level name="name" table="event" column="name" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> </Level> </Hierarchy> </Dimension> <Dimension type="StandardDimension" foreignKey="event_id" name="eventid"> <Hierarchy hasAll="true" primaryKey="event_id"> <Table name="event" schema="public" alias="event"> </Table> <Level name="id" table="event" column="name" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> </Level> </Hierarchy> </Dimension> <Measure name="click total" column="click_type" datatype="String" aggregator="sum" visible="true"> </Measure> </Cube> </Schema> hyperlink ========== Have a report with a hyper link (http://localhost:8080/jasperserver/olap/viewOlap.html?name=/analysis/views/analysis_event_input&mdx=SELECT%20[Measures].AllMembers%20ON%20COLUMNS,Hierarchize%28[event].[All%20Events].Children%29%20ON%20ROWS%20FROM%20[cube%20user%click]%20where%20[eventid].[232323]) On clicking the hyper link, i want to open the analysis view based on the id (232323) as it is available in SQL (SELECT * from table-name WHERE event_id='232323'). but it opens up the default analysis view without checking the where clause. schema screen shot is attached for reference Greatly appreciate your help to fix this issue. Post Edited by viewjas at 07/22/2010 19:41 Post Edited by viewjas at 07/22/2010 19:44

Trying to call jasperserver url as http://localhost:8080/jasperserver/flow.html?_flowId=searchFlow&j_username=jasperadmin&j_password=jasperadmin Is there a way to encrypt the password when passing it as part of URL query string ?