Eclipse Community Forums: BIRT

Home » Archived » BIRT » Drill-Through

Thu, 09 June 2011 06:20

Eclipse User

Hi All,

Now I am trying to use Drill-Through option in Hyperlink.

i have two reports. i am trying to connect one report using drill-through.
Its working fine in BIRT.

When i deployed the report i am getting error when i click the hyperlink saying that "Keys Manipulated"

i.e. First report is working fine. it displays correct records. in that records, one column is having hyperlink to connect another report.

here is the problem.

Can you help me on this.

when i click the hyperlink, the below url is coming,

"http://192.168.1.30/birt/run?__report=D%3A\jboss_51\server\digite\deploy\birt.war\Reports\12201_12140_new_report_jdbc.rptdesign&__format=html&SearchParam=JEYINUL+SECURITY+SAMPLE+TESTING&__locale=en_US&__svg=false&__designer=false&__pageoverflow=0&__masterpage=true&__bookmark=JEYINUL+SECURITY+SAMPLE+TESTING&__istoc=true"

Thanks,
Jeyinul.

[Updated on: Thu, 09 June 2011 06:38] by Moderator

Re: Drill-Through [message #680746 is a reply to message #677758]

Thu, 09 June 2011 12:00

Eclipse User

Jeyinul,

I did not see any issues with the master report. Any chance you could
build the master and detail report using the sampledb and produce the
problem. That way I can run and debug the report.

Jason

On 6/9/2011 6:20 AM, jeyinul wrote:
> Hi All,
>
> Now I am trying to use Drill-Through option in Hyperlink.
>
> i have two reports. i am trying to connect one report using drill-through.
> Its working fine in BIRT.
>
> When i deployed the report i am getting error when i click the hyperlink
> saying that "Keys Manipulated"
>
> i.e. First report is working fine. it displays correct records. in that
> records, one column is having hyperlink to connect another report.
>
> here is the problem.
>
> Can you help me on this.
>
> Thanks,
> Jeyinul.

Re: Drill-Through [message #681952 is a reply to message #680746]

Fri, 10 June 2011 02:10

Eclipse User

Hi Jason,

I have tried using Sample database.

But I am getting same error. when i click the hyperlink.

Here i attached the report. Please check and let me know.

Thanks.
Jeynul.

Attachment: 12220_Sampledatabase.rptdesign
(Size: 11.34KB, Downloaded 237 times)
Attachment: Plz look on the URL.doc
(Size: 309.00KB, Downloaded 277 times)

[Updated on: Fri, 10 June 2011 02:21] by Moderator

Re: Drill-Through [message #682188 is a reply to message #681952]

Fri, 10 June 2011 11:00

Eclipse User

Can you attach the detail report as well?

Jason

On 6/10/2011 2:10 AM, jeyinul wrote:
> Hi Jason,
>
> I have tried using Sample database.
>
> But I am getting same error. when i click the hyperlink.
>
> Here i attached the report. Please check and let me know.
>
> Thanks.
> Jeynul.

Re: Drill-Through [message #683154 is a reply to message #682188]

Mon, 13 June 2011 01:47

Eclipse User

Hi Jason,

Please find the attachment foe detail report.

Thanks,
Jeyinul.

Attachment: RPT File.txt
(Size: 10.05KB, Downloaded 400 times)

Re: Drill-Through [message #683308 is a reply to message #683154]

Mon, 13 June 2011 09:36

Eclipse User

Jeyinul

Do you have the detail report that uses the sample db? If so please
post it. I want to be able to produce the issue. Where are you
deploying the reports?

Jason

On 6/13/2011 1:47 AM, jeyinul wrote:
> Hi Jason,
>
> Please find the attachment foe detail report.
>
> Thanks,
> Jeyinul.

Re: Drill-Through [message #683627 is a reply to message #683308]

Tue, 14 June 2011 02:15

Eclipse User

Hi Jason,

We are using a tool which is called "DIGITE"

Generally we need RPT file and reg.jsp file to generate a report.

RPT FILE IS POSTED ABOVE.

The below code, i am using.

1.IN reg.jsp,
--------------------------------------------------------------------------------

<%@ page import ="com.tufan.digite.utils.webappsecurityutils.*"%>
<%@ page import ="com.tufan.digite.web.beans.*"%>
<%@ page import ="com.tufan.digite.dataobjects.*"%>

<%
WebSecHelper.checkIfSubmitIsGenuine(request, response,application);
%>

<html>

<title> Table </title>

<body>

<form name = "j">

<TABLE width ="350" align = "center" BORDER="1" BGCOLOR="#F9A89F" height="60">

<tr>
<td> Project Name: <input type="text" name="SearchParam" /> </td>

</tr>

</table>
</form>
</body>
</html>
----------------------------------------------------------------------------

Plz check and let me know.

Thanks,
Jeyinul

Re: Drill-Through [message #683840 is a reply to message #683627]

Tue, 14 June 2011 09:40

Eclipse User

Jeyinul,

I am not familiar with that tool. Have you posted the question on their
forums?

Jason

On 6/14/2011 2:15 AM, jeyinul wrote:
> Hi Jason,
>
> We are using a tool which is called "DIGITE"
>
> Generally we need RPT file and reg.jsp file to generate a report.
>
> RPT FILE IS POSTED ABOVE.
>
> The below code, i am using.
>
> 1.IN reg.jsp,
> --------------------------------------------------------------------------------
>
> 
> <%@ page import ="com.tufan.digite.utils.webappsecurityutils.*"%>
> <%@ page import ="com.tufan.digite.web.beans.*"%>
> <%@ page import ="com.tufan.digite.dataobjects.*"%>
>
> <%
> WebSecHelper.checkIfSubmitIsGenuine(request, response,application);
> %>
>
>
>
> <html>
>
> <title> Table </title>
>
> <body>
>
>
> <form name = "j">
>
> <TABLE width ="350" align = "center" BORDER="1" BGCOLOR="#F9A89F"
> height="60">
>
> <tr>
> <td> Project Name: <input type="text" name="SearchParam" /> </td>
>
> </tr>
>
> </table>
> </form>
> </body>
> </html>
> ----------------------------------------------------------------------------
>
>
>
> Plz check and let me know.
>
> Thanks,
> Jeyinul

Re: Drill-Through [message #685230 is a reply to message #683840]

Fri, 17 June 2011 00:32

Eclipse User

Hi Jason,

I am getting following message in console while running the report.
Can you please try to solve my problems,

ignoring unsupported operation exception thrown by ODA driver (org.eclipse.birt.report.data.oda.jdbc) cannot set query specification before prepare.

EXCEPTION IN WEBSECHELPER.validatekeyparametersForURL() java.lang.exception:Keys Manipulated

Regards,
Jeyinul.

Re: Drill-Through [message #685428 is a reply to message #685230]

Fri, 17 June 2011 09:47

Eclipse User

Jeyinul,

I would like to help, but I do not know how the DIGITE package is
integrating BIRT.

Jason

On 6/17/2011 12:32 AM, jeyinul wrote:
> Hi Jason,
>
> I am getting following message in console while running the report.
> Can you please try to solve my problems,
>
> ignoring unsupported operation exception thrown by ODA driver
> (org.eclipse.birt.report.data.oda.jdbc) cannot set query specification
> before prepare.
>
>
> EXCEPTION IN WEBSECHELPER.validatekeyparametersForURL()
> java.lang.exception:Keys Manipulated
>
>
> Regards,
> Jeyinul.

Previous Topic:	dynamic data set from different table different feilds, according to parameter
Next Topic:	SQL Query changes take long

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jul 25 02:49:01 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter