nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Search option in BIRT

princeabd

Hi,

We want one BIRT Report with following steps.

1. Search box - User will type first 3 or 4 letters of employee name. Based on that it will execute the query ( select firstname from enterpriseuser where firstname like '%&fn%') and should display the records with hyperlink.

2. if the user click the hyperlink on particular employeename then it will execute the query and should display the project details.

Please let me know whether is it possible and the workflow in BIRT and Eclipse.

Find more posts tagged with

Comments

mwilliams

It will probably take a lot of javascript to do this. You might be able to find something out there on the web where this has already been done that you can download.

princeabd

Yes, I am trying using Hyperlink option in BIRT. I'm getting error as "Keys Manipulated" while running.

Please clarify on this.

parv

Can you paste here your design report, i mean where you want search box and script. As i think filter option is there in birt and you can provide your criteria in the filter window then your task can be completed by putting small javascript like

beforOpen script

if(params["paramFirstName").value !=null ){
this.queryText=" and firstNameColumn like '"+params["paramFirstName").value+"'";
}

Note : Here i assume that where caluse is already present in your report query

princeabd

Hi parv,

Thanks for your reply.

Here i attached two rpt file. One is main file(Search_Resource_Sheet)
another one is used in Drill through. (Link_Search_Resource_Sheet)

While running, it display the window to get a input. I entered one employee name based on that it display the details of employee with hyperlink.

I get error saying that "Keys Manipulated" when i click on the hyperlink.

Please check and let me know the solution.

PFA.

Thanks.
Jeyinul.

princeabd

can you explain how to use JDBC datasource.

how to link driver class,