[prashantgo]

I have run into an issue. In my report i have 2 reports. One report is always visible. What i have done is that i have created a button "show report". Now on clicking on it the second report report is shown and clicking again that report is minimized. But this process takes a lot of time even after doing it once. Is there no caching mechanism in birt..? After generating a report once shouldn't hiding and unhiding take minimal amount of time.

[mwilliams]

So, you have a two part report in a single design. When first ran, one part shows and the other part is hidden using the visibility property. When you click on a link to show the other report, the report is re-run with a new parameter value or something so that the first part is now hidden and the second part is shown. Is this the case? Let me know. Also, let me know your BIRT version.

[prashantgo]

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

So, you have a two part report in a single design. When first ran, one part shows and the other part is hidden using the visibility property. When you click on a link to show the other report, the report is re-run with a new parameter value or something so that the first part is now hidden and the second part is shown. Is this the case? Let me know. Also, let me know your BIRT version.

No this is not what I meant. I have 2 reports one is always shown and one is shown on alternate clicking of the link "show 1st report". The problem is on clicking the link, BIRT does some processing to show the report. Now on again clicking the button to hide the report again a lot of processing is done to hide the report. This processing is done everytime we click on the button. I assumed there should be some caching mechanism so that this does not take time. My BIRT version is 4.2.0

[mwilliams]

Oh. Sorry. I misread before. I thought on click you showed the other and hid the first. Instead, you have two tables and on click, you show the second. Then, onclick again, you hide the second. Is this the case? If so, are you reloading the report, each time, with a drill through?

[prashantgo]

mwilliams, on 18 July 2012 - 09:33 PM, said:

Oh. Sorry. I misread before. I thought on click you showed the other and hid the first. Instead, you have two tables and on click, you show the second. Then, onclick again, you hide the second. Is this the case? If so, are you reloading the report, each time, with a drill through?

No, what i have done is create a label which is hyperlinked to the same report i.e drill through but to the same report. Now using a javascript i have set that label's value to be false initially and it switched between true and false on clicking it. Whenever it is true the 1st report shows else it is hidden.
To the question of drill through, yes i have used drill through but to the same report , maybe that's why it is taking time...
Any suggestions how to make this instantaneous change??

[mwilliams]

Take a look at this report.

Attached File(s)

•  DynamicallyHideShowSecondSection.rptdesign (64.17K)
  Number of downloads: 8

[prashantgo]

mwilliams, on 18 July 2012 - 10:14 PM, said:

Take a look at this report.

Thanks a lot, it solved my problem.

Now the thing is that that i want the second report to change on clicking on some value of 1st report. But if do drill through what happens is that the whole page is reloaded. Is it possible that only the 2nd report is reloaded and 1st remains over there.

[mwilliams]

Do you have to reload the data? Or can you just change the value in the second table? To reload the data without reloading the report, you'll probably have to use AJAX. If you already have code that changes the value in your database and can live with just changing the value in the web page, this can be done fairly easily. Let me know.

[prashantgo]

mwilliams, on 19 July 2012 - 05:58 AM, said:

Do you have to reload the data? Or can you just change the value in the second table? To reload the data without reloading the report, you'll probably have to use AJAX. If you already have code that changes the value in your database and can live with just changing the value in the web page, this can be done fairly easily. Let me know.

It's like the first report passes parameters to the second report i.e based on what user clicks on the first report a second report is generated. One solution to do this was to genrate the second report for all possible options in the first report and hide them all and unhide the one which user clicks on. But this will take large processing time. What i want is that on runtime when the user clicks the second report is generated. But the first report stays over there and only the second report loads.

[mwilliams]

Ok. I'm with ya, now, I think. Well, it would seem that your options are to run the long processing time to run it real time, each time, run the report at certain intervals and save a static copy of the html output for viewing purposes, so you can avoid the long processing time when viewing, or make AJAX calls to your database and build the second report dynamically in a text box. There might be some other options, as well.

[prashantgo]

mwilliams, on 19 July 2012 - 12:19 PM, said:

Ok. I'm with ya, now, I think. Well, it would seem that your options are to run the long processing time to run it real time, each time, run the report at certain intervals and save a static copy of the html output for viewing purposes, so you can avoid the long processing time when viewing, or make AJAX calls to your database and build the second report dynamically in a text box. There might be some other options, as well.

yaa..AJAX would be right...can you provide me an example using AJAX call to do something like this...
My BIRT version is 4.2.0...
Thanks !

[mwilliams]

Take a look at this:

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

[prashantgo]

Thanks a lot!
Will look into it and if anything comes up, will keep you posted!

[mwilliams]

That'd be great! If you get it working, if you'd post a detailed explanation of what you did, in a devShare write up, it could be helpful to many people. Also, you'd be entered in the monthly devShare contest.

http://www.birt-exch...e_Month_Contest

[prashantgo]

mwilliams, on 23 July 2012 - 07:18 AM, said:

That'd be great! If you get it working, if you'd post a detailed explanation of what you did, in a devShare write up, it could be helpful to many people. Also, you'd be entered in the monthly devShare contest.

http://www.birt-exch...e_Month_Contest

Hey !
I am facing certain issues regarding the AJAX call. If possible, could you generate an example for me in BIRT.
Thanks

[mwilliams]

The earliest I'd be able to try this would probably be next week. What issue are you having with this?