Passing parameter from jsp to birt-viewer

I currently run birt-viewer under Tomcat 6.

I access my reports by putting them in the birt-viewer directory under webapps. I then use a jsp with content as follows to access the reports because I want them to show in a frame in my web page:

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>

<html>
<head>
<script language="JavaScript" >
function showBIRTReport() {
window.location="http://localhost:8080/birt-viewer/frameset?__report=myReport.rptdesign";
}
</script>
</head>
<body onload="showBIRTReport()">
</body>
</html>

This works great but now I have come across a situation where I need to pass a parameter from my jsp page to the BIRT viewer so that I can use it in the where clause of a query to limit what the query returns.

How do I do this? I have looked at the section in the book which talks about using AppContextKey and AppContextValue but I am not an experienced web developer so I am not sure how to apply the Listing 5-12 advice to my situation. I understand that the code between <% and %> is Java that runs in a .jsp.

Can I use something like <jsp:forward page="<%=http://localhost:8080/birt-viewer/frameset?__report=myReport.rptdesign" %>" /> to get birt-viewer running my report?

More importantly, can I put the setAttribute calls in the Java code that forwards to my .jsp above and avoid doing the setting in the .jsp itself?

Thanks for any help you can provide.

Find more posts tagged with

Comments

mwilliams

Hi John,

Could you make a hidden parameter in your report design and pass it through the report URL?

JDH

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="75124" data-time="1301342369" data-date="28 March 2011 - 12:59 PM"><p>
Hi John,<br />
<br />
Could you make a hidden parameter in your report design and pass it through the report URL?<br /></p></blockquote>
<br />
<br />
Michael,<br />
I have passed the parameter on the URL can you tell me how to get access to it so I can use it in my query?

JDH

I did pass the parameter through the URL but I can't seem to access it in the query. Can you tell me how to do that?

mwilliams

John,

In your report, you'll need to make sure you set up a hidden report parameter to pass it through to. If you've already done this, you can either use a dataSet parameter marker '?' in your query where you want the value to go and link the dataSet parameter to the hidden report parameter you created in the "parameters" tab of the dataSet editor. Or, you could edit your query in your beforeOpen script of your dataSet. You access your query in script with this.queryText. Let me know if you have questions.