Dynamic Parameters with drill-through

Rin · 2011-06-28T15:32:43+00:00

Hi, I'm trying to write a custom parameter page with BIRT tag library. Everything went well till it comes some dynamic parameter in a sub-page. For example. with a table has follow columns: CompanyName,Department,Manager,Employee,Salary,Phone.... In…

Rin

Hi, 
 
I'm trying to write a custom parameter page with BIRT tag library. 
 
Everything went well till it comes some dynamic parameter in a sub-page. 
 
For example. with a table has follow columns: 
 
CompanyName,Department,Manager,Employee,Salary,Phone.... 
 
 
In the master page, I use a hyperlink with drill-through, pass a parameter CompanyName to a sub-page. 
Then the sub-page will be invoked, with the CompanyName from the main page(e.g. the company name is BiliBili), the sub page will get the values of the dynamic parameter Department (all the departments in BiliBili Company), then the user can select from Departments of BiliBili on the parameter page. 
 
 
It works well with BIRT-Report Viewer, but now I need to write a custom parameter page, then it comes problems...

Find more posts tagged with

Comments

Rin

The problem is, since I use code like:

<birt:parameterPage
id="report1"
name="page1"
reportDesign="report\SubPage.rptdesign"
isCustom="true"
pattern="frameset">

<birt:param name="CompanyName" value="BiliBili"/>
 
<birt:paramDef id="1170" name="Department"/>
 
<input type="submit" name="submit" value="Sumbit form"/>
</birt:parameterPage>
 
</body>

Although the CompanyName has been set,the Department parameter still comes out as empty, which is a list-box with no value in it(I expect it to get the Department from BiliBili).

JasonW

Look at the attached cascade example where the first level is set.

Jason

Rin

<blockquote class='ipsBlockquote' data-author="'JasonW'" data-cid="79328" data-time="1309366196" data-date="29 June 2011 - 09:49 AM">
Look at the attached cascade example where the first level is set. 
 
Jason </blockquote>
 
Thanks for the reply! 
 
Is there a way to hide the first-level cascading parameter in the customized parameter page, while submit the value set by jsp to the report please? 
 
The reason I does not use the cascading parameter is that I have many parameters which need to be allowed to have multi-values, and value of those parameters is based on the other parameters selected by user. 
 
For example: 
User firstly select some Country, 
then all the cities of those country will appear in a list box, which also allow user to select multi-values; then all the NIKE-stores in those cities selected by user will appear in another listbox. 
 
Since birt only allow the last child of the cascading parameter group to has multi-values, I used 3 pages to do the job, in first page user can select multi countries, then the second page is invoked through a drill-through hyperlink, passing the selected countries from the first page, to get the responding cities..... 
 
It works well with report viewer, but when I tried to create customized parameter page(to allow use some UI library to make the report UI more awesome), the problem in my first post in this thread aroused. 
 
 
Cascading parameter will work, if there is a way to hide the first level parameter.

JasonW

Can you use a style to hide it? See this example:

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@ taglib uri="/birt.tld" prefix="birt" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<style type="text/css">
.class1 { background-color:#ffffff; color: #000000; display: none }
</style>
<body>

Parameter Page 1
 
<birt:parameterPage
id="report1"
name="page1"
reportDesign="cascade_report.rptdesign"
isCustom="true"
pattern="frameset">

<birt:paramDef id="5" name="Country" value="USA" cssClass="class1"/>
 
Cascading Parameter2: <birt:paramDef id="6" name="City"/>
 
Cascading Parameter3: <birt:paramDef id="7" name="Customer"/>
 
<input type="submit" name="submit" value="Sumbit form"/>
 
</birt:parameterPage>
 
</body>
</html>

Note that country is hidden.

Jason

Rin

<blockquote class='ipsBlockquote' data-author="'JasonW'" data-cid="79343" data-time="1309382153" data-date="29 June 2011 - 02:15 PM">
Can you use a style to hide it? See this example: 
 
<%@ page language="java" contentType="text/html; charset=ISO-8859-1" 
pageEncoding="ISO-8859-1"%> 
<%@ taglib uri="/birt.tld" prefix="birt" %> 
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "<a class='bbc_url' href='http://www.w3.org/TR/html4/loose.dtd">'>http://www.w3.org/TR/html4/loose.dtd"></a> 
<html> 
<head> 
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> 
<title>Insert title here</title> 
</head> 
<style type="text/css"> 
.class1 { background-color:#ffffff; color: #000000; display: none } 
</style> 
<body> 
 
Parameter Page 1 
 
<birt:parameterPage 
id="report1" 
name="page1" 
reportDesign="cascade_report.rptdesign" 
isCustom="true" 
pattern="frameset"> 
 
<birt:paramDef id="5" name="Country" value="USA" cssClass="class1"/> 
 
Cascading Parameter2: <birt:paramDef id="6" name="City"/> 
 
Cascading Parameter3: <birt:paramDef id="7" name="Customer"/> 
 
<input type="submit" name="submit" value="Sumbit form"/> 
 
</birt:parameterPage> 
 
</body> 
</html> 
 
 
Note that country is hidden. 
 
Jason </blockquote>
 
 
Thank you Jason, it works!

madhur

<blockquote class='ipsBlockquote' data-author="'JasonW'" data-cid="79328" data-time="1309366196" data-date="29 June 2011 - 09:49 AM">
Look at the attached cascade example where the first level is set. 
 
Jason </blockquote>
 
Hi Jason, 
 
I tried this example, but I'm getting an error 'The service is not initialized!. Use BirtReportServiceFactory.init(ServletConfig) to init.' 
 
Please have a look at the attached file. 
 
I used the cascade_report.rptdesign file given in the zip file and this is my jsp. 
 
 
Parameter Page 1 
 
<birt:parameterPage 
baseURL="/birt" 
id="report1" 
name="page1" 
reportDesign="cascade_report.rptdesign" 
isCustom="true" 
pattern="frameset"> 
 
Cascading Parameter1: <birt:paramDef id="5" name="Country" /> 
 
Cascading Parameter2: <birt:paramDef id="6" name="City"/> 
 
Cascading Parameter3: <birt:paramDef id="7" name="Customer" cssClass="class1"/> 
 
<input type="submit" name="submit" value="Sumbit form"/> 
 
</birt:parameterPage> 
 
 
 
Do you have any idea what is the reason for this error and how to fix it? 
Thanks

JasonW

Can you give some details on how you have BIRT deployed and what version?

Jason

madhur

Birt version is 3.7.2
It's deployed in Jboss 5
There I have the birt.war deployed. And the jsp file is in myapp.war.
In myapp.war WEB-INF, birt.tld is in tlds folder and in WEB-INF\lib I have put these libraries from birt.war axis.jar, com.ibm.icu_4.4.2.v20110823.jar, org.eclipse.birt.runtime_3.7.2.v20120214-1408.jar and viewservlets.jar

I tried another similar example. For that also I'm getting the same error.
http://www.birt-exchange.org/org/forum/index.php/topic/25371-the-service-is-not-initialized-use-birtreportservicefactoryinitservletconfig-to-init/

When I set isCustom="false" then the above works fine with the default parameter page.