[charas]

Hello Birt-community!

This is my first post here . I searched a long time for my problem, but didn't find anything.

So here is my question.

I have a Table in my db2 database: Example: Customername (string) | isListed (bool)

In my Birt-report is a data-field which is simultaneously a hyperlink (the hyperlink shows the boolean value of each customer.

Example:

Peter | Yes
John | No

If i press the hyperlink, the value in the database is changing from Yes to No and vice versa.
This works fine. Now my question: Is it possible to refresh only the hyperlink (after clicking it) without reloading the whole report?

Example: Peter | Yes -> clicking hyperlink 'Yes' -> Peter | No

I hope you understand my problem =)
If there is no possibility, how i can reload my birt -report after clicking the hyperlink?

Best regards and thank you for your help!

[mwilliams]

You could probably make yes and no links for all names and then use client side javascript in html script tags in a text control to switch which one is visible on click. If you'd like me to try to make you an example, let me know your BIRT version.

[charas]

Hi again,
thank you for the reply! Do you think it's the only solution? I tried something with a textbox. I binded the boolean value to the html button - this works fine! Now i tried with javascript to start my php script. This works also, but somethin strange happend. I called the script with "windop.location.href" - the problem is, that my php script is opening in my birt - window! I tried other ways to open it in an seperate window. Strange: in the seperate window my php file doesn't work correct. After starting the php file i reload the birt page also - this is working also.

Is there a possibility to go this way?

regards charas


EDIT: I solved it now with a complete refresh of the report - HTML with Javascript. Works fine!

If I find some time, i will try your idea also.

Tanks for the help!

[mwilliams]

So, you're just refreshing the entire report now, each time? Tell me your version and I'll make you a sample.

[johnw]

You should be able to use just Javascript and update the innerHtml element of the Hyperline. So give the Hyperlink a Bookmark, then use document.findElementById in Javascript. Just old school HTML/Javascript should work. You should only need to change the value.

[mwilliams]

That's what I was going to do in the example I'd have made, John!

[charas]

mwilliams, on 02 July 2012 - 01:44 PM, said:

That's what I was going to do in the example I'd have made, John!

That would be very helpfull! Thank you =)

kind regards

[mwilliams]

charas,

What's your BIRT version?

[charas]

mwilliams, on 06 July 2012 - 08:40 AM, said:

charas,

What's your BIRT version?

Here is my Birt-Version: 3.2.22

regards charass

[mwilliams]

Take a look at this simple example.

Attached File(s)

•  SwitchLinkLabelOnClick.rptdesign (12.14K)
  Number of downloads: 8

[charas]

Hi again!

Thank you for the example. I will try it in the next few days.

Kind regards

[mwilliams]

Sounds good. Let me know if you have questions.

[charas]

I tried it out.

The link shows me first the correct value of the Dataset - "No". After clicking the value is changing to true than false and so on.

Usually this link should show us the values from the Database (No/Yes). I try to explain the problem:

I start the report -> the first shown value of the link is 'No' (because there is no User in that table called for example "Andrew") - that's correct. Now I am pressing the link. Immediately the value from the link is changing from No to true and a new window opened - the php script is starting. Usually the value of the link should change AFTER the php script finished. So the DataSet has to be refreshed also.
The link usually should show us "Yes" after clicking (because now "Andrew" is listed in that table - the php script added "Andrew" into that table). Instead to change the value from "No" to "Yes" it has the value "true". If I'm clicking it again, the php script deletes "Andrew" from the table - now the value of the link should be "No" instead the value is false.

So the value of the link is changing only from true to false and vice versa - the output from the Dataset doesn't matter.

I hope everybody understand my problem.

Kind regards

[mwilliams]

I was just showing how to change the displayed value in your report without re-running it. If the code you have to change the db value works correctly on click, then the same value should be in the report and what is in the db. I used true and false, in my script. You'd just need to change it to yes and no. Maybe I'm misunderstanding your issue.

[charas]

mwilliams, on 13 July 2012 - 11:01 AM, said:

I was just showing how to change the displayed value in your report without re-running it. If the code you have to change the db value works correctly on click, then the same value should be in the report and what is in the db. I used true and false, in my script. You'd just need to change it to yes and no. Maybe I'm misunderstanding your issue.

Hi again =)

The button/link which shows us Yes/No or True/False, should get this information from a table in my database. If you click on that button/link, there is a php script which is changing this value in my database. In the same time the link/button should get the new value from the database - not just switching from "Yes" to "No" or vice versa. Usually the report gets data while it's loading. But in my case the report should only reload one dataset (the dataset which get the data of the table i mentioned before) when the link/button was clicked and renew the value of that link/button.

Kind regards

[mwilliams]

To not reload the report, but to get the data from your database, you'd probably have to do an AJAX call, or something. Take a look at this link.

http://www.w3schools...ax_database.asp