Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Passing Parameter with Hyperlink Drill Through
PascalH
<p>Hi there i have a problem passing a parameter using a hyperlink from another Report via Drill Trough.</p>
<p>I have 6 grid elements in my report,</p>
<p>My problem is that for the first 2-3 charts the parameter passed down is used but for the rest the parameter is somehow not used anymore. Is there any limitation?</p>
<p>I pass down the parameter with drill trough without Bookmarks</p>
Find more posts tagged with
Comments
JFreeman
<p>Which version of BIRT are you using?</p>
<p>Can you attach a sample report based on Classic Models or a flat file that reproduces the issue?</p>
PascalH
<p>I am using Version 4.2.2 i will try to make a sample but the first tries i dont got the same problem.. i will also try to reproduce my report on a blank one again and see if the problem occurs again.</p>
<p>What i found out so far if i just add my param.value after the report the value is wrong so usualy the Paramater from hyperlink ist 123-456 but at the end of my report it is 123-%</p>
JFreeman
<p>Thanks for the additional details.</p>
<p> </p>
<p>A sample the reproduces the issue is going to be the best way for to us to provide assistance.</p>
PascalH
<p>The thing is if i produce a new report with Classic models the problem do not appear. I basically use this setup in my report but somehow the parameter is lost half way... The Hypsample files are just an example how my report looks like.</p>
<p>The realy weird thing is if i Filter one of the charts by choosing -<"select value"> i can only choose the parameter value that i need. but if i dont choose it the result are also different values. As to be seen in the screenshot.</p>
<p> </p>
<p>But as mentioned earlier if i just put in a data field at the end of my report with the param.value it returns 500-% instead of 500-3000-1619011</p>
<p> </p>
<p> </p>
PascalH
<p>Any clues what it could be?</p>
PascalH
<p>To clarify it once more</p>
<p>At the start of the same report it gives another Param value than at the end. Screenshots below show the start and the end of the report page. Both fields use param.value</p>
<p> </p>
<p> </p>
<p>So somewhere, somehow between all my charts and tables the parameter value is changing somehow and i basically use no scripts in it</p>
JFreeman
<p>Without being able to reproduce the issue or see your original report designs it is hard to determine what is causing this issue.</p>
<p> </p>
<p>How many report designs are you drilling down to when this happens?</p>
<p>Is it possible to post the expressions you are passing to the value of the parameter in the drill-through?</p>
<p> </p>
<p>One other I can think to check for is the value you are passing to the parameter could have a special character of some sort in it. This might cause some unexpected behavior. </p>
PascalH
<p>Thanks Freeman for your replies..</p>
<p>I could not create a sample but I FOUND THE PROBLEM yey finaly</p>
<p>A simple misstake made me spend so much time on it.. In one of my computed Columns i wrote an expresion like:</p>
<p> </p>
<p>if {BirtComp.like(params[</p>
<p>"Artikelnummer"].value, "X))</p>
<p>else { (params["Artikelnummer"].value == "500-%")</p>
<p>} //you might see the misstake... Changed it to the correct expression and it works.. thanks for your afford JFreeman! I realy appreciate the way this community is working</p>
JFreeman
<p>Thank you for the update and details.</p>
<p>I am glad to hear you resolved the issue.</p>
<p> </p>
<p>Let us know if you have any additional questions.</p>
Srinivas Yarra
<p>Hi Jesse,</p>
<p> </p>
<p>We have designed two reports, first report have bar chart. Second reports will render the line chart based on first report selection (onclick on bar).</p>
<p> </p>
<p>Use case:-</p>
<p> </p>
<p>Whenever user click on bar in chart (first report) it should drill down to second report in separate window (new window). But, it is giving login page instead of report render in window. We are using jsapi to authenticate and render first report in jsp page. </p>
<p> </p>
<p>It is working in designer and iHub3 server. But, we are calling application then this is happening..</p>
<p> </p>
<p>Please find the attached drill configuration file in attachments.</p>
<p> </p>
<p> </p>
<p>Thanks,</p>
<p>Srinivas</p>
JFreeman
<p>How are you storing the session for the user on your JSP page after authenticating with JSAPI?</p>
<p> </p>
<p>It sounds like the session for the user may not be stored properly which is causing it to request authentication again.</p>
Srinivas Yarra
<p>Hi Jesee,</p>
<p> </p>
<p>Thank you for replies. We are not storing user session specific to js api after authentication. </p>
<p> </p>
<p>Please find our jsp page in the attachments.</p>
<p> </p>
<p>Kindly give any sample code to store session after authentication with jsapi.</p>
Srinivas Yarra
<p>Hi Jesse,</p>
<p> </p>
<p>We are authenticating ihub3 server using js api :</p>
<p> </p>
<p>Sample code :-</p>
<div>actuate.load("dashboard");</div>
<div>actuate.load("viewer");</div>
<div>actuate.load("parameter");</div>
<div>var reqOps = new actuate.RequestOptions( );</div>
<div>reqOps.setRepositoryType(actuate.RequestOptions.REPOSITORY_ENCYCLOPEDIA);</div>
<div>reqOps.setVolume(volume);</div>
<div>actuate.initialize(fTypeServerURL, reqOps, userId, passWd, dashboardOrReportCallBack);</div>
<div> </div>
<div>Anything wrong authentication and storing session?</div>
<div> </div>
<div>Thanks,</div>
<div>Srinivas</div>
JFreeman
<p>What browser you are using?</p>
<p> </p>
<p>One thing that I have noticed in your JSP page is that there are some typos that could be causing some issues.</p>
<p>For example, the variable you are set for the user id is mistyped when it is set:</p>
<pre class="_prettyXprint _lang-js">
var uerId = '<%=userbean.getUserId()%>';
..
..
actuate.initialize(fTypeServerURL, reqOps, userId, passWd, dashboardOrReportCallBack);
</pre>
<p>After correcting some of these errors and modifying the JSP page for my environment, I am able to drill through successfully in Chrome.</p>
JFreeman
<p>As a quick follow up, I just tested in IE 10, Firefox and Chrome and the drill through is working properly for me in all three browsers.</p>
Srinivas Yarra
<p>Hi Jesse,</p>
<p> </p>
<p>We are using IE 11, Chrome <span style="color:rgb(48,57,66);font-family:'Segoe UI', Tahoma, sans-serif;font-size:12px;">Version 41 and Firefox </span>36. Whenever we click on first report bar then it is opening new window and asking authentication. if we enter user/password correctly then it is working. But we don't want ask authentication in drill down window.</p>
<p> </p>
<p>Thanks,</p>
<p>Srinivas</p>
JFreeman
<p>Is drill through happening from a dashboard or a report?</p>
<p> </p>
<p>Have you corrected the errors in the JSP page, such as setting the userId?</p>
Srinivas Yarra
<p>Hi Jessi,</p>
<p> </p>
<p>We have corrected error in jsp page. We have dashboard and it is internally using report. we have implemented drill down functionality at report level.</p>
<p> </p>
<p>Thanks</p>
<p>Srinivas</p>
JFreeman
<p>To make sure I am understanding correctly, you are loading a dashboard that has a report gadget which is loading the report with the drill down functionality that is having the issue?</p>
Srinivas Yarra
<p>yes Jesse. Dashboard has a report gadget and gadget report has drill down functionality. It has issue while drill down this report.</p>
<p> </p>
<p>Thanks</p>
<p>Srinivas</p>
JFreeman
<p>I modified the JSP again to be using a dashboard with a report gadget that loads a simple sample report with a drill down to a second report that opens in a new window.</p>
<p> </p>
<p>After this, I am still not able to replicate the issue. The dashboard loads properly and the drill down opens properly in all three browsers.</p>
<p> </p>
<p>Try out the attach JSP, dashboard and reports I used and see if you are still having the issue.</p>