Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Drill-Through
Drill-Through [message #677758] Thu, 09 June 2011 10:20 Go to next message
jeyinul  is currently offline jeyinul
Messages: 60
Registered: June 2011
Member
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 10:38]

Report message to a moderator

Re: Drill-Through [message #680746 is a reply to message #677758] Thu, 09 June 2011 16:00 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 06:10 Go to previous messageGo to next message
jeyinul  is currently offline jeyinul
Messages: 60
Registered: June 2011
Member
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.

[Updated on: Fri, 10 June 2011 06:21]

Report message to a moderator

Re: Drill-Through [message #682188 is a reply to message #681952] Fri, 10 June 2011 15:00 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 05:47 Go to previous messageGo to next message
jeyinul  is currently offline jeyinul
Messages: 60
Registered: June 2011
Member
Hi Jason,

Please find the attachment foe detail report.

Thanks,
Jeyinul.
  • Attachment: RPT File.txt
    (Size: 10.05KB, Downloaded 55 times)
Re: Drill-Through [message #683308 is a reply to message #683154] Mon, 13 June 2011 13:36 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 06:15 Go to previous messageGo to next message
jeyinul  is currently offline jeyinul
Messages: 60
Registered: June 2011
Member
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,
--------------------------------------------------------------------------------
<!-- 1. Include com.tufan.digite.utils.webappsecurityutils.* in your 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 13:40 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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,
> --------------------------------------------------------------------------------
>
> <!-- 1. Include com.tufan.digite.utils.webappsecurityutils.* in your 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 04:32 Go to previous messageGo to next message
jeyinul  is currently offline jeyinul
Messages: 60
Registered: June 2011
Member
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 13:47 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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:
  


Current Time: Wed Sep 17 19:49:52 GMT 2014

Powered by FUDForum. Page generated in 0.01861 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software