Optional datapoints URL parameters

Hi, I'm currently working on some charts with drill-throughs (2.6.2), and I am trying to use the Optional datapoints URL parameters under 'Advanced' in the Hyperlink Editor when I add interactivity. I haven't been able to find much documentation on how this is used. I'm fairly well versed in BIRT but I cannot seem to figure out the syntax or get it to work. I've set up parameters and tried referencing them as it seems that is what they're looking for. If anyone had an example or just some insight on these that'd be greatly appreciated.

Thanks,
Bryan

Find more posts tagged with

Comments

mwilliams

Hi Bryan,

Say you have a report named rpt1 that has a chart. It drills through to a report named rpt2. In rpt2, you have a parameter named CS that takes the value of the category series value, a parameter named VS that takes the value series value, and one named VSN that takes that value series name value. In your advanced section of your drill through, on your chart in rpt1, you can name these parameters in the text boxes. You just enter CS in box 1, VS in box 2, and VSN in box 3. The values are then automatically assigned to these parameters through the URL. When you do this with a drill through, you don't have to select the parameters in the drill through wizard screen. Whatever you're linking to, you can name the URL parameters that these 3 values are sent through in the URL created by the hyperlink. Hopefully this explanation makes sense!

I can send an example if need be. Let me know.

bcs0629

Hey Michael, thanks for the reply, you're explanation cleared up how that is used for me. Am I correct in saying that you aren't able to use a dynamic value with this? It seems as if the only way I could pass the value was by selecting a static value and assigning the default value. If you use a dynamic value, the report will be blank until you select Run Report and select the parameter (Birt Viewer). I'm not sure if it's possible to do what I'm trying to do. I have rpt1 which is a radar chart with 5 categories. In rpt2, I have a pie chart with the same categories which contain more details. In rpt1, when I click on a marker which represents the value for a certain category, it should drill-through to rpt2 passing the category of the value I just selected into the parameter, which would generate the rpt2 chart for only that category. Is that possible? Your example would be appreciated also, just ensure I've got mine set up correctly.

Thanks,
Bryan

mwilliams

Bryan,

Yes, your requirement should be able to be done. In your second report, you should just create a parameter to bring in the category value, which you could then use in your query to limit the returned values to this category only. In the first report, you'll set up the drill through hyperlink. You can either put the static name of the parameter that you made in the second report into the category text box under advanced, or you can select the parameter from the drop down in the drill through editor, where you select your report design you're linking to, and set the value you want to pass there. Either way should do it. Let me know if this gets you to what you're trying to do or if you would like to me to set up that example showing this!

bcs0629

I'm good to go, the report behaves exactly as I was intending. Thank you for the help, that feature had always been a bit murky to me but the way you laid it out made it simple understand it's function.

Thanks,
Bryan

mwilliams

Good deal! Glad to help! Let us know whenever you have questions!